My Oracle Support Banner

WSHPSGL - Pick Release Completes But No Move Order Created (Line Exists But No Header) (Doc ID 1165324.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Shipping Execution - Version 12.0.6 and later
Oracle 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


Find move order lines that cannot transact.
Cannot query the move order lines.

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:

SELECT mtrl.header_id, wdd.delivery_detail_id, wdd.source_header_id, wdd.source_line_id,
wdd.source_line_number, wdd.organization_id, enforce_ship_set_and_smc
FROM wsh_delivery_details wdd,
wsh_shipping_parameters wsp,
mtl_txn_request_lines mtrl
WHERE line_id = move_order_line_id
AND source_code = 'OE'
AND wdd.move_order_line_id IS NOT NULL
AND wsp.organization_id = wdd.organization_id
AND released_status = 'S'
AND NOT EXISTS ( SELECT 'x' FROM mtl_txn_request_headers mtrh
WHERE mtrh.header_id = mtrl.header_id )
order by 2, 1, 3;


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
 A. Datafix
 B. Avoiding the Issue

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