My Oracle Support Banner

Update Project Performance Data Without Producing Report In Error And Runs During Days (Doc ID 2614790.1)

Last updated on NOVEMBER 26, 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.07.0 version, Performance

Update Project Performance Data Without Producing Report went in error and running for more days


ERROR
PJS_SUM_ATOMIC_PROCESS.GET_COMMITMENTS_NEW: ** Handled Exception : ORA-01476: divisor is equal to zero


STEPS
The issue can be reproduced at will with the following steps:
1. Scheduled daily following job : Update Project Performance Data Without Producing Report (PjsSumMainJobDefNonBIP)
Its children are launched : Update Project Performance Data: Helper Subprocess (PjsSumHelperJobDef)

But since some time, the process ending in warning after a very long time
The child jobs Update Project Performance Data: Helper Subprocess (PjsSumHelperJobDef) end in error sometimes after several days

Some occurrences are automatically launched from 'Import Costs' program.

 

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.