SQL*Loader-704: Internal Error Error When Performing OFSAAI F2T Upload
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)
File to Table (F2T)
On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), when attempting to execute a F2T upload, the following error occurs.
"SQL*Loader-704: Internal error: ulconnect: OCIServerAttach 
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.
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