ALM Process Hangs or Fails with No Errors Reported (Doc ID 1493062.1)

Last updated on APRIL 18, 2024

Applies to:

Symptoms

In Oracle Financial Services Asset Liability Management (ALM), when you run an ALM Process, the process hangs or fails before outputting results for all products.  There are no errors:

• There are no errors in FSI_PROCESS_ERRORS
• There are no ORA- errors listed in the ofsrm log in $FIC_DB_HOME/log/FusionApps
• The process stops writing to the log file long before the ofsrm process on the server hangs or fails

The last statement in the ofsrm.xxxxxx.log is a select from the instrument table.  For example:

Module Logging OFS Access module data: select
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
a.PRODUCT_ID,  a.iso_currency_cd, a.id_number, a.identity_code,
a.account_number, a.instrument_type_cd, a.as_of_date,
a.accrual_basis_cd, a.amrt_term, a.amrt_term_mult,
a.amrt_type_cd, a.cur_book_bal, a.cur_par_bal, a.cur_tp_per_adb,
a.cur_gross_rate, a.cur_net_rate, a.cur_payment,
a.deferred_cur_bal, a.deferred_org_bal, a.EFF_INTEREST_RATE_C,
a.fees_eir, a.interest_rate_cd, a.margin, a.last_reprice_date,
a.margin_gross, a.matched_spread_c, a.maturity_date,
a.net_margin_cd, a.next_payment_date, a.next_reprice_date,
a.org_par_bal, a.org_payment_amt, a.org_term, a.org_term_mult,
a.origination_date, a.issue_date, a.percent_sold, a.pmt_freq,
a.pmt_freq_mult, a.prior_tp_per_adb, a.rate_cap_life,
a.rate_chg_min, a.rate_chg_rnd_cd, a.rate_chg_rnd_fac,
a.rate_decr_cycle, a.rate_floor_life, a.rate_incr_cycle,
a.rate_set_lag, a.rate_set_lag_mult, a.remain_no_pmts_c,
a.reprice_freq, a.reprice_freq_mult, a.transfer_rate,
a.tran_rate_rem_term, a.lrd_balance, a.int_type,
a.adjustable_type_cd, a.instrument_type_cd, a.last_payment_date,
a.compound_basis_cd, a.AMORT_METH_PDFC_CD, a.margin_t_rate,
a.neg_amrt_eq_date, a.neg_amrt_eq_freq, a.neg_amrt_eq_mult,
a.neg_amrt_limit, a.neg_amrt_amt, a.pmt_adjust_date,
a.pmt_chg_freq, a.pmt_chg_freq_mult, a.pmt_decr_cycle,
a.pmt_decr_life, a.pmt_incr_cycle, a.pmt_incr_life,
a.teaser_end_date, a.t_rate_int_rate_cd,
a.HOLIDAY_ROLLING_CONVENTION_CD, a.RESIDUAL_AMOUNT,
a.MATURITY_AMOUNT, a.EXPECTED_BAL, a.EXPECTED_BAL_GROWTH_PCT,
a.OFFSET_PERCENT, a.MINIMUM_BALANCE, a.BEHAVIOUR_TYPE_CD,
a.BEHAVIOUR_SUB_TYPE_CD, a.DEVOLVEMENT_STATUS_CD,
a.liquidity_premium_rate, a.basis_risk_cost_rate,
a.pricing_incentive_rate, a.other_adjustments_rate,
a.ACCRUED_INTEREST
from FSI_D_LOAN_CONTRACTS a
where a.as_of_date = :as_of_date
and a.PRODUCT_ID = :PRODUCT_ID
and a.ORG_UNIT_ID = :ORG_UNIT_ID
and a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and (((a.COMMON_COA_ID = 8)
or (a.COMMON_COA_ID = 27)))
and AS_OF_DATE = TO_DATE('08/ 31/ 2012', 'MM/ DD/ YYYY')

This failure prevents the ALM process from generating results for all products.

Cause

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