Pick Release Failing in All Warehouses After Deleting a WMS Pick Rule (Doc ID 1630491.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
Concurrent: WSHPSGL - Pick Selection List Generation

Symptoms

After a user deleted a WMS Pick rule (whatever it is), the pick release does not work any more.
The Pick Selection List Generation concurrent program (WSHPSGL) completes with Warning and the lines are getting backordered in all warehouses.

-- Steps
The issue can be replicated at will per the below steps:
1. Create a new WMS Pick rule by copying an existing rule
Enable the rule and save
2. Create and enable and save a new strategy with the above rule assigned
3. Create a strategy assignment in the Rules Workbench and enable and save it
4. Launch the Pick release. It completes Normal
5. Disable the strategy assignment in the Rules Workbench
6. Disable and delete the strategy
7. Disable and delete rule and save
8. Backorder the line
9. Re-launch the Pick release for the same. It completes with Warning
10. Query the invalid database objects. See WMS_RULE_PICK_PKG1 package body is invalid.

Changes

The problem would surface after applying Logistics RUP5 rollup patch or higher. Refer to <Document:726226.1>

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