Bill Factor Values Not Accepting Negative Values

(Doc ID 2306524.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On :  2.5.0.2.0 version, ENV - Environment

Bill Factor Values not accepting negative values and throwing the following error:

 Exception encountered in executing StringField (
   name=ProgramName
   value=StringFieldValue(value=CIPTBFVR
      bytes={43 49 50 54 42 46 56 52 }
      interpreted =CIPTBFVR
      )
   ). Please see log for details.


ERROR
-----------------------
ERROR
(web.dataservlet.PageChange) Unexpected error.
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.service.ServiceReplayExecuter.executeInAppropriateSession(ServiceReplayExecuter.java:114):
 Exception occurred calling serviceName: CILTBFVP
com.splwg.base.support.service.ServiceReplayExecuter$2.execute(ServiceReplayExecuter.java:166):
 Caught exception from SessionExecutable.execute()
com.splwg.base.support.service.LegacyServiceAdapter.invokePageService(LegacyServiceAdapter.java:58): Rollback: Change failed
java.lang.reflect.Method.invoke(Method.java:497):
 Error while invoking Program CIPTBFVP,
com.splwg.ccb.domain.admin.billFactor.entity.ProgramCIPTBFVP
com.splwg.ccb.domain.admin.billFactor.entity.ProgramCIPTBFVP.perform_IA000_PERFORM_ACTION(ProgramCIPTBFVP.java:558):
 Exception encountered in executing StringField (
   name=ProgramName
   value=StringFieldValue(value=CIPTBFVP
      bytes={43 49 50 54 42 46 56 50 }
      interpreted =CIPTBFVP
      )
   ). Please see log for details.
com.splwg.ccb.domain.admin.service.ProgramCIPTBVLL.perform_GA000_PERFORM_ACTION(ProgramCIPTBVLL.java:823):
 Exception encountered in executing StringField (
   name=ProgramName
   value=StringFieldValue(value=CIPTBVLL
      bytes={43 49 50 54 42 56 4c 4c }
      interpreted =CIPTBVLL
      )
   ). Please see log for details.

The root LoggedException was: Exception encountered in executing StringField (
   name=ProgramName
   value=StringFieldValue(value=CIPTBFVR
      bytes={43 49 50 54 42 46 56 52 }
      interpreted =CIPTBFVR
      )
   ). Please see log for details.
...
Caused
 by: com.splwg.base.api.program.types.UnsignedNumberException: Unsigned
Number: -0.5000000. Minimum value should be zero(0) for Numeric Field:
NumberFieldMD (
      name=WFrac
      primaryName=W-FRAC
      index=38
      byteRange=[550,556] size=7
      precision=7
      scale=7
      signed=false
      )



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. As a part of implementation some of the charges have unit price as negative value. In such cases the Bill is generated with a negative amount, which is eventually refunded to the end customer.
2.The unit price is held in Bill Factors, however when they tried to add a new effective dated value on a TEST bill factor, they are getting "The server has encountered a problem. Your request cannot be processed Please try again".

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
One is unable to add new effective.

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