An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. ORA-01555: snaps
Since a recent database upgrade we receive the following error intermittently AR: Accounting Program (XLAACCUP) Ends With Error ORA-01555: snapshot too old: rollback segment number
We have changed the following:
Done that in PROD as below;
=====================
SQL> show parameter optimizer_adap
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean TRUE
SQL> show parameter undo_rete
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_retention integer 900
SQL> alter system set optimizer_adaptive_features=FALSE scope=both;
System altered.
SQL> alter system set undo_retention=0 scope=both;
System altered.
SQL> show parameter optimizer_adap
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean FALSE