Issue With The Audit Program (CIPZADTA) On The CI_CASE_CHAR Table (Doc ID 2249618.1)

Last updated on APRIL 20, 2017

Applies to:

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

Goal

On : 2.5.0.1.0 version, CA - Case Management

Steps to Replicate:
--------------------
1. Attach an audit program (CIPZADTA) to the CI_CASE table metadata with
CI_AUDIT as audit table.
2. Create a case.
3. Verify that error will be encountered. Below is the log of the error:

ERROR
--------
In Application logs, getting following exception:

java.lang.reflect.Method.invoke(Method.java:497): Error while invoking Program CIPQCASP, com.splwg.ccb.domain.todo.caseManagement.entity.ProgramCIPQCASP
com.splwg.ccb.domain.todo.caseManagement.entity.ProgramCIPQCASP.perform_IA000_PERFORM_ACTION(ProgramCIPQCASP.java:1284): Exception encountered in executing StringField (
  name=ProgramName
  value=StringFieldValue(value=CIPQCASP
  bytes={43 49 50 51 43 41 53 50 }
  interpreted =CIPQCASP
  )
  )
Caused by: com.splwg.base.api.program.types.MathOverflowException: Numeric Overflow: 1048576. Can't write to Numeric Field: NumberFieldMD (
  name=FldLength
  primaryName=FLD-LENGTH
  index=1
  byteRange=[30,34] size=5
  precision=5
  scale=0
  signed=false
  )

Solution

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