Crediting and Rollup Error ORA-01555: snapshot too old: rollback segment number 87 with name "_SYSSMU87_3051497311$" too small
(Doc ID 2135774.1)
Last updated on MAY 22, 2023
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.19.04.0 and laterOracle Fusion Incentive Compensation - Version 11.13.18.10.0 and later
Information in this document applies to any platform.
Symptoms
When attempting to run Crediting and Rollup, the following error occurs.
ERROR
Unexpected exception in process_all_mode
SQLCODE : -1555
SQLERRM : ORA-01555: snapshot too old: rollback segment number 87 with name "_SYSSMU87_3051497311$" too small
CN_TP_DIRECT_CREDITS.generate_direct_credits.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
CN_TP_CREDIT_TXNS.generate_credits.g_exc_error
CN_TP_DIRECT_CREDITS.process_all_mode.others
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_credit_txns.generate_credits
STEPS
Navigator > Credits and Earnings > Run Crediting and Rollup (as a single job) ... or ... Run Crediting
Parameters : 1/1/15 - 12/31/15, TOTAL
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |