ALM Process is Failing Due to ORA-01438 Errors on FSI_O_RESULT_MASTER Insert for CUR_PAR_BAL and CUR_NET_PAR_BAL (Doc ID 2092454.1)

Last updated on JUNE 02, 2023

Applies to:

Symptoms

On ALM 8.0.0, during the ALM process for FSI_D_FX_CONTRACTS,  the cash flow engine is attempting to insert data into FSI_O_RESULT_MASTER for below columns along with data type:

1.CUR_NET_PAR_BAL NUMBER(14,2)
2.CUR_PAR_BAL NUMBER(14,2)

But the value in the source after consolidation is resulting in a Number 13 precision values are given below:-
1. cur_net_par_bal = 1195391778069
2. cur_par_bal = 1195391778069

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_RESULT_MASTER(result_sys_id, ORG_UNIT_ID,
  GL_ACCOUNT_ID, COMMON_COA_ID, PRODUCT_ID, LEGAL_ENTITY_ID,
  iso_currency_cd, scenario_num, start_date_index, result_type_cd,
  leg_type, financial_rollup, cur_par_bal, cur_net_par_bal,
  cur_defer_bal_c, cur_net_rate_w, cur_transfer_rate, cur_warm,
  cur_intr_rec_accr, new_gross_balance, new_net_balance,
  market_value, duration, convexity, modified_duration, ytm,
  average_life, DV01, market_value_clean, CUR_LIQ_PREM_RATE,
  CUR_BAS_RISK_COST_RATE, CUR_PRIC_INCENT_RATE, CUR_OTH_ADJ_RATE)
values (:result_sys_id, :ORG_UNIT_ID, :GL_ACCOUNT_ID,
  :COMMON_COA_ID, :PRODUCT_ID, :LEGAL_ENTITY_ID, :iso_currency_cd,
  :scenario_num, :start_date_index, :result_type_cd, :leg_type,
  :financial_rollup, :cur_par_bal, :cur_net_par_bal,
  :cur_defer_bal_c, :cur_net_rate_w, :cur_transfer_rate, :cur_warm,
  :cur_intr_rec_accr, :new_gross_balance, :new_net_balance,
  :market_value, :duration, :convexity, :modified_duration, :ytm,
  :average_life, :DV01, :market_value_clean, :CUR_LIQ_PREM_RATE,
  :CUR_BAS_RISK_COST_RATE, :CUR_PRIC_INCENT_RATE, :CUR_OTH_ADJ_RATE
  )


Module Logging OFS errors: (203055) Error Bound Parameters: :result_sys_id = 200861
  :ORG_UNIT_ID = 0 :GL_ACCOUNT_ID = 0 :COMMON_COA_ID = - 99100
  :PRODUCT_ID = 13110111100025 :LEGAL_ENTITY_ID = 36132
  :iso_currency_cd = JPY :scenario_num = 1 :start_date_index = 0
  :result_type_cd = 0 :leg_type = 1 :financial_rollup = - 1
  :cur_par_bal = 1195391778069 :cur_net_par_bal = 1195391778069
  :cur_defer_bal_c = 0 :cur_net_rate_w = 0 :cur_transfer_rate = 0
  :cur_warm = 3275045931.42141 :cur_intr_rec_accr = 0
  :new_gross_balance = 0 :new_net_balance = 0 :market_value = 0
  :duration = 0 :convexity = 0 :modified_duration = 0 :ytm = 0
  :average_life = 0 :DV01 = 0 :market_value_clean = 0
  :CUR_LIQ_PREM_RATE = 0 :CUR_BAS_RISK_COST_RATE = 0
  :CUR_PRIC_INCENT_RATE = 0 :CUR_OTH_ADJ_RATE = 0 SQL statement.

The issue can be reproduced at will with the following steps:
1. Run ALM process on FSI_D_FX_CONTRACTS
2. Check the log file for error

Cause

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