R12 - Performance Issue When Baselining A Budget With Large Number of Lines
(Doc ID 970354.1)
Last updated on FEBRUARY 03, 2019
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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!