My Oracle Support Banner

WSHPSGL / Pick Release Process Completes In Warning: No Sales Order Id Found in MTL_SALES_ORDERS (Datafix #23) (Doc ID 281836.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Inventory Management - Version 11.5.10.1 to 12.2.5 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Signature: INV_MSO_SALES_ORDER_MISSING
Datafix#23
create_mtl_sales_order.sql
ident_missing_mtl_sales_order.sql

Symptoms

The Pick Release Process (WSHPSGL) completes in Warning with the following error message.
The pick release does not succeed for the item.
The sales order is missing from the MTL_SALES_ORDERS table.

IDENTIFICATION SCRIPT

The following SQL could be used to help identify the issue on open sales orders with particular organization and item.

SELECT distinct a.order_number, a.header_id, a.order_type_id
FROM oe_order_headers_all a, oe_order_lines_all c
WHERE c.INVENTORY_ITEM_ID = NVL('&EnterItemID', c.INVENTORY_ITEM_ID)
AND c.SHIP_FROM_ORG_ID = NVL('&EnterOrgID', c.SHIP_FROM_ORG_ID)
AND a.header_id = c.header_id
and a.OPEN_FLAG = 'Y'
and NOT EXISTS
(SELECT 1
FROM mtl_sales_orders b
WHERE b.segment1 = to_char(a.order_number))

STEPS

This occurs for multiple orders and can be reproduced at will.

1. Create/book a sales order.
2. Navigate to Order Management > Shipping > Pick release
3. Run pick release.
4. The program (Pick Select List Generation) completes in warning.

ERROR

No Mtl_Sales_Order ID found for oe header

LOG SNIPPET

Here is a snippet from the log file:

WSHPSGL module: Pick Selection List Generation
Pick selection is completed with warning
...
Process_Line after fetch wdd
Process_Line after trans type
[20-MAR-13 13:54:02] Inv_Pick_Release_PVT.Process_Line: No Mtl_Sales_Order ID found for oe header
pick release No Mtl_Sales_Order ID found for oe header
No Mtl_Sales_Order ID found for oe header
[20-MAR-13 13:54:02] PICKREL: l_return_status from process_line is U

Changes

 

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!


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