Orphan Data in MTL_SUPPLY Table (Doc ID 2287578.1)

Last updated on JULY 24, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Supply Demand

ACTUAL BEHAVIOR
---------------
MTL_SUPPLY table has rows referencing


EXPECTED BEHAVIOR
-----------------------
MTL_SUPPLY table should not have data referencing non-existent POs and Requisitions and Shipments .

BUSINESS IMPACT
-----------------------
Due to this issue, users see incorrect supply in View Supply/Demand form. Inventory Planning method does not work for the affected items.

Changes

 

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