ORA- 01438 on Market Value Columns for ALM Process (Doc ID 2224606.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

ALM Dynamic Deterministic process failed with the following error.

ERROR
$FIC_DB_HOME/log/FusionApps/ofsrm.<INFODOM>_xxx.log and ofsrm.<INFODOM>_xxx.error show:

Module Logging OFS calculation module data: Executing: LEG_TYPE:0, RM_COA_ID:114310, ISO_CURRENCY_CD:OMR

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 allowed for this column Driver Function:
drv_oci::Execute() SQL Statement:
update FSI_D_LOAN_CONTRACTS a
set market_value_c = :market_value_c, market_value_clean_c =
:market_value_clean_c
where a.rowid = :0

Module Logging OFS errors: (203055) Error Bound Parameters:
:market_value_c = -33489.5682999239
:market_value_clean_c = - 33489.5682999239 :0 =
AABMHFAAmAAChWMAAF 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