My Oracle Support Banner

FTP Process Failed With ORA-01747 Referencing “a.” in Select Statement Instead of "a.avg_net_book_bal_c" (Doc ID 2688110.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

When running Funds Transfer Pricing (FTP) standard process, failures occur due to what appears to be the avg_net_book_bal_c column missing in the generated SQL. The column is represented as just "a.". It should be a.avg_net_book_bal_c.

Error:
ORA- 01747: invalid user.table.column, table.column,
or column specification Driver Function: drv_oci::Execute() SQL

select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
a.PRODUCT_ID, a.LEGAL_ENTITY_ID, a.CUSTOMER_ID, a.id_number,
a.identity_code, a.instrument_type_cd, 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.MATCHED_SPREAD_C, a.HOLIDAY_ROLLING_CONVENTION_CD,
a.HOLIDAY_CALENDAR_CODE, a.HOLIDAY_CALC_OPTION_CD,
a.TRANSFER_RATE, a.charge_credit_trate, a.accrual_basis_cd,
a.cur_tp_per_adb, a.interest_rate_cd, a.last_reprice_date,
a.margin, a.maturity_date, a.next_reprice_date,
a.origination_date, 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_floor_life, a.reprice_freq, a.reprice_freq_mult,
a.teaser_end_date, a.tp_average_life, a.tp_duration, a.tp_effective_date
from FSI_D_TERM_DEPOSITS a
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.PRODUCT_ID = :PRODUCT_ID
and a.ORG_UNIT_ID = :ORG_UNIT_ID
and as_of_date = to_date('06/ 30/ 2020', 'mm/ dd/ yyyy')
and LEGAL_ENTITY_ID = - 1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.