ALM Deterministic Process Failed with ORA-01438 on Result Master or Consolidated Master for YTM Field (Doc ID 1961857.1)

Last updated on JULY 29, 2015

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0 to 6.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

ALM 6.0.1.

ALM deterministic process failed with the following error.

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_CONSOLIDATED_MASTER(result_sys_id, ORG_UNIT_ID,
  GL_ACCOUNT_ID, COMMON_COA_ID, PRODUCT_ID, LOB_ID, RSM_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, 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, :LOB_ID, :RSM_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, :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 = 228932
  :ORG_UNIT_ID = 0 :GL_ACCOUNT_ID = 0 :COMMON_COA_ID = 200
  :PRODUCT_ID = 180306 :LOB_ID = 0 :RSM_ID = 0 :iso_currency_cd =
  AED :scenario_num = 1 :start_date_index = 1 :result_type_cd = 0
  :leg_type = 0 :financial_rollup = 200 :cur_par_bal =
  1556654.39307395 :cur_net_par_bal = 1556654.39307395
  :cur_defer_bal_c = 0 :cur_net_rate_w = 0 :cur_transfer_rate = 0
  :cur_warm = 132209.00179851 :cur_intr_rec_accr = 0
  :new_gross_balance = 0 :new_net_balance = 0 :market_value =
  1556353.74504495 :duration = 132183.468757242 :convexity =
  986460.173947673 :modified_duration = 76067.3750681094
  :ytm =   5.84451771380648e+ 94
  :average_life = 0 :market_value_clean =1556353.74504495
  :CUR_LIQ_PREM_RATE = 0 :CUR_BAS_RISK_COST_RATE =0
  :CUR_PRIC_INCENT_RATE = 0 :CUR_OTH_ADJ_RATE = 0 SQL statement.



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