My Oracle Support Banner

R12: Performance Issue When Baselining A Budget With Large Number of Lines (Doc ID 970354.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Project Planning and Control - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Performance issue when submitting a financial plan for baselining using Oracle API's.
The issue occurs for budgets with budget lines over 500

Problem query:
INSERT INTO PJI_FP_AGGR_PJP1_T ( WORKER_ID, RECORD_TYPE, PRG_LEVEL, LINE_TYPE, PROJECT_ID, PROJECT_ORG_ID,
....
IS NOT NULL AND (SUP_FIN_VER.PROJECT_ID IS NOT NULL OR SUP_WPA.PROJ_ELEMENT_ID IS NOT NULL)))


Happening mostly when the project has over 500 tasks.
In some cases it is taking over 6 hours to process.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.