ALM Process Gets ORA-01438 Inserting Records into FSI_O_PROCESS_CASH_FLOWS (Doc ID 1669149.1)

Last updated on OCTOBER 07, 2024

Applies to:

Symptoms

In Oracle Financial Services Asset Liability Management (ALM), when you run a Static Deterministic ALM Process, rows are output to the RES_DTL_xxxxx table but no records are output to FSI_O_PROCESS_CASH_FLOWS.  In the ALM Process definition, in the Audit screen, you selected the "Detail Cash Flows" box and "All records".

When you check the ofsrm log in $FIC_DB_HOME/log/FusionApps, you find the following ORA-01438 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 allowed for this column Driver Function:
    drv_oci::Execute() SQL Statement:
insert    into FSI_O_PROCESS_CASH_FLOWS(result_sys_id,
    product_leaf_node, org_leaf_node, iso_currency_cd, id_number,
    record_sequence, cash_flow_sequence, scenario_num,
    financial_elem_id, cash_flow_date, cash_flow_cd, float_value,
    calc_source_cd)
values    (:result_sys_id, :product_leaf_node, :org_leaf_node,
    :iso_currency_cd, :id_number, :record_sequence,
    :cash_flow_sequence, :scenario_num, :financial_elem_id,
    :cash_flow_date, :cash_flow_cd, :float_value, :calc_source_cd )


Module Logging OFS errors: (203055) Error Bound Parameters: :result_sys_id = 201181
    :product_leaf_node = 2010 :org_leaf_node = 1220 :iso_currency_cd
    = USD :id_number = 12 :record_sequence = 1 :cash_flow_sequence =
    37 :scenario_num = 1 :financial_elem_id = 210 :cash_flow_date =
    12/ 31/ 2016 :cash_flow_cd = 2 :float_value = 121803083077
    :calc_source_cd = 0 SQL statement.


Module Logging OFS errors: (203055) Error Executing SQL statement.

The error appears to prevent population of FSI_O_PROCESS_CASH_FLOWS.

Cause

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