My Oracle Support Banner

Claim Transactions Error Out With Revenue Class Code Is Missing Reason (Doc ID 2760624.1)

Last updated on MARCH 22, 2021

Applies to:

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

Symptoms

On : 2.7.0.1.0 version, BT - Batch

Claim transactions error out with Revenue class code is missing reason

C1-TXNEX is erroring out due to Revenue class code is missing reason.



ERROR
-----------------------


00:49:34,094 [TPWPRDWorker:0] INFO (com.splwg.base.support.sql.PreparedStatementImpl) Executing SQL: SELECT A.SEQUENCE_NBR , A.SQ_RULE_CD , B.SQ_RULE_FLG , B.UOM_CD , B.TOU_CD , B.SQI_CD , B.SQ_QTY_FLG , B.CRT_ERR_SW , B.SQ_PARAM_01 , B.SQ_PARAM_02 , B.SQ_PARAM_03 , B.SQ_PARAM_04 , B.SQ_PARAM_05 , B.SQ_PARAM_06 , B.SQ_PARAM_07 , B.SQ_PARAM_08 , B.SQ_PARAM_09 , B.SQ_PARAM_10 , C.DESCR FROM CI_RS_SQ_RULE A, CI_SQ_RULE B, CI_SQ_RULE_L C WHERE A.RS_CD=:S-SQRULE-IN-DATA.RS-CD AND A.SQ_RULE_CD=B.SQ_RULE_CD AND ((B.SQ_RULE_PROC_FLG = :S-SQRULE-IN-DATA.SQ-RULE-PROC-FLG AND 'Y' = :S-SQRULE-IN-DATA.RETAIN-SQ-SW) OR 'N' = :S-SQRULE-IN-DATA.RETAIN-SQ-SW) AND C.SQ_RULE_CD=A.SQ_RULE_CD AND C.LANGUAGE_CD=:S-SQRULE-IN-DATA.LANGUAGE-CD ORDER BY A.SEQUENCE_NBR /* SQL for program 'com.splwg.ccb.domain.rate.common.ProgramCIPRBSQN_Impl', SQL name 'S_SQRULE' */
00:49:34,094 [TPWPRDWorker:0] INFO (com.splwg.base.domain.AppLog) Binding FixedCHAR S-SQRULE-IN-DATA.LANGUAGE-CD to: 'ENG'
00:49:34,094 [TPWPRDWorker:0] INFO (com.splwg.base.domain.AppLog) Binding FixedCHAR S-SQRULE-IN-DATA.RS-CD to: 'HCASL '
00:49

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.