How to Configure a Record Group Query of List of Value in EBS Forms

Here are the steps to find the List of Query without opening Forms in Form builder. This could be useful during form personalization to change the record group query, to debugging the issue etc;

Step 1 : Find the name of the form. (Help -> About Oracle Applications)

Step 2 : Invoke the List of values. Enter the filter condition and Click Find Button.

Step 3 : Keep the screen in the above state. Open the database session connecting to APPS schema and execute the below SQL.

SELECT (SELECT TO_CHAR (sql_fulltext)

           FROM v$sqlarea

          WHERE sql_id = ses.prev_sql_id ) sql_behind_lov