My Oracle Support Banner

ORA-01438 Error on FE 430 Running Risk Manager or ALM Process with Payment Schedule (Doc ID 397110.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


A Risk Manager (RM) or Oracle Financial Services Asset Liability Management (ALM) process that uses payment schedule information in OFSA_PAYMENT_SCHEDULE (RM) / FSI_D_PAYMENT_SCHEDULE (ALM) is failing with the following ORA-01438 error in the ofsrm.xxxxx file:

Running RM, Process ID: 103209 Configuration ID: 100001
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [3] - INSERT
Oracle Error: ORA-01438: value larger than specified precision allows for this column

The insert error occurs when inserting a row for Financial Element (FE) 430 (Interest Cash Flow) into OFSA_PROCESS_CASH_FLOWS / FSI_O_PROCESS_CASH_FLOWS and the RES_DTL_xxxxx table.  The FE 430 value is very large.  For example: bucket_001 = 22961566390204.6

Note: Records using the Payment Schedule data have an AMRT_TYPE_CD of 800, 801, or 802.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.