Datatype Limitation - ORA-01438 - While inserting data to EIM tables
(Doc ID 2528943.1)
Last updated on JUNE 25, 2021
Applies to:Siebel CRM - Version 16.18 [IP2016] and later
Information in this document applies to any platform.
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.
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 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
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