Friday 22 January 2016

ORA-04021: timeout occurred while waiting to lock object

http://admsipl.blogspot.com/2016/01/ora-04021-timeout-occurred-while.html

Executing request completion options...

Output file size:
2640

+--------- 1) POST-PROCESSING  ---------+
Beginning post-processing of request 1482046 on node HUBCOERP at 20-JAN-2016 06:04:13.
-- Publishing output


Post-processing of request 1482046 failed at 20-JAN-2016 06:33:49 with the error message:
ORA-04021: timeout occurred while waiting to lock object

CONC-POST-PROCESSING RESULTS
+---------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 20-JAN-2016 06:33:49


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

Solution

This error raise in "Create Accounting" log file Its  not a Error "ORA-04021: timeout occurred while waiting to lock object" its a temporary warning in the EBS R12 if any locking with tables or objects so this error is raise and prompt for wait or kill session and oracle internal process architect occur the Check Point for  Process Monitor "PMON Process" this is mandatory process in Oracle EBS R12  this Process clean all locking like row level locking, object locking etc. . . ..by default this process is run automatically