Mass Additions Posting Report (FAS824) Running For Long Time and Errors With ORA-01555 and REP-300 (Doc ID 1604150.1)

Last updated on APRIL 03, 2025

Applies to:

Symptoms

FAS824 module: Mass Additions Posting Report has poor performance and errors with:

ORA-01555: snapshot too old: rollback segment number 18 with name "_SYSSMU18_1232623801$" too small
SELECT ma . asset_number ASSET_NUMBER , MA . DESCRIPTION DESCRIPTION , 'Additions' TRANS_TYPE , glcc.SEGMENT1 COMPANY , glcc.SEGMENT3 COST_CTR , decode ( MA . ASSET_TYPE , 'CIP' , CB . CIP_COST_ACCT , CB . ASSET_COST_ACCT ) ACCOUNT , ma . mass_addi
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: snapshot too old: rollback segment number 18 with name "_SYSSMU18_1232623801$" too small
SELECT ma . asset_number ASSET_NUMBER , MA . DESCRIPTION DESCRIPTION , 'Additions' TRANS_TYPE , glcc.SEGMENT1 COMPANY , glcc.SEGMENT3 COST_CTR , decode ( MA . ASSET_TYPE , 'CIP' , CB . CIP_COST_ACCT , CB . ASSET_COST_ACCT ) ACCOUNT , ma . mass_addi

Changes

Cause

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