Inventory Standard Datafix Instruction #21: Sales Order Issue Transaction Missing In MTI And MMT For A Drop Ship PO Receipt And Sales Order Line Shipped Qty Not Updated (Doc ID 1672571.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Identify: identify_missing_dropship_issue.sql
Datafix: missing_dropship_issue.sql

Goal

This document provides the detailed instructions for fixing Negative TRANSACTION_SOURCE_ID in the Inventory Transactions Table (MTL_MATERIAL_TRANSACTIONS). Also this document will show all the available information regarding the Root Cause of this data corruption.

Please follow up this document in the following order:
A. Identification Scripts: This will confirm if you are having this data corrution.
B. Verifying your file versions: This will allow you and support to confirm if you are already in a known fixed version.
C. Root Cause Analysis. It shows all the relevant information about this issue Root Cause.
D. Datafix Intructions. It will provide steps for fixing the data corruption.