OBIA 11g: "SILOS_SIL_PURCHASERECEIPTFACT" Performance Issue In Full Load

(Doc ID 2327509.1)

Last updated on JULY 09, 2018

Applies to:

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

Symptoms

On OBIA 11.1.1.10.2, full load for SILOS_SIL_PURCHASERECEIPTFACT takes 35 hours to load.

Time the session takes to load: 335220 sec = 5587 mins = 93.12 hrs

Records being loaded: No. of Inserts 425107

                                 No. of Updates 0

                                 No. of Deletes 0

                                 No. of Errors 0

                                 No. of Rows 425109

Environment details:

Source System/version: EBS 12.1.2

Source DB version : 11.2.0.2

Target DB Version : 11.2.0.2

BI Apps modules being used: Financial and Procurement & Spend

Changes

 

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