My Oracle Support Banner

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

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety Cloud Service - Version 8.0 and later
Oracle Life Sciences 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

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
Symptoms
Cause
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.