R12:AP: When Run Create Accounting, Accounting Program Complete With Internal Error in the Log:” xla_ae_lines_pkg.AccountingReversal. ORA-01555: Snapshot Too Old: Rollback Segment Number XX With Name “_SYSSMU17_1286145785$” Too Small” (Doc ID 2982580.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Symptoms

Unable to account invoice either using the Payables Create Accounting program or attempting OnLine Accounting via the Invoice Workbench.

The Create accounting program log shows error "Internal Error", ORA-01555.  The OnLine Accounting attempt also raises "Internal Error".  See error detail below.

From the  application, the following  messages could be returned:

1. Using Create Accounting concurrent request.
   
   
   1. Log into Oracle Applications using a Payables responsibility.
   2. Open the Standard Request Submission (SRS) screen
      (N) Other > Request > Run
   3. Select/Run the Create Accounting Program
   4. Invoice does not get accounted.
      Concurrent request log file shows the following Error:
      
      XLAACCUP: Accounting Program failed with error:

      An internal error occurred. Please inform your system administrator or support representative that:

      "An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal.
      ORA-01555: snapshot too old: rollback segment number XX with name "_SYSSMUXX_XXX $" too small"

      
      
      
2. Attempting OnLine Accounting via the Invoice Workbench.
     
   
   1. Log into Oracle Applications using a Payables responsibility.
   2. Open the Invoice Workbench
      (N) Invoices > Entry > Invoice
   3. Query the Invoice to account
   4. Click on [Actions...1] button
   5. In the "Invoice Actions" popup window, select "Create Accounting" and click [OK]
   6. The following message pops up:
      
      Online Accounting could not be created for this transaction. Please inform your system administrator that the Create Account Program has encountered an internal error.
      
      AND/OR 
      Oracle forms locks up for a couple of hours and it is necessary to restart the program.
          

Cause

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