Oracle RMB TFM (Transaction Feed Management) Is Throwing Error While Running The Batch C1-TXNIP (Doc ID 2115274.1)

Last updated on JUNE 16, 2017

Applies to:

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

Goal

Oracle RMB TFM (Transaction Feed Management) is throwing error while running the batch C1-TXNIP:

21:26:51,432 [PRD230Worker:3] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG" has been invalidated
ORA-04065: not executed, altered or dropped package body "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG"
ORA-06508: PL/SQL: could not find program unit being called: "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG"
ORA-06512: at line 1

21:26:51,435 [PRD230Worker:3] ERROR (com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.CreateProductParameterGroupBatch) HibernateException in executeWorkUnit() of CreateProductParameterGroupBatch :
org.hibernate.QueryTimeoutException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG" has been invalidated
ORA-04065: not executed, altered or dropped package body "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG"
ORA-06508: PL/SQL: could not find program unit being called: "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG"
ORA-06512: at line 1

  at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:156)
  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.CallableStatementProxyHandler.continueInvocation(CallableStatementProxyHandler.java:49)
  at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
  at com.sun.proxy.$Proxy11.execute(Unknown Source)
  at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.CreateProductParameterGroupBatch$Worker.executeWorkUnit(CreateProductParameterGroupBatch.java:382)
  at com.splwg.base.api.batch.AbstractThreadWorker.executeWorkUnitDetailedResult(AbstractThreadWorker.java:187)
  at com.splwg.base.api.batch.ThreadWorkUnitExecutable.executeAndAccumulateStats(ThreadWorkUnitExecutable.java:82)
  at com.splwg.base.api.batch.ThreadWorkUnitExecutable.execute(ThreadWorkUnitExecutable.java:53)

 Why is that?
 

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