Pick Release Fails Due To Invalid Rule Packages Following Upgrade

(Doc ID 761810.1)

Last updated on JULY 04, 2017

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)


After upgrading from 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::

On line: 66
PLS-00382: expression is of wrong type

Error generated by Pick Release log:



Upgraded from to 12.0.6


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