GLSTPM Add/Delete Summary Accounts Fails with ORA-01555: Snapshot Too Old: Rollback Segment Number 4 (Doc ID 387776.1)

Last updated on NOVEMBER 25, 2016

Applies to:

Oracle General Ledger - Version 11.5 and later
Information in this document applies to any platform.
EXECUTABLE:GLSTPM - Add/Delete Summary Accounts

Symptoms

When run GLSTPM module: Add/Delete Summary Accounts it fails with the following error:

Error
-------
SHRD0043: ERROR: ORA-01555: snapshot too old: rollback segment number 4 with name "_SYS
<x glsiah() 14-AUG-2006 19:25:49
<x glscs2() 14-AUG-2006 19:25:49
<x gls_csa_rollup() 14-AUG-2006 19:25:49
SHRD0075: Error in gls_csa_rollup().
<x glsmah() 14-AUG-2006 19:25:49
SHRD0075: Error in glsmah().
<x glstadd() 14-AUG-2006 19:25:49
SHRD0075: Error in glstadd_addtmp().

Steps To Reproduce:
------------------------
1. In General Ledger, Setup/Accounts/Summary
2. Delete an existing summary account, then add it back.
3. When the form is closed, the concurrent process is run.

Changes

 

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