Encountered System Error While Creating The Bill Segments

(Doc ID 2358735.1)

Last updated on FEBRUARY 16, 2018

Applies to:

Oracle Utilities Customer Care and Billing - Version to [Release 2.6]
Information in this document applies to any platform.


On :CCB version, IP - Installation Upgrade Proc

Encountered System error while creating the bill segments

We are upgrading from CC&B 2.3.1 to CC&B 2.6. While testing Generate Bill functionality, system error is encountered when creating bill segments. When billing a Service Agreement that uses a Rate Schedule with a Rate Component Calculation Algorithm and the SQI is provided, an “Invalid value received for field unknown for number ( ), as decimal bytes (32 32 32 32 32 32 32 32 32 32 32 32 32 32 66 73 76 12 ).” The error is coming from RateComponentCalculationAlgorithmFromCobolWrapper_Impl.

The error was encountered in the upgraded test environment as well as on the CCB 2.6 demo environment.


SYSUSER - 667704-983-1 2018-01-23 13:11:25,951 [[ACTIVE] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (support.cobol.CobolByteBuffer) Invalid value received for field unknown for number ( NAV-), as decimal bytes (32 32 32 32 32 32 32 32 32 32 32 32 32 32 78 65 86 45 )
java.lang.NumberFormatException: For input string: " NAV-"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) ~[?:1.8.0_40]
at java.lang.Long.parseLong(Long.java:578) ~[?:1.8.0_40]
at java.lang.Long.parseLong(Long.java:631) ~[?:1.8.0_40]
at com.splwg.base.support.cobol.CobolByteBuffer.readS9Integer(CobolByteBuffer.java:163) [spl-base-]
at com.splwg.base.support.cobol.CobolByteBuffer.readS9Integer(CobolByteBuffer.java:141) [spl-base-]
at com.splwg.base.support.cobol.CobolByteBuffer.readDecimal(CobolByteBuffer.java:103) [spl-base-]
at com.splwg.base.support.cobol.CobolByteBuffer.readDecimal(CobolByteBuffer.java:127) [spl-base-]
at com.splwg.ccb.cobol.InputRedefineHelper.getOffsetDecimal(InputRedefineHelper.java:73) [spl-ccb-]
at com.splwg.ccb.domain.rate.cobolInterface.ApplyRateBillLineCobolDataMapper_Impl.setBillLineSourceData(ApplyRateBillLineCobolDataMapper_Impl.java:767) [spl-ccb-]
at com.splwg.ccb.domain.rate.cobolInterface.ApplyRateBillLineCobolDataMapper_Impl.buildDataFromCopybook(ApplyRateBillLineCobolDataMapper_Impl.java:146) [spl-ccb-]
at com.splwg.ccb.domain.rate.cobolInterface.ApplyRateBillLineCobolDataMapper_Impl.mapDataFromCobol(ApplyRateBillLineCobolDataMapper_Impl.java:105) [spl-ccb-]
at com.splwg.ccb.domain.rate.cobolInterface.ApplyRateBillLineCobolDataMapper_Impl$$EnhancerByCGLIB$$5ffbc01b.CGLIB$mapDataFromCobol$0() [spl-ccb-]
at com.splwg.ccb.domain.rate.cobolInterface.ApplyRateBillLineCobolDataMapper_Impl$$EnhancerByCGLIB$$5ffbc01b$$FastClassByCGLIB$$449a9723.invoke() [spl-ccb-]
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) [cglib-3.2.4.jar:?]
at com.splwg.base.support.interception.BusinessMethodInterceptor.intercept(BusinessMethodInterceptor.java:84) [spl-base-]

The issue can be reproduced at will with the following steps:
1. Set-up a Rate Component with type Calculation Algorithm and provide an SQI code
2. You can bill the account with SA using the Rate Schedule or simply use Rate Check for the specific SA.

The issue has the following business impact:
Go live is June 2018, with testing needed to be done by end of Feb.


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