My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2021

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


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

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
Changes
Cause
Solution
References


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