Last updated on JULY 17, 2017
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:
wdd.source_line_number, wdd.organization_id, enforce_ship_set_and_smc
FROM wsh_delivery_details wdd,
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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms