ALM Process Against FSI_D_LEDGER_STAT_INSTRUMENT Outputs No Rows (Doc ID 1353604.1)

Last updated on JULY 20, 2015

Applies to:

Oracle Financial Services Asset Liability Management - Version 5.5 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) 5.5, when you run an ALM Process against the FSI_D_LEDGER_STAT_INSTRUMENT table, you do not get any results in the Result Detail output table.  If you run the same process against data in other instrument tables, you do get results.  You expect to see results for FSI_D_LEDGER_STAT_INSTRUMENT also.

When you turn on logging for ALM in Application Preferences, the ofsrm log output to $FIC_DB_HOME/log/FusionApps contains the following ORA-00904 error:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00904: "A"."ACCOUNT_NUMBER": invalid identifier Driver
Function: drv_oci::Execute() SQL Statement:

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.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_LEDGER_STAT_INSTRUMENT 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 AS_OF_DATE = TO_DATE('07/ 02/ 2011', 'MM/ DD/ YYYY')

Module Logging OFS errors: (203055) Error LoadStart() : Execute() SQL statement.

Module Logging OFS errors: (203055) Error Bound Parameters: :as_of_date = 07/ 02/ 2011
:PRODUCT_ID = 1001 :ORG_UNIT_ID = 10 :ISO_CURRENCY_CD =
  USD

Steps to Reproduce:

  1. Go to Asset Liability Management
  2. Go to ALM Processing > Static Process > Static Deterministic
  3. Run an ALM Process with FSI_D_LEDGER_STAT_INSTRUMENT as the source table

No rows are output to the RES_DTL_xxxxxxx table.

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