My Oracle Support Banner

FTP Batch Job With “No Slicing” Option Fail With ORA-01747 Error (Doc ID 2630953.1)

Last updated on FEBRUARY 10, 2020

Applies to:

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

Symptoms

In FTP 8.0.7, all FTP batch jobs with "No Slicing" option set fail with the following error in the process 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:
select a.FTP_COA_ID, a.iso_currency_cd, a.LCP_COA_ID,
a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.HFM_LCD_ID, a.
from ANZ_D_AU_POOL_SOURCE a
where a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and a.FTP_COA_ID = :FTP_COA_ID
and as_of_date = to_date('11/ 20/ 2019', 'mm/ dd/ yyyy')
group by a.FTP_COA_ID, a.iso_currency_cd, a.LCP_COA_ID,
  a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.HFM_LCD_ID, a.

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
References


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