Invalids When Applying Patch 4665900
(Doc ID 1287957.1)
Last updated on OCTOBER 30, 2024
Applies to:
Oracle Order Management - Version 11.5.10.2 and laterInformation in this document applies to any platform.
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.
Changes
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 |
Changes |
Cause |
Solution |
References |