C1-TXNSQ ORA-02291 Integrity Constraint Error

(Doc ID 2351774.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, BT - Batch

C1-TXNSQ ORA-02291 integrity constraint error

After applying partitioning on billable charge tables, C1-TXNSQ has encountered the following error.
Please review the attached partitioning script and please suggest recommendations and corrections.


ERROR
-----------------------
18:17:41,065 [RPAG1EPWorker:3] ERROR (com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionAggregationSQCalcBatch) HibernateException in executeWorkUnit :
org.hibernate.exception.ConstraintViolationException: ORA-02291: integrity constraint (CISADM.CI_BCHG_SQ_FK) violated - parent key not found

  at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128)
  at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
  at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
  at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
  at com.sun.proxy.$Proxy6.executeBatch(Unknown Source)
  at com.splwg.ccb.domain.util.LoggablePreparedStatement.executeBatch(LoggablePreparedStatement.java:231)
  at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TFMCommonService.insertBillableChargeSQ(TFMCommonService.java:1704)
  at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionAggregationSQCalcBatch$Worker.insertBillableCharge(TransactionAggregationSQCalcBatch.java:4473)
 

Solution

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