Error When I Set Up Audit Table (Doc ID 2279842.1)

Last updated on JUNE 26, 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

The following error is encountered when setting up an audit table for some system table:
CI_SCR_STEP
F1_SCHEMA    
F1_MAP

ERROR
-----------------------
KDS - 133922-3716-1  2017-06-13 13:43:34,013
 [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default
(self-tuning)'] 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: CILZSCRP
com.splwg.base.support.service.ServiceReplayExecuter$2.execute(ServiceReplayExecuter.java:166):
 Caught exception from SessionExecutable.execute()

The root LoggedException was: Rollback: Change failed
...
Caused
 by: com.splwg.base.api.program.types.MathOverflowException: Numeric
Overflow: 1073741824. 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
      )


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot audit tables.

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