ALM Dynamic Deterministic Process With Discount Method Stops Abruptly (Doc ID 2830298.1)

Last updated on JULY 12, 2023

Applies to:

Symptoms

On 8.0.x version, ALM Dynamic Deterministic process stops abruptly at query towards instrument table in calculation engine log.

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.LEGAL_ENTITY_ID, a.STRATEGY_ID, a.CUSTOM1,
a.CUSTOM2, a.SEGMENTS_ID, a.FLEXCUBE_GL_ID, a.OGL_PRODUCT_ID,
a.ORACLE_SUB_GL_ID, a.SUB_SEGMENTS_ID, a.RM_ID, a.CUSTOMER_ID,
a.iso_currency_cd, a.id_number, a.identity_code,
a.account_number, a.HOLIDAY_CALENDAR_CODE,
a.HOLIDAY_ROLLING_CONVENTION_CD, a.HOLIDAY_CALC_OPTION_CD,
a.INT_SENSITIVE_IND, 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.EMBEDDED_OPTIONS_FLG, 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.ir_margin_type_cd,
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.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, a.ACCRUED_GROSS_AMT,
a.ACCRUED_TRANSFER_AMT, a.OPTION_VOL_IRC_CD, a.OPTION_RFR_IRC_CD
from <INSTRUMENT_TABLE> a
where a.as_of_date = :as_of_date
and a.PRODUCT_ID = :PRODUCT_ID
and a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.PRODUCT_ID in (select leaf_node
from OFSA_IDT_ROLLUP
where sys_id_num=100001
and ((leaf_node in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=7)
or node_01 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=6)
or node_02 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=5)
or node_03 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=4)
or node_04 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=3)
or node_05 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=2)
or node_06 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=1))
or (exists (select *
from REV_HIERARCHY_FILTER
where sys_id_num=123456
and hierarchy_level=0
and leaf_node=0))))
and AS_OF_DATE = TO_DATE('10/ 31/ 2020', 'MM/ DD/ YYYY')
and LEGAL_ENTITY_ID = - 1

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.