My Oracle Support Banner

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.

Symptoms

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

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


STEPS
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

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.