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)

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

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