Unexpected Error in BWC with Patch 25322478:R12.PO.D Error ORA-04021: timeout occurred while waiting to lock object
(Doc ID 2392605.1)
Last updated on MARCH 02, 2023
Applies to:
Oracle Purchasing - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.4 version, Purchase Order
When attempting to add FREIGHT PO line in BWC,
the following error occurs.
ERROR
-----------------------
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 - Receive an unexpected error when trying to add a cold start line to an existing purchase order. This has only occurred after sending a purchase order to a supplier and they advise that need to add freight to the order. When adding a freight line when click save on the line we receive the error.
If use PO Summary form to add the freight line no error.
This is reproducable in R12 Train.
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.
2 - Then follow apply patch 25322478:R12.PO.D to upgrade file version to PO_PDOI_HEADER_PROCESS_PVT.plb 120.34.12020000.15
3 - However after patch applied, system shows error below in patch log.
**** Reseting package states in the current session ****
Statement executed.
Set the Module name & Client id successfully for file 'POXDAULB.pls'
package /ehvefms/fs1/EBSapps/appl/po/12.0.0/patch/115/sql/POXDAULB.pls
Done deactivating PL/SQL compilation.
AD Worker error:
ORA-04021: timeout occurred while waiting to lock object
Failed to execute statement. Statement is
CREATE OR REPLACE PACKAGE BODY PO_DOCUMENT_ACTION_UTIL AS
-- $Header: ...
AD Worker error:
ORA-04021: timeout occurred while waiting to lock object
Done resetting PL/SQL compilation.
Unable to process file in PACKAGE mode.
Not converting file for Invoker's Rights because it appears to
be a package body creation script (based on the filename).
File is: /ehvefms/fs1/EBSapps/appl/po/12.0.0/patch/115/sql/POXDAULB.pls
sqlplus -s APPS/***** @/ehvefms/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/ehvefms/fs1/EBSapps/appl/po/12.0.0/patch/115/sql/POXDAULB.pls '
Connected.
PL/SQL procedure successfully completed.
CREATE OR REPLACE PACKAGE BODY PO_DOCUMENT_ACTION_UTIL AS
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
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 |