SQL Error Code 999999994 Occurs In Module CIPBDCPN During Batch Billing (Doc ID 1081042.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 1.5.20 to 2.2.0 - Release: 1.5 to 2.2
Information in this document applies to any platform.

Symptoms

When attempting to run Batch Billing, SQL error code 999999994 occurs in module CIPBDCPN.

The full error is similar to the following:

14:01:05,125 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) 2010-01-08-14.01.06 User: CCBBATCH 14:01:05.12 SQL S: S_STRTBS -> S
14:01:05,125 [CobolThread 1] INFO (com.splwg.base.support.cobol.host.NewCobolSQLHelper:101) SQL execution 'select single row' request for cobol program 'CIPBDCPN' SQL name 'S-STRTBS'
SQL from cobol: SELECT 'X' FROM CI_BSEG BS WHERE BS.SA_ID = :SA-ID AND BS.BSEG_STAT_FLG IN ('30' ,'50') AND BS.END_DT <= :START-DT
Indexed SQL from metadata: SELECT 'X' FROM CI_BSEG BS WHERE BS.SA_ID = ? AND BS.BSEG_STAT_FLG IN ('30' ,'50') AND BS.END_DT <= ?
Inputs:
START-DT : '2009-10-13' [ParamMetaData {name='START-DT', type='D', size=10, scale=0, column=-1, nullIndicatorIndex=-1, offset = 10}]
SA-ID : '0799210005' [ParamMetaData {name='SA-ID', type='C', size=10, scale=0, column=-1, nullIndicatorIndex=-1, offset = 0}]
14:01:05,126 [CobolThread 1] INFO (com.splwg.base.support.cobol.host.NewCobolSQLHelper:101) Single row select results for CIPBDCPN SQL S-STRTBS (non-unique selected result- more rows exist)
X : 'X' (Char) [ParamMetaData {name='X', type='C', size=1, scale=0, column=1, nullIndicatorIndex=-1, offset = 0}]
14:01:05,127 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) 2010-01-08-14.01.06 User: CCBBATCH 14:01:05.12 SQL E: S_STRTBS -> S
14:01:05,127 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) ====================================
14:01:05,127 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQL error in CIPBDCPN
14:01:05,128 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) 2010-01-08-14.01.06 User : CCBBATCH
14:01:05,128 [CobolThread 1] INFO (COBOL.CIPBDCPN:101)
14:01:05,128 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) Error: S_STRTBS
14:01:05,129 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) 999999994 ->
14:01:05,129 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLCAID =>
14:01:05,130 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLCABC =>
14:01:05,130 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLCODE => 14:01:05,130 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRML =>
14:01:05,131 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRMC =>
14:01:05,131 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRP =>
14:01:05,131 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRD(1) =>
14:01:05,132 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRD(2) =>
14:01:05,132 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRD(3) =>
14:01:05,132 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRD(4) =>
14:01:05,133 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRD(5) =>
14:01:05,133 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLERRD(6) =>
14:01:05,133 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN0 =>
14:01:05,134 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN1 =>
14:01:05,134 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN2 =>
14:01:05,134 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN3 =>
14:01:05,135 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN4 =>
14:01:05,135 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN5 =>
14:01:05,135 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN6 =>
14:01:05,136 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) SQLWARN7 =>
14:01:05,136 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) ====================================
14:01:05,136 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) Message data - Program name : CIPBDCPN
14:01:05,137 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) - Scheduler id : 0000003205
14:01:05,137 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) - Message cat : 00006
14:01:05,137 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) - Message nbr : 00003
14:01:05,138 [CobolThread 1] INFO (COBOL.CIPBDCPN:101) 2010-01-08-14.01.06 User: CCBBATCH 14:01:05.13 End : CIPBDCPN
14:01:05,138 [CobolThread 1] INFO (COBOL.CIPBBLSG:101) 2010-01-08-14.01.06 User: CCBBATCH 14:01:05.13 End : CIPBBLSG
14:01:05,139 [CobolThread 1] INFO (COBOL.CIPBBSGG:101) 2010-01-08-14.01.06 User: CCBBATCH 14:01:05.13 End : CIPBBSGG
14:01:05,139 [CobolThread 1] INFO (COBOL.CIPBBILG:101) 2010-01-08-14.01.06 User: CCBBATCH 14:01:05.13 End : CIPBBILG
14:01:05,139 [CobolThread 1] INFO (COBOL.CIPBBILB:101) 0799210000 - error
14:01:05,140 [CobolThread 1] INFO (COBOL.CIPBBILB:101) * * * ROLLBACK ! ! ! * * *




Cause

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