ORA- 01747: Invalid User.table.column, Table.column Error in FTP Process For Break Funding Table (Doc ID 1523147.1)

Last updated on JANUARY 25, 2013

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA) - Version 6.0

Symptoms

On Oracle Financial Services Funds Transfer Pricing (FTP) 6.0, when attempting to run an FTP Standard Process using an Economic Loss Adjustment rule on FSI_D_BREAK_FUNDING_CHARGES, the following error occurs:

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- 01747: invalid user.table.column, table.column,
or column specification 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.FTP_COA_ID, a.LCP_COA_ID, a.id_number,
a.identity_code, a.as_of_date, a.cur_net_rate,
a.ADJ_EFFECTIVE_DATE, a.org_term, a.org_term_mult, a.pmt_freq,
a.pmt_freq_mult, a.org_book_bal, a.percent_sold,
a.adjustable_type_cd, a.cur_book_bal, a., a.accrual_basis_cd,
a.BREAK_FUNDING_RATE, a.BREAK_FUNDING_AMT, a.BREAK_FUNDING_MV,
a.BREAK_FUNDING_AMT_CHG, a.BREAKAGE_TYPE_CD, a.amrt_term,
a.amrt_term_mult, a.amrt_type_cd, a.cur_par_bal,
a.cur_tp_per_adb, a.cur_gross_rate, a.cur_payment,
a.deferred_cur_bal, a.deferred_org_bal, a.interest_rate_cd,
a.last_reprice_date, a.margin, a.margin_gross, a.margin_t_rate,
a.maturity_date, a.neg_amrt_eq_date, a.neg_amrt_eq_freq,
a.neg_amrt_eq_mult, a.neg_amrt_limit, a.neg_amrt_amt,
a.net_margin_cd, a.next_payment_date, a.next_reprice_date,
a.org_par_bal, a.org_payment_amt, a.origination_date,
a.issue_date, 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.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.teaser_end_date, a.t_rate_int_rate_cd, a.last_payment_date,
a.int_type, a.lrd_balance, a.instrument_type_cd,
a.compound_basis_cd, a.iso_currency_cd, a.tp_average_life,
a.tp_duration, a.tp_effective_date, a.RESIDUAL_AMOUNT,
a.MATURITY_AMOUNT, a.AMORT_METH_PDFC_CD, 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
from FSI_D_BREAK_FUNDING_CHARGES a
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.FTP_COA_ID = :FTP_COA_ID
and (((a.ID_NUMBER = ' 90007')))
and as_of_date = to_date('05/ 16/ 2012', 'mm/ dd/ yyyy')
order by a.id_number, a.identity_code

Per the above, there are two columns which do not have the correct column names: TRANSFER_RATE. The column above is currently listed as a. , triggering the error.

STEPS
The issue can be reproduced at will with the following steps:

1. Run FTP Standard Process with Economic Loss Breakage Charge Adjustment rule
2. Check the generated FTP log error

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