Audit Log P_LM_REGULATORY_CONTACT_I fails with ORA-01438 (Doc ID 2173145.1)

Last updated on AUGUST 19, 2016

Applies to:

Oracle Argus Safety Cloud Service - Version 8.0 and later
Oracle Argus Safety - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Inserting or updating reporting destination data from back end using 'P_LM_REGULATORY_CONTACT_I' or 'P_LM_REGULATORY_CONTACT_U' package results in the following error:


ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "ARGUS_APP.PKG_CNSL_CL_REGULATORY_CONTACT", line 428
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_INSERT_AUDIT", line 2217
ORA-06512: at line 1
01438. 00000 - "value larger than specified precision allowed for this
column"

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