My Oracle Support Banner

Pick Release Fails Due To Invalid Rule Packages Following Upgrade (Doc ID 761810.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Warehouse Management - Version 12.0.0 and later
Oracle Inventory Management - Version 12.0.0 and later
Oracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Solution applies to later versions of R12 as well, such as R12 Inv B (R12.1.3) and C (R12.2)

Symptoms

After upgrading from 11.5.10.2 to 12.0.6 and the latest critical updates, Pick release fails due to invalid WMS_RULE packages.

The Errors generated by the invalid rule are as follows::

PACKAGE BODY APPS.WMS_RULE_2
On line: 66
PLS-00382: expression is of wrong type

Error generated by Pick Release log:

 

Changes

Upgraded from 11.5.10.2 to 12.0.6

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.