ORA-00904: "A"."REMAIN_NO_PMTS": INVALID IDENTIFIER W/ NON CASH FLOW FTP PROCESS (Doc ID 399657.1)

Last updated on DECEMBER 22, 2006

Applies to:

Oracle Transfer Pricing - Version: 11.5.9 to 11.5.10
This problem can occur on any platform.

Symptoms

User receives an error message when running a non-cash flow methodology for a FTP (Funds Transfer Pricing) process.  The table being processed is not classified as cash flow.  They see the the following error message:

APP-FND-01564: ORACLE error 904 in drv_upi

Cause: drv_upi failed due to ORA-00904: "A"."REMAIN_NO_PMTS": invalid identifier
.

The SQL statement being executed at the time of the error was: select a.rowid,a.LINE_ITEM_ID,a.COMPANY_COST_CENTER_ORG_ID,a.LINE_ITEM_ID,a.CURRENCY_CODE,a.CHANNEL_ID,a.GEOGRAPHY_ID,a.NATURAL_ACCOUNT_ID,a.USER_DIM1_ID,a.USER_DIM2_ID,a.USER_DIM3_ID,a.USER_DIM4_ID,a.USER_DIM5_ID,a.USER_DIM6_ID,a.USER_DIM7_ID,a.USER_DIM8_ID,a.USER_DIM9_ID,a.USER_DIM10_ID,a.id_number,a.source_system_code,a.CUR_NET_RATE,a.percent_sold,a.cur_book_bal,a.transfer_rate,a.matched_spread,a.accrual_basis_id,a.amrt_term,a.amrt_term_mult,a.amrt_type_code,a.cur_par_bal,a.cur_tp_per_adb,a.cur_gross_rate,a.cur_net_par_bal,a.cur_payment,a.deferred_cur_bal,a.deferred_org_bal,a.interest_rate_code,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_code,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.pmt_adjust_date,a.pmt_chg_freq,a.pmt_chg_freq_mult,a.pmt_decr_cycle,a.pmt_decr_life,a.pmt_freq,a.pmt_freq_mult,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_code,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,a.reprice_freq,a.reprice_freq_mult,a.teaser_end_date,a.t_rate_int_rate_code,a.last_payment_date,a.int_type_code,a.adjustable_type_code,a.lrd_balance,a.instrument_type_code,a.compound_basis_code,a.currency_code,a.org_book_bal,a.org_market_value,a.market_value from FEM_CHECKING_V a where a.CURRENCY_CODE=:CURRENCY_CODE and a.LINE_ITEM_ID=:LINE_ITEM_ID and ((((
APP-FEM-416622: Bound SQL Parameters:
:CURRENCY_CODE = 'CHF'
:LINE_ITEM_ID = 35700

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