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 MARCH 17, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)

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

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