OBIA 11g: BOM Explosion Schema Objects For EBus (Doc ID 1628853.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

We are deploying OBI Applications 11.1.1.7.1, with eBusiness 12.1.3 as a source.  With Financials, Supply Chain, Procurement & Spend applications.

We need to deploy the objects to support the BOM Explosion area of the ETL, as none of the objects (i.e. stored procedures, tables).

Section B2.12 of the setup guide (E36171-03, Configuration Guide for Oracle Business Intelligence Applications 11.1.1.7) stipulates that the eBusiness patch level required is 16037126:R12.OPI.B.  When searching for this patch on oracle.com, it says it has been superseded but no information on what by.

How do we get the DDL scripts to create the necessary objects in the eBusiness database, for this release of the OBI Applications?  I do not want to use prior release ones (i.e. from v7.9.6.x) as I do not know if they are compatible - unless you advise they are and supply the script please.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms