Issue With The Audit Program (CIPZADTA) On The CI_CASE_CHAR Table
(Doc ID 2249618.1)
Last updated on JUNE 07, 2021
Applies to:
Oracle Utilities Customer Care and Billing - Version 2.5.0.1.0 and laterInformation 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
)
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 |