Calculation Error On Eligibility Job. Unexpected Error : ORA-01555: snapshot too old: rollback segment number 39 with name "_SYSSMU39_868843588$" too small (Doc ID 1990950.1)

Last updated on MARCH 18, 2015

Applies to:

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

Symptoms

Calculation process completed with error.  The child Eligibility job shows ORA-01555 snapshot too old : rollback segment error

ERROR
CN_TP_TXNS_UTIL.revert_measures.others
SQLCODE : -1555
SQLERRM : ORA-01555: snapshot too old: rollback segment number 14 with name "_SYSSMU14_3143241412$" too small
cn_tp_eligibility_pvt.revert_total_mode.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_eligibility_pvt.revert_total_mode
cn_tp_eligibility_pvt.eligibility.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
End of eligibility phase for logical batch id 83001 and physical batch id : 38


STEPS
Navigator > Credits and Earnings > Manage Calculation Processes
Run calculation for all participants for JAN-2015 period.


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