My Oracle Support Banner

C1-BLGEN Unique Constraint Error In ORMB 2.5.0.3 (Doc ID 2351756.1)

Last updated on JANUARY 25, 2018

Applies to:

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

Goal

On : ORMB 2.5.0.3.0 version, BI - Billing

C1-BLGEN Unique Constraint Error in ORMB 2.5.0.3

In client's project, it is required that they run multiple trial billings (4 to 5 times) during a one month bill cycle (i.e.: bill cycle schedule for January 2017 is open from 2017-01-01 up to 2017-01-31). Every week day, only TFM is executed to process billing events received for the day, then on the weekends, TFM and trial billing jobs are executed to generate trial bills for the given week. This weekly execution goes on until the end of the month, then at the very last day of the month, those trial bills are then converted to actual bills. For the first week of trial billing, C1-BLGEN runs smoothly in trial mode. But on the second week of trial billing, C1-BLGEN (trial mode) goes into "ORA-00001: unique constraint (CISADM.SYS_C0047646) violated" error.

ERROR
-----------------------
ERROR (com.splwg.base.support.sql.PreparedStatementImpl) Error executing update for rawSQL:
  INSERT INTO CI_TRL_BSEXT (BSEG_ID, CONSTRUCT_ID, PRIORITY_NUM, TEMPLATE_PURPOSE_FLG, VERSION_NUM, USAGE_ACCT_ID, PRICEITEM_CD, TOU_CD, PRICE_ASGN_ID, PRICEITEM_PARM_GRP_ID, VERSION, BSEG_TYPE_FLG ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) /* SQL for program 'com.splwg.base.program.sample.b.tbs.ProgramCIPBTBSA_Impl', SQL name 'I_BSEG_EXT' */
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.BSEG-ID' to : '811856409840' to indices: 1
with 'integer' parameter named 'I-BSEG-EXT-IN-DATA.PRIORITY-NUM' to : '0' to indices: 3
with 'integer' parameter named 'I-BSEG-EXT-IN-DATA.VERSION-NUM' to : '0' to indices: 5
with 'integer' parameter named 'I-BSEG-EXT-IN-DATA.PRICEITEM-PARM-GRP-ID' to : '170820703191950113' to indices: 10
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.TEMPLATE-PURPOSE-FLG' to : ' ' to indices: 4
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.TOU-CD' to : 'null' to indices: 8
with 'integer' parameter named 'I-BSEG-EXT-IN-DATA.VERSION' to : '1' to indices: 11
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.PRICEITEM-CD' to : '4P4506210 ' to indices: 7
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.PRICE-ASGN-ID' to : '7168129044' to indices: 9
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.BSEG-TYPE-FLG' to : 'RGLR' to indices: 12
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.CONSTRUCT-ID' to : ' ' to indices: 2
with 'FixedCHAR' parameter named 'I-BSEG-EXT-IN-DATA.USAGE-ACCT-ID' to : '8118530243' to indices: 6

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CISADM.SYS_C0047646) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
-
-
-
-
at com.tangosol.coherence.component.util.DaemonPool$WrapperTask.run(DaemonPool.CDB:32)
at com.tangosol.coherence.component.util.DaemonPool$Daemon.onNotify(DaemonPool.CDB:65)
at com.tangosol.coherence.component.util.Daemon.run(Daemon.CDB:51)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.splwg.base.support.program.NonZeroReturnCodeException(returnCd=2)
... 37 more

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run C1-BLGEN / Trail Billing
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.