Collection Unexpected Error : ORA-01555: Snapshot Too Old: Rollback Segment Number 19 With Name "_SY (Doc ID 2286238.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms


Collect Transactions process error. There are only a few transactions to be collected.

ERROR
Unexpected Error : ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19_655005671$" too small


STEPS
1. Import Transactions using File IMport or WebService
2. Confirm there are only a few transactions in CN_TP_TRANSACTIONS_STAGING_T table.
3. Run Collection via Navigator > Credits and Earnings > Collect Transactions

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