ALM Process Fails with 'ORA-00001: unique constraint (XAK1FSI_O_RESULT_MASTER) violated' (Doc ID 2275514.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 8.0.2, when you run an ALM Process, the process fails.  When you check the ofsrm.xxxxx.log in $FIC_DB_HOME/log/FusionApps, you find the following ORA-00001 error:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
          oexn() SQL Function: [3] -
INSERT Oracle Error: ORA- 00001: unique constraint
          (<atomic>.XAK1FSI_O_RESULT_MASTER) violated 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,
          TP_COA_ID, RM_COA_ID, MARKET_SECTOR_ID, REPORT_CENTER_ID,
          REPORT_GL_ACC_ID, STRATEGY_ID, CUSTOM1, CUSTOM2, 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, :TP_COA_ID,
          :RM_COA_ID, :MARKET_SECTOR_ID, :REPORT_CENTER_ID,
          :REPORT_GL_ACC_ID, :STRATEGY_ID, :CUSTOM1, :CUSTOM2,
          :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 )

You already updated the unique index on FSI_O_RESULT_MASTER to include your custom key dimension columns.  You do not understand why it fails with this error.

Changes

Cause

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