Transaction Reprocess Batch (C1-FREQP) Fails with ORA-00001 Error

(Doc ID 2411419.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v2.6.0.1.0 against FW v4.3.0.4, C1-FREQP Batch in Error and not processing Retry Records.

ERROR
-----------------------
ERROR (com.splwg.ccb.domain.dataManagement.fileRequest.batch.FileRequestProcessBusinessComponent_Impl) org.hibernate.exception.ConstraintViolationException: ORA-00001: unique constraint (CISADM.SYS_C0025617) violated

14:39:48,975 [DEFAULTWorker:0] ERROR (com.splwg.base.api.batch.AbstractExecutionStrategy) Thread execution aborted: BatchThreadInstance_Id(batchThreadId: [batchRunId: [batchControlId: [C1-FREQP], batchNumber: 1, batchRerunNumber: 0], batchThreadNumber: 1], batchInstance: 75623)
com.splwg.base.support.grid.GridWorkAbortedException: com.splwg.shared.common.ApplicationError: (Server Message)
Category: 90003
Number: 7

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Records in Retry status and configured to run Transaction Reprocess batch (C1-FREQP)
2) Batch goes in Error
3) Batch Run Tree shows error details

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process records in 'Retry' status.

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