R12.2 Apps DBA. Powered by Blogger.

Cannot Complete Batch - Unexpected User-Defined Exception Occured

, , , No comments :
A trace showed the error:
"ORA-00054: resource busy and acquire with NOWAIT specified"
indicating a locking issue of the tables
Related to the Bug 13505146 - CANNOT COMPLETE A BATCH DUE TO LOCKING ISSUE
Solution:
The lock must be removed.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.

Subscribe to: Post Comments ( Atom )