Invalids When Applying Patch 4665900 (Doc ID 1287957.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 16-JUL-2013***

Symptoms

On : 11.5.10.2 version, Install / Upgrade

When attempting to apply Patch 4665900 ( prereq to OM patch 8406953 ) , the following errors occur:

ERROR
-----------------------
OE_ADV_ITEM_SEARCH_PVT OEXVAISB.pls 115.0 BODY INVALID
Errors for PACKAGE BODY OE_ADV_ITEM_SEARCH_PVT PLS-00907: cannot load library unit APPS.OE_GLOBALS (referenced by APPS.OE_ORDER_PVT) PL/SQL: Statement ignored

OE_CREDIT_CARD_MIGRATE_UTIL OEXECCNB.pls 115.0.11510.6 BODY INVALID
Errors for PACKAGE BODY OE_CREDIT_CARD_MIGRATE_UTIL PLS-00201: identifier 'IBY_SYS_SECURITY_SUBKEYS.SUBKEY_CIPHER_TEXT' must be declared PL/SQL: Item ignored

OE_DEFAULT_LINE_PATTR OEXDLPAB.pls 115.13 BODY INVALID
Errors for PACKAGE BODY OE_DEFAULT_LINE_PATTR PLS-00801: internal error [1401] PL/SQL: Statement ignored

OE_DEFAULT_LOT_SERIAL OEXDSRLB.pls 115.14 BODY INVALID
Errors for PACKAGE BODY OE_DEFAULT_LOT_SERIAL PLS-00801: internal error [1401] PL/SQL: Statement ignored

OE_FREIGHT_CHOICES_PVT OEXVFCHB.pls 115.7 BODY INVALID
Errors for PACKAGE BODY OE_FREIGHT_CHOICES_PVT PLS-00907: cannot load library unit APPS.OE_GLOBALS (referenced by APPS.OE_ORDER_PVT) PL/SQL: Statement ignored

OE_HEADER_ADJ_UTIL OEXUHADB.pls 115.68.11510.2 BODY INVALID
Errors for PACKAGE BODY OE_HEADER_ADJ_UTIL PLS-00907: cannot load library unit APPS.OE_GLOBALS (referenced by APPS.OE_DEPENDENCIES) PL/SQL: Statement ignored

OE_HEADER_PAYMENT_UTIL OEXUHPMB.pls 115.18.11510.3 BODY INVALID
Errors for PACKAGE BODY OE_HEADER_PAYMENT_UTIL PLS-00907: cannot load library unit APPS.OE_GLOBALS (referenced by APPS.OE_DEPENDENCIES) PL/SQL: Statement ignored

OE_HEADER_SCREDIT_UTIL OEXUHSCB.pls 115.35.11510.2 BODY INVALID
Errors for PACKAGE BODY OE_HEADER_SCREDIT_UTIL PLS-00907: cannot load library unit APPS.OE_GLOBALS (referenced by APPS.OE_DEPENDENCIES)
PL/SQL: Statement ignored

And many more...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to apply Patch 4665900.

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