ORA- 01747: invalid user.table.column, table.column Running FTP with Transfer Rate Propagation (Doc ID 1925861.1)

Last updated on SEPTEMBER 12, 2014

Applies to:

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

Symptoms

On : 6.1 version, Calculation Engine

When attempting to run Funds Transfer Pricing (FTP) process with Transfer Rate propagation the following error occurs in ofstp error log.

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:
update CUSTOM_FSI_D_COMMERCIAL a
set () = (select
from CUSTOM_FSI_D_COMMERCIAL_H old
where old.id_number = a.id_number
and old.as_of_date = to_date('06/ 30/ 2014', 'MM/ DD/ YYYY') )
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.COMMON_COA_ID = :COMMON_COA_ID
and (((a.MATCH_FUND_FLAG < 'Y'
or a.MATCH_FUND_FLAG > 'Y')))
and as_of_date = to_date('07/ 31/ 2014', 'mm/ dd/ yyyy')
and a.as_of_date = to_date('07/ 31/ 2014', 'MM/ DD/ YYYY')
and exists(select id_number
from CUSTOM_FSI_D_COMMERCIAL_H old
where old.id_number = a.id_number
and old.as_of_date = to_date('06/ 30/ 2014', 'MM/ DD/ YYYY') )
and not exists (select product_id
from FSI_M_TRANSFER_PRICE_RULE t
where t.product_id = a.COMMON_COA_ID
and t.transfer_price_sys_id = 202614.000000
and t.data_source_cd = 2)

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