Datafix To Delete Orphan mtl_transaction_lots_interface And mtl_serial_numbers_interface Records (Doc ID 1358150.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Inventory Management - Version 11.5.1 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
tables:
mtl_serial_numbers_interface
mtl_transaction_lots_interface


Symptoms

Orphan records exist in the following tables:
mtl_transaction_lots_interface
mtl_serial_numbers_interface

To identify occurrences:

SELECT * from mtl_transaction_lots_interface mtli
WHERE mtli.product_code = 'RCV'
and mtli.product_transaction_id is not null
and not exists (select '1' from rcv_transactions_interface rti
where rti.interface_transaction_id = mtli.product_transaction_id);


SELECT * from mtl_serial_numbers_interface msni
WHERE msni.product_code = 'RCV'
and msni.product_transaction_id is not null
and not exists (select '1' from rcv_transactions_interface rti
where rti.interface_transaction_id = msni.product_transaction_id);





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