My Oracle Support Banner

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)
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


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