Easy to do
A reader, October 21, 2009 - 6:09 am UTC
Create your control file (e.g. my_control.ctl) and put it in the appropriate directory on the application server (if I recollect correctly it should be in $<module>_TOP/bin, but you should be able to figure that out from the documentation). Then create a concurrent program executable of type 'Sqlloader' and enter 'my_control' as execution file name. Then define a concurrent program using this executable.
There should be some examples out on the internet if you want to pass the datafile as a parameter.
How to use the SQL*Loader in Oracle Apps", version 18.104.22.168
Sugam Ghosh, December 01, 2009 - 7:00 am UTC
am somewhat confused vid the second one, is it applicable when we don't have a previledge to run sqlldr from client machine.. please advice.
coz it is following the same way of registering a concurrent program what we use to call from apps end to perform any job.
SQL Loader or Dataload Pro for R12 E-Business Suite bulk loads
Stuart King, March 05, 2010 - 7:46 am UTC
We require to run many bulk loads into E-Business modules.
I have read a bit about Dataload Pro and seen a few testimonials. Everyone seems to sing its praises.
This is a pre-production build, but will go live in the next few months and we are pondering over whether we should productionise this tool for E-Business suite or not?
However, can SQL Loader be used to the same effect.
Our current standard method for data loading into Oracle is SQL Loader.
Does it have limitations in that its just not an effective tool with E-Business quite in mind?
Any advice appreciated.
March 05, 2010 - 11:33 am UTC
I have no experience, no even knowledge really, of this tool. sorry.
A reader, April 12, 2010 - 1:17 am UTC
Hi Please could some one explain the steps from the starting to the Ending
April 13, 2010 - 9:10 am UTC
Greg, April 13, 2010 - 1:18 pm UTC
Now *THAT* is funny!!!! Thanks for a laugh on a too busy day
We missed you, Tom
Adam, April 13, 2010 - 2:56 pm UTC
I get the feeling that Tom's sense of humor was restored after a week away from "Ask Tom". Honestly, I don't know how he maintains his patience most days.
April 14, 2010 - 8:04 am UTC
A week away was a week in South Africa - after one of the longest flights ever, three days in a row of 5 hour seminar followed by customer visits ;) good to be back home for a week....
Greg - Apps dba, April 14, 2010 - 12:37 pm UTC
A friend of mine was flying from Durban SA to NY, a very long flight. He as a smoker and was at the back of the plane in the smoking section. He was had the aisle seat and a small man who did not speak English was sitting next to him. He spent the entire flight sleeping on my friend's shoulder but would periodically wake up and smoke his cigarettes! He didn't ask or gesture, just took them...
At least he got a good story out of it.
As far as loading information into the database, we use a concurrent job and treat the csv files as external tables. They just get put out there in a generic file.
Intercompany Transaction flow between two OUs
A reader, December 06, 2012 - 12:54 am UTC
Intercompany Transaction flow between two OUs, Could some one explain the same clearly interms of functional as wll as technical.
December 14, 2012 - 2:01 pm UTC
what the heck is an "OU"
I hear Oracle University in my head when I hear OU. But I'm pretty sure that isn't what you meant.
and what do you mean by "intercompany transaction flow" - that sounds like a fancy term, but I don't really know what you mean by it - big old buzz word.