ORA- 01438 on Market Value Columns for ALM Process
(Doc ID 2224606.1)
Last updated on APRIL 05, 2024
Applies to:
Oracle Financial Services Asset Liability Management - Version 6.1 and laterInformation 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 |