Transaction Number Present In XLA Transaction Tables But Not In SLA (Doc ID 2601142.1)

Last updated on NOVEMBER 01, 2024

Applies to:

Goal

On : 11.12.1.0.0 version, Create Accounting Program

Transaction Number present in XLA Transaction tables but not in SLA

Unable to find a transaction number in SLA that was uploaded successfully via the "Import Accounting Transactions" scheduled process. However when query the database from OTBI found the transaction :
select * from XLA_TRANSACTION_HEADERS where TRANSACTION_NUMBER in ('123456')

select * from XLA_TRANSACTION_LINES where event_id='498124'

Unable to upload the same transaction since the process ends up with an error "Duplicate transactions found".

 

Solution

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