FAILED: File PO_ENTITY_LOCK_TYPES.sql On Worker 1. po_entity_lock_comp_type (Doc ID 2001931.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.4 and later
Oracle Purchasing - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

The following adop merge attempt was being done - when it failed with an error.

Error:

CREATE OR REPLACE TYPE po_entity_lock_comp_type AS OBJECT
*
ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents

 

 

_______________________________________________________________________


[oracle@irv-vision-r12 admin]$ adop phase=apply merge=yes patches=17171237,17410012,17765665,17862337,17889190,17904883,17911421,18242621,18273484,18315774,18454567,18481499,18617687,18620668,18648529,18655199,18660646,18673437,18725975,18726186,18805180,18813289,18861119 restart=yes abandon=no flags=autoskip

Workers 1 and 2 failed with the following error:

-- Log File --
Start time for file is: Sat Mar 28 2015 07:04:37

sqlplus -s APPS/***** @/u01/oracle/VIS/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/VIS/fs2/EBSapps/appl/po/12.0.0/patch/115/sql/PO_ENTITY_LOCK_TYPES.sql '
Connected.

PL/SQL procedure successfully completed.

DROP TYPE po_entity_lock_comp_tbl_type FORCE
*
ERROR at line 1: ORA-04043: object PO_ENTITY_LOCK_COMP_TBL_TYPE does not exist

CREATE OR REPLACE TYPE po_entity_lock_comp_type AS OBJECT
*
ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents

Time when worker failed: Sat Mar 28 2015 07:04:37
Time when worker started job: Sat Mar 28 2015 07:04:37
Start time for file is: Sat Mar 28 2015 07:04:37

sqlplus -s APPS/***** @/u01/oracle/VIS/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/VIS/fs2/EBSapps/appl/po/12.0.0/patch/115/sql/PO_ENTITY_LOCK_TYPES.sql '
Connected.

PL/SQL procedure successfully completed.
_______________________________________________________________________

The issue appears to be specific to 11.2.0.3.

Cause

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 hundreds of Community platforms