Refresh Paysheet or Payment Batch Process Error ORA-01555: snapshot too old: rollback segment number 16 with name "_SYSSMU16_3527275037$" too small

(Doc ID 2003018.1)

Last updated on SEPTEMBER 26, 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

Refresh Paysheet or Pay Payment Batch process (request ID 79398) ends up with error ORA-01555: snapshot too old: rollback segment number

 

Error might show:
ORA-01555: snapshot too old: rollback segment number 16 with name "_SYSSMU16_3527275037$" too small
OR
ORA-01555: snapshot too old: rollback segment number with name "" too small

 

Child request log ( 282077.log ) might shows:
Input Parameters Payrun_id = 300000003667726
Input Parameters Batch_id = 83048
Current time = 4 14-09-2017 14:42:02
Create worksheet for = 10103 salesrepID
*****Start creation of paysheet record for participant:10103
Entered the procedure cn_tp_paysheets_pvt.create_worksheet
The validations for creation of paysheet is successful for participant :10103
for the payrun :300000003667726
Calling cn_tp_participant_pay_pkg.insert_record
ORA-01555: snapshot too old: rollback segment number 102 with name
"_SYSSMU102_3629538120$" too small
Error when creating Worksheet for : 10103
+------------------------------+
Batch# 83048 : Creation of worksheets was not successful for some resources.
Count = 1
Finish time = 4 14-09-2017 15:40:20
Batch time = 58.29999999999999999999999999999999999998 minutes

 


STEPS:
Navigator > Payment > Processes > Pay Payment Batch
OR
Navigator > Payments > Create Payment Batches

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