Home » Applications » Oracle Fusion Apps & E-Business Suite » Concurrent Program using SQL * Loader
Concurrent Program using SQL * Loader [message #318319] Tue, 06 May 2008 08:45 Go to next message
abbas9001
Messages: 20
Registered: April 2008
Location: Hyderabad
Junior Member
Hi All,

I am using SQL * loader as an option to develop the concurrent program
I am running a concurrent program and getting the following error


SQL*Loader-500: Unable to open file (d:\oracle\visappl\po\11.5.0\bin\item.ctl)
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Can anyone tell me how to overcome this error.


Regards,
Abbas.
Re: Concurrent Program using SQL * Loader [message #318398 is a reply to message #318319] Tue, 06 May 2008 14:54 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
The system cannot find the file specified

Well, I'd make sure that 'item.ctl' file really is in 'd:\oracle\visappl\po\11.5.0\bin\' directory (and, possibly, that I have privilege to read (write?) in this directory).
Re: Concurrent Program using SQL * Loader [message #318773 is a reply to message #318398] Wed, 07 May 2008 23:06 Go to previous messageGo to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi Abbas,
Did you get the solution,then pleas update us.
Thanks,
Kittu.
Re: Concurrent Program using SQL * Loader [message #318917 is a reply to message #318773] Thu, 08 May 2008 07:51 Go to previous messageGo to next message
srinivasu_vasamsetti
Messages: 5
Registered: July 2006
Location: hyderabad
Junior Member

Hi,

Paste the file in c:\ drive and check whether it is working fine or not. i will work on c:\ drive only.dont try in d:\ drive after testing let me know for the alternative solution.

Regards,
Srinivasu.
Re: Concurrent Program using SQL * Loader [message #318995 is a reply to message #318917] Thu, 08 May 2008 11:47 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, I'm using SQL*Loader with files (data, control, log, bad, discard) on disk M so - what exactly do you mean by saying
Quote:
work on c:\ drive only.dont try in d:\ drive
Re: Concurrent Program using SQL * Loader [message #322296 is a reply to message #318995] Fri, 23 May 2008 00:59 Go to previous messageGo to next message
srinivasu_vasamsetti
Messages: 5
Registered: July 2006
Location: hyderabad
Junior Member

Hi,

Whatever file you want to import that file should be in c drive not in other drives.

Ex: c;\>example.xxx like this

please try and let me know.

Regards,
Srinivasu
Re: Concurrent Program using SQL * Loader [message #322349 is a reply to message #322296] Fri, 23 May 2008 03:32 Go to previous message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
Whatever file you want to import that file should be in c drive not in other drives.

That's just plain wrong.
Previous Topic: unable to check checkbox 'Make tax available for Transaction'
Next Topic: Loading data
Goto Forum:
  


Current Time: Wed Jul 03 13:32:39 CDT 2024