My Oracle Support Banner

PRC: Delete Project Performance Reporting Data Completes With Error ORA-12838 ORA-6512 (Doc ID 748674.1)

Last updated on NOVEMBER 06, 2018

Applies to:

Oracle Project Management - Version 11.5.10.2 to 12.0.4 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.


PJI_SUM_CLEANALL - Truncate PJI Summary Tables
PJI_PJP_SUM_CLEANALL


Symptoms

Process PRC: Delete Project Performance Reporting Data
completes with an error :

ORACLE error 12838 in FDPSTP
Cause: FDPSTP failed due to ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-06512: at "APPS.PJI_PJP_EXTRACTION_UTILS", line 671
ORA-06512: at line 1

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.