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

Last updated on JULY 28, 2017

Applies to:

Oracle Risk Manager - Version 4.0 to 4.5.41
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.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms