My Oracle Support Banner

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

Last updated on MARCH 04, 2019

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

**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing

On CCB v2.5.0.1.0

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

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
Goal
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.