My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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

Asset Liability Management (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, PRODUCT_ID:101, ISO_CURRENCY_CD:USD

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

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.