Projects - EBS (MOSC)

MOSC Banner

UPPD Batches Error with ORA-06512: at "APPS.PJI_FM_PLAN_MAINT_PVT", line 13026

edited Feb 14, 2013 3:20AM in Projects - EBS (MOSC) 6 commentsAnswered ✓
Hello,

We schedule PRC: Launch Update Project Performance Data every evening, and some batches regularly error with the following log.  Some evenings none error, and other evenings, more than one error.   The batch usually goes through the next time, or the time after.  If we resubmit the batch individually, I have never observed one to fail.  We would have a lot of difficulty with an SR because we cannot control the replication of the error.  Are you familar with this error, and is there a resolution for it? 

Thank you, Kevin

+---------------------------------------------------------------------------+
Project Intelligence: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

PJI_PJP_SUMMARIZE_INCR module: PRC: Update Project Performance Data
+---------------------------------------------------------------------------+

Current system time is 11-FEB-2013 19:59:49

+---------------------------------------------------------------------------+

**Starts**11-FEB-2013 19:59:50
**Ends**11-FEB-2013 20:02:09
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-06512: at "APPS.PJI_FM_PLAN_MAINT_PVT", line 13026
ORA-01403: no data found
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
: =======Concurrent Program Parameters Start =======
: Argument => Operating Unit []
: Argument => Project Organization []
: Argument => Project Type []
: Argument => Project Status []
: Argument => From Project Number [UPP-BATCH-R-10049-2]
: Argument => To Project Number [UPP-BATCH-R-10049-2]
: =======Concurrent Program Parameters End =======
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size: 
0


Finished executing request

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center