My Oracle Support Banner

Datatype not in sync between Staging And Processing (Doc ID 2609502.1)

Last updated on NOVEMBER 17, 2019

Applies to:

Oracle Financial Services Liquidity Risk Management - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

While inserting data in FSI_LRM_INSTRUMENT in column N_VOLUME_OF_INSTRUMENTS having datatype NUMBER(10,0) from N_UNITS_HELD column of stage table STG_INVESTMENTS having datatype NUMBER(22,3), if data comes more than 10 digits in N_UNITS_HELD column in STG_INVESTMENTS table, then below error encounters.

Error report -
ORA-01438: 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.