Invalid Objects INVPWSHB.PLS(INV_SHIPPING_TRANSACTION_PUB), INVTXGGB.PLS(INV_TXN_MANAGER_GRP), WMSLOADB.pls (WMS_TASK_LOAD), OEXUREQB.pls (OE_DELAYED_REQUESTS_UTIL) Are Invalid After 12.1.3 RPC4(21236633:12.1.0) on 10.2.0.4 Database (Doc ID 2138251.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version with 10.2.0.4 Database Version,

After application of 12.1.3 RPC4 patch (21236633:12.1.0) following objects are invalid

1) WMS_TASK_LOAD

ERROR during compilation
----------------------------
Errors for PACKAGE BODY WMS_TASK_LOAD

PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
PLS-00382: expression is of wrong type

2) INV_SHIPPING_TRANSACTION_PUB 

ERROR during compilation
------------------------------

Errors for PACKAGE BODY INV_SHIPPING_TRANSACTION_PUB

PL/SQL: ORA-00907: missing right parenthesis
PL/SQL: SQL Statement ignored

3) INV_TXN_MANAGER_GRP

ERROR during compilation
------------------------------

Errors for PACKAGE BODY INV_TXN_MANAGER_GRP

PL/SQL: ORA-00907: missing right parenthesis
PL/SQL: SQL Statement ignored

4) OE_DELAYED_REQUESTS_UTIL

ERROR during compilation
------------------------------

PL/SQL: ORA-00907: missing right parenthesis
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00907: missing right parenthesis
PL/SQL: SQL Statement ignored

Changes

 Applied 12.1.3 RPC4 patch (21236633:12.1.0) on Ebiz instance with 10.2.0.4 Database Version

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