Getting ORA-00904 on Instrument Column in Select Statement Running ALM Process (Doc ID 1382878.1)

Last updated on FEBRUARY 18, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 5.6 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, it fails to output results and there is an ORA-00904 error on a column included in the SELECT from the instrument table being processed in the ALM log in $FIC_DB_HOME/log/FusionApps.  For example:

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"."FEES_EIR": 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.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.ID_NUMBER = ' 11167855')))
and AS_OF_DATE = TO_DATE('09/ 30/ 2011', 'MM/ DD/ YYYY')

The error prevents the ALM process from completing and outputting results to the RES_DTL_xxxxxx 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