EBS Customizations (MOSC)

MOSC Banner

API to identify whether form/web (oaf) interface using sql

edited Mar 11, 2015 9:52AM in EBS Customizations (MOSC) Question

Hi All,

Is there are way to identify the interface in which the query is being run - Forms or OAF page - using sql?

Why do I need this?

   There is a table type validation query we are using to display Yes/No values in a DFF segment.

   The select query is like this

             SELECT meaning, lookup_code

             fnd_lookup_values

             WHERE LOOKUP_TYPE = 'YES_NO_LOOKUP'

             AND ENABLED_FLAG = 'Y'

             AND LANGUAGE = USERENV('LANG')

    This is store the translated value in backend from OAF page as per user language.

  

    If one stores information in French in the DFF segment(Forms/OAF interface) and views the same using Forms interface in English, it will display error message that value is not present in value set.

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