Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, September 29, 2011

Hidden Methods to Query Oracle Apps Forms -- Very Useful

- Display only records where a particular column is null
- Display only records where column is greater than or less than a certain value
- Display only records where data is in certain range of value etc etc....

Press Function Key F11 to enter into query mode and Ctrl+F11 to run the query.
Hash(#) is the magic key here

Below are few examples with screenshots. As an example I have taken the FND_MESSAGE form which is available in the Application Developer responsibility.

Navigation : Application Developer-->Application-->Message

Condition1: Display all records where Number is NULL(#IS NULL)
Condition2: Display all records where Number is Not null(#IS NOT NULL)
Condition3: Display all records where Number is Greater than 2000(#>2000)
Condition4: Display all records where Number is Between 1001 and 2002(#BETWEEN 1001 and 2002)
Condition5: Display all records where Number in 1000, 2000 (#IN (1000,2000))


No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect