WSHPSGL - Pick Release Completes But No Move Order Created (Line Exists But No Header)
(Doc ID 1165324.1)
Last updated on APRIL 19, 2024
Applies to:
Oracle Shipping Execution - Version 12.0.6 and laterOracle Inventory Management - Version 12.0.4 and later
Information in this document applies to any platform.
Executable:WSHPSGL - Pick Selection List Generation
Executable:WSHPSRS - Pick Selection List Generation - SRS
Symptoms
Find move order lines that cannot transact.
Cannot query the move order lines.
Steps
1. Pick release
2. Inventory > move orders > transact move orders
3. Query move order
4. Nothing comes up.
5. Query table -- see table with data in move order line, but not move order header.
Example SQL Query
Example query that can identify the issue - The SQL looks for move orders with move order lines but no headers. The released status is used in the query from WSH_DELIVERY_DETAILS looking for S / Released to Warehouse. The Released to Warehouse status means that the pick release was run to create the move order but the move order was not yet transacted:
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 |
| Cause |
| Solution |
| A. Datafix |
| B. Avoiding the Issue |
| References |