Friday, June 18, 2010

Query on Oracle Forms

Searching in the Oracle EBS forms was simple and straightforward for me until last week.
I have learned two ways to increase search capabilities in the forms:
1- Press f11 to turn on the query mode, help>diagnostics>examine then you
can select any field which you know and doesnt seem on the form screen (such as id) then press ctrl+f11...
2- In query mode you can query by conditions like "<,>, is (not) null". Firstly type "#", secondly your condition then execute the query with ctrl+f11 ...

No comments:

Post a Comment