My Oracle Support Banner

Datatype Limitation - ORA-01438 - While inserting data to EIM tables (Doc ID 2528943.1)

Last updated on DECEMBER 10, 2019

Applies to:

Siebel CRM - Version 16.18 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.18 [IP2016] version, EIM

Not able to store a numeric value in BASE tables. The numeric value has 12 digits on left hand side of the decimal and 2 digits on the right side.
Sample value 804816928324.18.
The column used is an extended column with Physical type as Number and Length = 22 Precision =22 and Scale as 7.

ERROR
-----------------------
SQL Error: ORA-01438: value larger than specified precision allowed for this column
01438. 00000 - "value larger than specified precision allowed for this column"
*Cause: When inserting or updating records, a numeric value was entered
  that exceeded the precision defined for the column.
*Action: Enter a value that complies with the numeric column's precision,
  or use the MODIFY option with the ALTER TABLE command to expand
  the precision."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created a custom column for BASE table and EIM table
2. Did EIM mapping
3. Insert data into 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.