R12 - Performance Issue When Baselining A Budget With Large Number of Lines

(Doc ID 970354.1)

Last updated on MARCH 08, 2017

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.
For one project sometimes taking over 6 hours to process.

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