Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to access the link between OTBI column names to fields in the Oracle data tables

I'm designing reporting using OTBI, however there may be a requirement to query the tables directly using BIP. I would like to understand, where I am selecting columns for OTBI reports, how I can understand the corresponding name of each column within the data tables, e.g: where I am using subject area Procurement - Purchasing Real Time in OTBI, what is the equivalent in PO_LINES_ALL?
Answers
-
Use the lineage mapping spreadsheet
0 -
Hi @User_BAITI,
Welcome to the Oracle Analytics Community.
Please take a look into the following 'Financials OTBI subject area to database lineage mapping spreadsheet'.
You can get the details below:
Hope this help.
Thank you.
0 -
thanks - I require the informatin for the procurement subject areas. The above responses relate to HCM and Finance
0 -
0