cancel
Showing results for 
Search instead for 
Did you mean: 
Tristan
Employee
Employee

OTBI Lineage

With the Oracle Cloud ERP applications, Oracle provides the same functionality but not the same direct database access to work with tables.  If you want to extract data, instead of writing a SQL statement, Oracle provides pre-built View Objects (VO’s) that you can extract with current data to flat files from OTBI to UCM. These VO’s do not have the same name as the tables from previous versions of Oracle ERP (EBS).  This can make it a bit difficult to figure out how to get the data you are looking for if you are used to working with tables.  Fortunately, Oracle provides mapping files that correlate the VO’s to tables in case you need to build out a data model.

There are two types of VO’s that Oracle provides.  Public View Objects or PVO’s contain columns from multiple tables.  Extract View Objects or Extract VO’s map one to one with Oracle ERP tables.  The mapping files provide references to both types of objects by table name.

Files

The mapping files are available for download on Oracle’s Support site here.  If you do not have an Oracle Support account, you will need to sign up for one to access the files.

Screenshot 2024-07-08 at 5.12.07 PM.png

The files from Q2 2024 are also attached to this posting.

Oracle has quarterly updates to their Cloud ERP applications.  These include enhancements and bug fixes.  In addition to changes to the software, they also expand their View Object library and, in conjunction with that, release updated mapping files, so check back each quarter for the most up-to-date files.

OTBI Dashboard

Incorta provides a dashboard that allows you to quickly identify the name(s) of the VO(s) that correspond to a particular table you are looking for or vice versa.

Screenshot 2024-07-08 at 4.52.15 PM.png

Exports of the dashboard and supporting schema definition are available attached to this posting.  When a quarterly update of the mapping files becomes available, you can download them from Oracle Support and then upload them with overwrite into your instance of Incorta in the BICCDbMapping folder to get the latest mappings.

What To Do If You Cannot Find A Table

As of now, Oracle has not released VO’s that correspond to every table from every production release ERP module.  If you are using the latest mapping files and are not able to find the table in the dashboard or in the files themselves, then your only way to get data from the table is to write a BIP report.  See Oracle documentation for how to write a BIP report.  Additionally, it would make sense to create an Service Request (SR) with Oracle to ask that an extract VO be created for the table.

Best Practices Index
Best Practices

Just here to browse knowledge? This might help!

Contributors
Version history
Last update:
‎07-16-2024 07:51 AM
Updated by: