SQL*Loader-704: Internal Error Error When Performing OFSAAI F2T Upload

(Doc ID 1357386.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Data Integrator
File to Table (F2T)

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), when attempting to execute a F2T upload, the following error occurs.

ERROR
"SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve the connect identifier specified".

The Error does not occur if executed locally i.e. sqlldr pftuser/password@OFSAAPFT (infodom entry in tnsnames.ora).

The issue can be reproduced at will with the following steps:
1. Launch F2T upload via ICC batch.

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