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
