Monday 13 November 2017

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

https://aporaclepayables.blogspot.com/2017/11/error-internal-error-has-occurred-in.html

Error

An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. 
ORA-01555: snapshot too old: rollback segment number 7 with name "$TEMPUNDOSEG" too 
small.
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 7 with name "$TE

For my Case

1: Data file 7 gb to 11gb Increased
alter tablespace APPS_UNDOTS1  add datafile '/data/CLIENT/PROD/apps_st/data/undo04.dbf' size 4096m

2: undo retention 900 sec to 1800 sec increased
alter system set undo retention = 1800 scope=both

No comments:

Post a Comment