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

Last updated on JULY 14, 2016

Applies to:

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

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:

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.

Changes

 

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