My Oracle Support Banner

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 APRIL 29, 2018

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information 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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.