PLP_PROJECT_GLRECONCILIATIONFACT Is Running Very Slow In Incremental Load

(Doc ID 2200623.1)

Last updated on OCTOBER 18, 2017

Applies to:

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

Symptoms

- BI Apps version/Patches: -- 11.1.1.8.1
- BI Apps modules: -- "Finance and Procurement & Spend"
- Source System/version : PSFT 9.2
- Target Database System/Version: 11.2.0.4


PLP_PROJECT_GLRECONCILIATIONFACT is running slow in Incremental load, this mapping is taking 76 minutes to complete during incremental load.
Out of 76 min to complete complete mapping, interface W_PROJ_GL_RECNCLIATION_F_GL took 73 and inserted 0 rows.

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