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

Last updated on FEBRUARY 23, 2023

Applies to:

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

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