Internal Error and ORA-01438: value larger than specified Errors While Running 4.5 RM Process (Doc ID 1967640.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

On RM 4.5.39, when attempting to run a test RM process, the process a last few cashflows should get saved in ofsa_process_cash_flows, but the process is running showing internal error while completion and there is no data for this result sys id in ofsa process cash flows.

ERROR

Module Logging OFS errors: (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 Driver Function:
drv_oci::Execute() SQL Statement:
insert into OFSA_PROCESS_CASH_FLOWS ( result_sys_id,
record_sequence, cash_flow_sequence, scenario_num,
financial_elem_id, id_number, cash_flow_date, cash_flow_cd,
float_value, product_leaf_node, org_leaf_node, iso_currency_cd,
calc_source_cd)
values ( :result_sys_id, :record_sequence, :cash_flow_sequence,
:scenario_num, :financial_elem_id, :id_number, :cash_flow_date,
:cash_flow_cd, :float_value, :product_leaf_node, :org_leaf_node,
:iso_currency_cd, :calc_source_cd )

Module Logging OFS errors: (203055) Error Bound Parameters: :result_sys_id = 105354
:record_sequence = 1 :cash_flow_sequence = 1 :scenario_num = 1
:financial_elem_id = 210 :id_number = 2.3018266747285000019E+ 25
:cash_flow_date = 02/ 03/ 2011 :cash_flow_cd = 1 :float_value = 0
:product_leaf_node = 200238 :org_leaf_node = 31001001
:iso_currency_cd = INR :calc_source_cd = 0 SQL statement.

The issue can be reproduced at will with the following steps:
1. Run RM process
2. Check for OFSA_PROCESS_CASH_FLOWS

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