Duplicate Transactions From Inventory to PA_TRANSACTION_INTERFACE_ALL
(Doc ID 2784711.1)
Last updated on AUGUST 31, 2021
Applies to:Oracle Cost Management - Version 12.2.4 and later
Information in this document applies to any platform.
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
duplicates in MTA.
select * from mtl_transaction_accounts
where rowid in (
from mtl_transaction_accounts mta
WHERE mta.organization_id = &org_id
having count(1) > 1);
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