ORA-01438 Error on FE 430 Running Risk Manager or ALM Process with Payment Schedule
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.
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:  - oexec(), oexn()
SQL Function:  - 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.
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