ORA-01747 Invalid user.table.column, table.column Running FTP With Transfer Rate Propagation (Doc ID 1925861.1)

Last updated on JULY 21, 2023

Applies to:

Symptoms

When attempting to run Funds Transfer Pricing (FTP) 6.1 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) 

Changes

Cause

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