My Oracle Support Banner

Crediting And Rollup Error ORA-20011: Approximate NDV failed ORA-08103: object no longer exists ORA-01410: invalid ROWID (Doc ID 2473283.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

Running Crediting and/or Rollup for a specific period the process completes in error.

ERROR
-8103 : ORA-08103: object no longer exists
-20011 : ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel query server P003 ORA-08103: object no longer exists
-1410 : ORA-01410: invalid ROWID
-60 : ORA-00060: deadlock detected while waiting for resource


STEPS
Run Crediting and Rollup ( as a single job )  or Run Crediting

Changes

Release 13.18C was just applied to instance.

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
Changes
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.