Unique Constraint Error on Table CI_B_LN_CHAR when Running C1-TXNSQ Batch

(Doc ID 2321343.1)

Last updated on OCTOBER 31, 2017

Applies to:

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

Symptoms

On ORMB v 2.6.0.0 against FW v4.3.0.4, BT - Batch:
Unique constraint error on table CI_B_LN_CHAR when running C1-TXNSQ batch.

Actual Results
------------------
When running C1-TXNSQ batch, unique constraint is encountered on table CI_B_LN_CHAR.

Expected Results
---------------------
Billable charges should get created successfully without throwing any exception in C1-TXNSQ batch.

Steps
-------------
The issue can be reproduced at will with the following steps:
1) Execute TFM aggregation Flow.

Business Impact
---------------------
This is affecting a successful C1-TXNSQ batch run.

Changes

 

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