My Oracle Support Banner

ALM Process Fails When Repricing Pattern is Added in Version 6.0.3 (Doc ID 2388890.1)

Last updated on APRIL 24, 2018

Applies to:

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

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 6.0.3, after adding a Repricing Pattern to instrument records by updating ADJUSTABLE_TYPE_CD, when you run an ALM Process, it fails.  The following is the last SQL in the ofsrm.xxxxxx.log in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS calculation module data: select
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
       a.PRODUCT_ID, a.LOB_ID, a.OFFICER_ID, a.CUSTOM1_ID, a.CUSTOM2_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_gross_rate,
       a.cur_net_rate, a.cur_payment, a.interest_rate_cd, a.margin,
       a.last_reprice_date, a.maturity_date, a.next_payment_date,
       a.next_reprice_date, a.org_term, a.org_term_mult, a.pmt_freq,
       a.pmt_freq_mult, a.remain_no_pmts_c, a.reprice_freq,
       a.reprice_freq_mult, a.origination_date, a.int_type,
       a.last_payment_date, a.compound_basis_cd, a.issue_date,
       a.adjustable_type_cd, a.org_payment_amt, a.org_par_bal,
       a.AMORT_METH_PDFC_CD, a.cur_tp_per_adb, a.deferred_cur_bal,
       a.deferred_org_bal, a.EFF_INTEREST_RATE_C, a.fees_eir,
       a.margin_gross, a.matched_spread_c, a.net_margin_cd,
       a.percent_sold, 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.transfer_rate,
       a.tran_rate_rem_term, a.lrd_balance, a.liquidity_premium_rate,
       a.basis_risk_cost_rate, a.pricing_incentive_rate,
       a.other_adjustments_rate, 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.ACCRUED_INTEREST
from TBL_ALM_AGGR_INSTR a
where a.as_of_date = :as_of_date
and a.PRODUCT_ID = :PRODUCT_ID
and a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and AS_OF_DATE = TO_DATE('11/ 30/ 2017', 'MM/ DD/ YYYY')

If you run the same ALM Process without the Repricing Pattern, it runs successfully.  You expect the ALM Process to run successfully after the Repricing Pattern is added.

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.