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 laterInformation 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 <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.
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 |