My Oracle Support Banner

Orphan MTL_SALES_ORDERS / Order Type Mismatch Between MTL_SALES_ORDERS And OE_ORDER_HEADERS (Doc ID 1071818.1)

Last updated on SEPTEMBER 13, 2022

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 and later
Information in this document applies to any platform.

Symptoms

There is an Order Type Mismatch between MTL Sales Orders and OE Order Headers.

Steps
1. Navigate to Inventory > On Hand Availability > Reservations > Item Reservations
2. Query a problematic order.
3. See the Order Type: (order type A)
4. Query same order in OM responsibility and see Order Type (order type B)
Note: The order types do not match.

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
 Identify Script
References


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