BIP - how to find fields from a screen

Geraud Andreux

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Euroclear

Hello,

we are often faced with the request to produce a report, interface or other extraction, and most are too complex for OTBI.

This means we have to use BI Publisher and SQL queries. But an enormous challenge is to find which table contains the field we can see on the users' screens. Or the name of the field itself, for that matter.

The main document available, listing all the tables and their fields, contains hardly any usable information besides the field names, which may or may not resemble the labels on the screens. Using search queries against the all_tab_columns table brings similar results much faster.

What we would need would be any one of these options (roughly sorted from just useable to really good):

• Option A: a way to run a meta query against the whole database, searching for a particular value. We could then enter some specific unique value in the target field (e.g. "TestABCD"), and run this seach to find in which table/field it sits.
• Option B: a relatively "dumb" tool to display the immediate table.field name of each field on each screen. Some online "reveal" tool available in the application would be great, maybe in a sandbox or such.
• Option C: a simple but thorough list in excel showing "navigation / screen name / field label / table.field" would probably work also. We could quickly infer the main table name, the setup ones, the parent and child objects, etc.
• Option some clear documentation behind each screen, written by a knowledgeable human, describing in plain English the architecture of each screen, the main table(s), with an ERD (entity relationship diagram) linking them together

Case in point: we are trying to find where the data is for some of the most recent module (journeys) and their approval data. So far no-one we have not been able to, despite having 3 integrators, spending many hours poking at promising tables and raising two SRs on this subject.

I you feel the same need, thanks to upvote this idea and, Oracle, thanks to consider it quickly!

Best regards,

Géraud

Anders W. Langholm

It would be so nice to be able to just click and get the field- and tablename, instead of this endless search to figure out where the fields are stored... It's not always as straightforward, as you'd hope and think...?