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

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

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

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