SQL*Loader-704: Internal Error Error When Performing OFSAAI F2T Upload
(Doc ID 1357386.1)
Last updated on JULY 20, 2020
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 <user>/<password>@<infodom name> (infodom entry in tnsnames.ora).
The issue can be reproduced at will with the following steps:
1. Launch F2T upload via ICC batch.
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