UPPD Batches Error with ORA-06512: at "APPS.PJI_FM_PLAN_MAINT_PVT", line 13026
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