The Aging - 7 Buckets - By Account (ARXAGFW) Report Ends in Error - ORA-01555: Snapshot Too Old (Doc ID 1665484.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to run the Aging - 7 Buckets  - By Account (ARXAGFW) Report and receive the following error:

MSG-01001: after build_invoice_select
MSG-01001: end call build_invoice_select,common_query_inv=
ORA-01555: snapshot too old: rollback segment number 55 with name "_SYSSMU55_519596755$" too small
==> select rpad ( 'a' , 50 , '-' ) cust_name_inv , rpad ( 'a' , 30 , '-' ) cust_no_inv , rpad ( 'a' , 4000 , '-' ) sort_field1_inv , rpad ( 'a' , 4000 , '-' ) sort_field2_inv , 0 inv_tid_inv , 0 contact_site_id_inv , rpad ( 'a' , 60 , '-' ) cust_state_in
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: snapshot too old: rollback segment number 55 with name "_SYSSMU55_519596755$" too small
==> select rpad ( 'a' , 50 , '-' ) cust_name_inv , rpad ( 'a' , 30 , '-' ) cust_no_inv , rpad ( 'a' , 4000 , '-' ) sort_field1_inv , rpad ( 'a' , 4000 , '-' ) sort_field2_inv , 0 inv_tid_inv , 0 contact_site_id_inv , rpad ( 'a' , 60 , '-' ) cust_state_in

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms