My Oracle Support Banner

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

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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