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

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5.39 and later
Oracle Financial Services Asset Liability Management - Version 5.2 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.

Symptoms

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.

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