Review Database Lineage Mappings and View Objects

Before you extract data, you must know the BI View Objects (VOs) and their attributes. The data store guides describe the view objects and attributes that can be used for extracting data out of your application instances.

Use the Extract Data Stores guides available for the following offerings:

• Oracle Fusion Cloud SCM Extract Data Stores for SCM
• Oracle Fusion Cloud Procurement Extract Data Stores for Procurement
• Oracle Fusion Cloud Financials Extract Data Stores for Financials
• Oracle Fusion Cloud Customer Experience Extract Data Stores for CX Sales and Fusion Service

You can also review the mapping of VOs to the corresponding database tables and columns available in lineage spreadsheets hosted on the Oracle Cloud Customer Connect site.

Note: Lineage only includes data stores that have predefined extract definitions and are shipped with Oracle Fusion Cloud Applications. Non-standard data stores and attributes aren't available.

To review the mappings, follow these steps.

1. Click the link here that corresponds to your offering and navigate to the Oracle Cloud Customer Connect portal.

   • R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet

   • R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet

   • R13.x CX BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet

2. On the Reporting and Analytics page for your product, review the information and click the link to the recently published .zip file.

3. On prompt, download the .zip file to a location on your local computer.

4. Extract the contents of the .zip file. The extracted folder contains spreadsheets that list the mappings of the BI VOs to database tables and columns.

5. Use the information in the spreadsheet to search for a View Object, the corresponding Database Table and Database Column.

   Tip: Use the filters to narrow down and find names of the VOs that are required for your extracts.

To learn more about the tables and columns for the respective product areas, see the corresponding Tables and Views guides.