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.
Performance issue when submitting a financial plan for baselining using Oracle API's.
The issue occurs for budgets with budget lines over 500
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.
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