How to access the link between OTBI column names to fields in the Oracle data tables

Rachel_

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?

gclampitt

Use the lineage mapping spreadsheet

https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26171/how-to-access-the-link-between-otbi-column-names-to-fields-in-the-oracle-data-tables

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'.

R13_25A_FIN_OTBI_database_mapping_with ViewObjects.xlsx

You can get the details below:

https://community.oracle.com/customerconnect/discussion/40268/r13-financials-otbi-subject-area-to-database-lineage-mapping-spreadsheet

Hope this help.

Thank you.

Rachel_

thanks - I require the informatin for the procurement subject areas. The above responses relate to HCM and Finance

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/68414#Comment_68414

Hi @User_BAITI,

Please take a look into the following.

R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet — Cloud Customer Connect

Hope this help.

Thank you.