Home » Applications » Oracle Fusion Apps & E-Business Suite » SQL Loader Problem
SQL Loader Problem [message #242355] Fri, 01 June 2007 11:50 Go to next message
Krishna_dev
Messages: 32
Registered: May 2007
Member
I have registered sql loader control file as a concurrent program within APPS.
I now want it to find the datafile I am trying to load which is on the unix server.
How do I specify the path to the datafile in APPS.
I also want the control file to load all the datafiles that are within that same folder on the Unix server if there is more than one file. All the files are of the same format.

Report message to a moderator

Re: SQL Loader Problem [message #242356 is a reply to message #242355] Fri, 01 June 2007 11:52 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
$APPL_TOP/dat/filename

or
give absolute path

Report message to a moderator

Re: SQL Loader Problem [message #242357 is a reply to message #242355] Fri, 01 June 2007 11:57 Go to previous messageGo to next message
Krishna_dev
Messages: 32
Registered: May 2007
Member
Do I specify that path name as a paramater when I register the control file, if so how do I do this.

Report message to a moderator

Re: SQL Loader Problem [message #242370 is a reply to message #242357] Fri, 01 June 2007 12:36 Go to previous message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
yes...you have to have parameter which gives filename and path.


and should be like normal parameter you define.....

Report message to a moderator

Previous Topic: Mutating error for FND_PROFILE_OPTION_VALUES
Next Topic: When we do a receipt against a PO i use a property Add To Receipt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 02:10:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.