Duplicate Transactions From Inventory to PA_TRANSACTION_INTERFACE_ALL (Doc ID 2784711.1)

Last updated on AUGUST 31, 2021

Applies to:

Symptoms

There are 6 transactions which are duplicated due to organization used to populate the transaction.

duplicate records in the table PA_TRANSACTION_INTERFACE_ALL

select * from pa_transaction_interface_all where
orig_transaction_reference in(txn1,txn1,etc....)

duplicates in MTA.

select * from mtl_transaction_accounts
where rowid in (
select min(rowid)
from mtl_transaction_accounts mta
WHERE  mta.organization_id = &org_id
group by
(transaction_ID,reference_account,accounting_line_type,primary_quantity,organi
zation_id,inventory_item_id)
having count(1) > 1);

Changes

Cause

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