During 12.2.10 Upgrade The Following Package WMS_RULE_PVT Is In INVALID State with Error 'WMS_RULE_YR_PKG1.EXECUTE_YARD_ROUTING_RULE must be declared'
(Doc ID 2897039.1)
Last updated on FEBRUARY 12, 2024
Applies to:
Oracle Warehouse Management - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
ERROR
-----------------------
Errors for PACKAGE BODY WMS_RULE_PVT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4365/7 PL/SQL: Statement ignored
4365/7 PLS-00201: identifier 'WMS_RULE_YR_PKG1.EXECUTE_YARD_ROUTING_RULE' must be declared
4367/7 PL/SQL: Statement ignored
4367/7 PLS-00201: identifier 'WMS_RULE_YR_PKG2.EXECUTE_YARD_ROUTING_RULE' must be declared
4369/7 PL/SQL: Statement ignored
4369/7 PLS-00201: identifier 'WMS_RULE_YR_PKG3.EXECUTE_YARD_ROUTING_RULE' must be declared
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply 12.2.10 upgrade patches and find that the package WMS_RULE_PVT is invalid
2. Manaullly recompile the package WMS_RULE_PVT and find errors
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use WMS functionality
Changes
During oracle Application to 12.2.10 upgrade the below package is in 'WMS_RULE_PVT' INVALID state.
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 |