Q
Problem solve Get help with specific problems with your technologies, process and projects.

Determining which table and column a field is stored in

Is there a way in Oracle Applications 11.5.9 using RDBMS 9.2 to place the cursor on a particular field in a window and be able to determine which primary Oracle table and column name that field is stored in?

Is there a way in Oracle Applications 11.5.9 using RDBMS 9.2 to place the cursor on a particular field in a window and be able to determine which primary Oracle table and column name that field is stored in? For example, if I am in Oracle Projects in the Find Projects window and my cursor is sitting in the Project Number field, how can I determine that the value is stored in table PA_PROJECTS_ALL, column Segment1? Is there a way to do this?
There is no 100% all-the-time way, but there are a few tricks you can use that work most of the time.

To get the database table: From the application menu, go to Help/Record History. This will tell you which database table/view the form uses for storing data. The object listed will usually be a view. You can look up the view definition from DBA_VIEWS to get the underlying table. Some forms will tell you that record history is not available. At that point, enlist the help of an application developer who can look at the form definition to get you the information.

To get the column name from the form: Place your cursor in the field you want from the application menu: Help/Diagnostics/Examine. (It may prompt you for a password; use the APPS password.) This will tell you the forms block name and field name.

Hope this helps,
Russell

Dig Deeper on Oracle E-Business Suite

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close