Default DFF attributes in OAF page using personalization
Hi All,
I have a requirement to default a DFF attribute in the OAF page. I enabled the DFF attributes using personalization and currently I'm able to default the attribute value with a sequence. Given below the steps which I followed, and it is working.
- Enable the DFF and define the attribute
- Default Type: SQL Statement
- Default Value: Select XX_TEST_S.nextval from dual
- Map the above DFF in the supplier page using personalization
Now there is an additional requirement, where the default value of the above DFF attribute is the output of a plsql function (function takes input parameters from the OAF page). Can I invoke a function in the above select statement, passing the OAF page values (say supplier OAF page, supplier number) and use the value returned from function as default value for the DFF attribute.