GLAMAS: Run MassAllocations Has Completed With Error ORA-01555: snapshot too old: rollback segment number 11 with name "_SY (Doc ID 2987712.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Symptoms

Run Mass Allocations program has completed with following error:

GLAMAS: Run MassAllocations
+---------------------------------------------------------------------------+

<x glaima()
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01555: snapshot too old: rollback segment number 11 with name "_SY
sqlerrp: sqlerrd: 0 0 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************

The issue can be reproduced at will with the following steps:
1. Go to General ledger responsibility
2. Run the Mass Allocation
Reports : Run

Cause

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