Last updated on DECEMBER 10, 2010
Applies to:Oracle Utilities Customer Care and Billing - Version: 2.1.0
Information in this document applies to any platform.
Batch Job AR-PRFK for Bills (CI_ARCBI) is ending in error; 3 out of 8 threads completed normally.
The 5 threads ended in following error:
SQL Error encountered sqlCode=1555, sqlState=72000 (ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small ) with SQL:
'SELECT RI.ARC_ROOT_OBJ_ID, RI.ARC_ROOT_INST_ID FROM CI_ARC_ROOT_INST RI, CI_ARC_ROOT_OBJ RO WHERE RI.DB_PROC_CD = ? AND RI.ARC_ROOT_INST_ID BETWEEN ? AND ? AND RI.ARC_ROOT_OBJ_ID = RO.ARC_ROOT_OBJ_ID AND RO.MAINT_OBJ_CD = ? AND RO.ENV_REF_CD = ? AND RO.ARC_ROOT_STAT_FLG = ?'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms