R12: AP: When Account the Invoice, the Transfer Journal Entries to GL Does Not Process Available Events and Fails With “ORA-01555: snapshot too old: rollback segment number 39 with name "_SYSSMU39_253779068$" too small” in the Accounting Program Log (Doc ID 3040370.1)

Last updated on AUGUST 08, 2024

Applies to:

Symptoms

When attempting to account for the invoice, the Transfer Journal Entries to General ledger (GL) does not process available events and gives the following error in the Accounting Program log:

STEPS
-----------------------

The issue can be reproduced at will with the following steps:
1. Responsibility Payables Manager
2. Navigation: Menu > View > Requests > Submit a New Request... > Single Request
3. Select from List of Values (LOV) > Create Accounting program
4. Provide the End Date parameter > [B] Submit > Click on Output of Accounting Program
5. Notice the error
6. Restart the process and notice that some events had already process_status_code P.
7. Later, Run Transfer journal entries to GL and noticed that the remaining events are not processed
8. Looking into in xla_ae_headers noticed that gl_transfer_status_code = N & accounting_entry_status_code = F and the gl_sl_link_id can not be found in the gl_import_references_table

Cause

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