Update Project Performance Data Program Slow and Child Process Errors Out
(Doc ID 2621124.1)
Last updated on DECEMBER 16, 2019
Applies to:Oracle Fusion Project Performance Reporting Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.
On : 11.13.19.04.0 version, Performance
When scheduled "Update Project Performance Data Without Producing Report" daily takes too much time to complete than average time and it is completing in "Warning" status
One child process - "Maintain Project Performance Data: Maintain Oracle Essbase Cube" of UPPD program which is completing in Error.
WARNING:ESS-01709 Database job for request 5643598 ended with warning: SQL execution error. JobName: "FUSION_RUNTIME"."ESS1$JB_5643598" --- SQL Execution Error --- ErrorCode: 20909 ErrorMsg: [ORA-20909: Request 5643598 exited with WARNING: :] --- SQL Error Detail --- [Error_Stack] ORA-20909: Request 5643598 exited with WARNING: : [Error_Backtrace] ORA-06512: at "FUSION.FND_EXECUTE", line 330 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SQL", line 1707 ORA-06512: at "FUSION.FND_EXECUTE", line 413
The request has completed and is in a terminal state.
Request run resulted in a WARNING
The issue can be reproduced at will with the following steps:
1. Scheduled scheduled "Update Project Performance Data Without Producing Report" to run at 11PM UTC daily
It takes too much time to complete than average time and it is completing in "Warning" status with above warning message
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