OBI Apps: Performance Issue with BOM Explosion Procedure ETL (Doc ID 1333533.1)

Last updated on MARCH 08, 2017

Applies to:

Data Warehouse Business Adapter for Oracle - Version 7.9.6 [1340] to 7.9.6.3 [AN 1900] [Release V7]
Business Intelligence Applications Observer - Version 7.9.6 [1340] to 7.9.6.3 [AN 1900] [Release V7]
Information in this document applies to any platform.

Symptoms

This document is about unpublished Bug 10332524 - It applies to Data Warehouse Business Adapter for Oracle - Version: 7.9.6.3 or lower with Oracle EBS using BOM as the source system.

SDE_ORA_BOM_Explosion performs badly while executing the explosion procedure OPI_OBIA_BOMPEXPL_WRAPPER_PKG.OBIA_SP_CALL.

Cause

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