EBS Customizations (MOSC)

MOSC Banner

Default DFF attributes in OAF page using personalization

edited Feb 5, 2015 10:02AM in EBS Customizations (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center