My Oracle Support Banner

Error Code 17000, 1347 in C1-TXNIP Transaction Processing (Doc ID 2584335.1)

Last updated on OCTOBER 02, 2019

Applies to:

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

Symptoms

On RMB v2.4.0.1.0, Error occurring in Transaction processing in C1-TXNIP batch program.

While processing transaction, C1-TXNIP batch is giving following error. The actual error from logs is coming from package PKG_RMB_MULTI_PARM_PRICE_AGG line 160. In this package there is a logic to calculate the Aggregate parm group Id. But the function to calculate this id only expects 5 integer values from sequence CI_AGG_PARM_GRO_SEQ. But this sequence is returning integer values 6 digits. Most likely due to this transactions are erroring out in C1-TXNIP batch processing.

ERROR
-----------------------
17000, 1347 - Cannot derive product from rules engine

StdErr log shows:

ERROR (com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.ProductTouDerivationBatch) Exception while retrieving Product Code from Rule Engine
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.context.SessionExecutable.doInCurrentSession(SessionExecutable.java:174): Error retrieving Aggregation parameter details for :CM-HCC=MD~CM-SUBID=485A6nnnn~CMCVEDDT=2019-03-31~CMCVSTDT=2019-03-01~CMGLBU=G1700~CMGLCDHF=10~CMGLLOC=MBKY~CMGLMBU=NTKYCR~CMGLPROD=MPPPP~CMGLTHCF=10
com.splwg.ccb.domain.pricing.priceparm.AggregationParameterGroupCache$2.execute(AggregationParameterGroupCache.java:217): Caught exception from SessionExecutable.execute()

The root LoggedException was: Error in addAggregationParameterGroup during populating Cache for :CM-HCC=MD~CM-SUBID=485A69605~CMCVEDDT=2019-03-31~CMCVSTDT=2019-03-01~CMGLBU=G1700~CMGLCDHF=10~CMGLLOC=MBKY~CMGLMBU=NTKYCR~CMGLPROD=MPPPP~CMGLTHCF=10
at com.splwg.shared.common.LoggedException.wrap(LoggedException.java:199)
at com.splwg.shared.common.LoggedException.wrap(LoggedException.java:87)
at com.splwg.ccb.domain.pricing.priceparm.AggregationParameterGroupCache$2.execute(AggregationParameterGroupCache.java:240)
at com.splwg.ccb.domain.pricing.priceparm.AggregationParameterGroupCache$2.execute(AggregationParameterGroupCache.java:217)
at com.splwg.base.support.context.SessionExecutable.doInCurrentSession(SessionExecutable.java:174)
at com.splwg.ccb.domain.pricing.priceparm.AggregationParameterGroupCache.addAggregationParameterGroup(AggregationParameterGroupCache.java:272)
at com.splwg.ccb.domain.pricing.priceparm.AggregationParameterGroupCache.privateGetAggregationParameterGroup(AggregationParameterGroupCache.java:191)
at com.splwg.ccb.domain.pricing.priceparm.AggregationParameterGroupCache.getAggreationParameterGroupId(AggregationParameterGroupCache.java:178)
at com.splwg.cm.domain.banking.transactionFeed.transactionFeedAgg.algorithm.CmTransactionProductDerivationPostProcessingAlgComp_Impl.invoke(CmTransactionProductDerivationPostProcessingAlgComp_Impl.java:121)
at com.splwg.cm.domain.banking.transactionFeed.transactionFeedAgg.algorithm.CmTransactionProductDerivationPostProcessingAlgComp_Impl__.CGLIB$invoke$0()
at com.splwg.cm.domain.banking.transactionFeed.transactionFeedAgg.algorithm.CmTransactionProductDerivationPostProcessingAlgComp_Impl__$$FastClassByCGLIB$$1dbfa6a5.invoke()
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:215)
at com.splwg.base.support.interception.BusinessMethodInterceptor.intercept(BusinessMethodInterceptor.java:84)
at com.splwg.cm.domain.banking.transactionFeed.transactionFeedAgg.algorithm.CmTransactionProductDerivationPostProcessingAlgComp_Impl__.invoke()
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.ProductTouDerivationBatch$Worker.invokePostProcessingAlgorithm(ProductTouDerivationBatch.java:1487)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.ProductTouDerivationBatch$Worker.fetchTxnDetailsForRuleEngineInputParm(ProductTouDerivationBatch.java:1395)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.ProductTouDerivationBatch$Worker.processExecuteWorkUnitFlow(ProductTouDerivationBatch.java:1143)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.ProductTouDerivationBatch$Worker.processHighRangeDiffTrans(ProductTouDerivationBatch.java:1022)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.ProductTouDerivationBatch$Worker.executeWorkUnit(ProductTouDerivationBatch.java:902)
at com.splwg.base.api.batch.AbstractThreadWorker.executeWorkUnitDetailedResult(AbstractThreadWorker.java:193)
at com.splwg.base.api.batch.ThreadWorkUnitExecutable.executeAndAccumulateStats(ThreadWorkUnitExecutable.java:103)
at com.splwg.base.api.batch.ThreadWorkUnitExecutable.execute(ThreadWorkUnitExecutable.java:74)
at com.splwg.base.api.batch.AbstractCommitStrategy.executeWorkUntilCommitOrEnd(AbstractCommitStrategy.java:135)
at com.splwg.base.api.batch.AbstractCommitStrategy.concreteExecuteWork(AbstractCommitStrategy.java:74)
at com.splwg.base.api.batch.CommitEveryUnitStrategy.concreteExecuteWork(CommitEveryUnitStrategy.java:36)
at com.splwg.base.api.batch.AbstractExecutionStrategy.executeWork(AbstractExecutionStrategy.java:243)
at com.splwg.base.support.batch.JavaBatchWork.executeThreadWork(JavaBatchWork.java:109)
at com.splwg.base.support.batch.JavaBatchWork.access$300(JavaBatchWork.java:29)
at com.splwg.base.support.batch.JavaBatchWork$DoExecuteWorkInSession.doBatchWorkInSession(JavaBatchWork.java:92)
at com.splwg.base.support.batch.BatchWorkInSessionExecutable.run(BatchWorkInSessionExecutable.java:62)
at com.splwg.base.support.batch.JavaBatchWork.doExecuteWork(JavaBatchWork.java:51)
at com.splwg.base.support.grid.AbstractGridWork.executeWork(AbstractGridWork.java:72)
at com.splwg.base.support.cluster.ThreadWork.processBatchWork(ThreadWork.java:54)
at com.splwg.base.support.cluster.BatchWorkManager.processWork(BatchWorkManager.java:78)
at com.tangosol.coherence.commonj.WorkManager$ScheduleWork.run(WorkManager.java:2266)
at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.InvocationService.onInvocationRequest(InvocationService.CDB:12)
at com.tangosol.coherence.component.util.daemon.queueProcessor.service.grid.InvocationService$InvocationRequest.run(InvocationService.CDB:1)
at com.tangosol.coherence.component.util.DaemonPool$WrapperTask.run(DaemonPool.CDB:1)
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:798)
Caused by: org.hibernate.exception.SQLGrammarException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG", line 160
ORA-06512: at "CISADM.PKG_RMB_MULTI_PARM_PRICE_AGG", line 202

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run C1-TXNIP batch

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This error is going to affected Production as sequence values will soon reach 6 integer mark there.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.