My Oracle Support Banner

"ORA- 01438: value larger than specified" Received While Populating MARKET_VALUE_C (Doc ID 2011080.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Risk Manager - Version 4.0 to 4.5.41
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Note: All OFSA 4.5 products have reached sustaining support.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to run an OFSA Risk Manager (RM) process, a numeric overflow occurs for market value field:

ERROR
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [5] -
UPDATE Oracle Error: ORA- 01438: value larger than specified
precision allows for this column Driver Function:
drv_oci::Execute() SQL Statement:
update CONSUMER_LOAN a
set market_value_c = :market_value_c
where a.rowid = :0

Module Logging OFS errors: (203055) Error Bound Parameters: :market_value_c =
45075.1188506023 :0 = AAAisTALAAAACHRAAL SQL statement.

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.