Best Practices from Oracle Development's A‑Team

Fusion SaaS - Finding The View Object You Need for Data Extracts

For other A-Team articles by Richard, click here


For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against.

The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool.  This pulls data from 'View Objects' in the Business Intelligence layer of Fusion SaaS.  Other tools can also extract from these view objects.

BI Apps customers have pre-created ODI mappings, that take the data from view objects, and load that into a pre-created data warehouse model.

For everyone else, there will be a certain amount of 'figuring out' which View Objects house the data you need, and then what are the data types, and the keys to join on.

This short article will walk through the steps to find which View Objects house the data needed.

Getting the Name of the View Object

Setting up an extract with the BI Cloud Connector, requires the name of the View Object.

Most fusion pillars provide an excel spreadsheet download that details the data available in extracts, and how that maps to the view objects.

1. Open a browser, and go to this page, and select the appropriate link in the section 'How to Review View Object Data Lineage Mappings'

2. Follow the link and download the applicable spreadsheet for the release of fusion, typically the latest one, and use that to figure out the view object that you need to use for your data extract(s).

The spreadsheets provide information on Bi View Objects and columns, as well as the Fusion Database Table and Column names.

Use the filters in the columns to narrow down and find the names of the View Object(s) that are required for your extracts.  These can then be used in the BI Cloud Connector, or other extract tool, to select and extract the data required for your downstream processes.


This article walked through the steps to identify which View Objects house the data required for Fusion SaaS data extracts.

For other A-Team articles by Richard, click here


Join the discussion

Comments ( 1 )
  • Edgar Monday, April 29, 2019
    Hi Richard,

    Only to confirm ... These replications or data extractions, as far as I understand, are based on the subject areas of Analytics, but you can not have direct access to all the Oracle Fusion Cloud ERP tables.

    For example, if I need to obtain detailed data from a physical inventory, which are not available in any subject area, I could not access that data, which is contained in the INV_PHYSICAL_ADJUSTMENTS table.

    Thanks for your help!
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha