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 and later
Information in this document applies to any platform.


On : 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:

In Application logs, getting following exception:

java.lang.reflect.Method.invoke( 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( Exception encountered in executing StringField (
  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 (
  byteRange=[30,34] size=5


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