R12 - Performance Issue When Baselining A Budget With Large Number of Lines
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.
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.
For one project sometimes taking over 6 hours to process.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms