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 MAY 26, 2017

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.

Cause

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 hundreds of Community platforms