My Oracle Support Banner

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

Last updated on NOVEMBER 06, 2017

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.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.