| load data from external system to GL_interface [message #120367] |
Thu, 19 May 2005 05:20  |
jaikumar.apps
Messages: 3
Registered: May 2005
Location: chennai
|
Junior Member |
|
|
Hi
I am new to apps> I need to load data from external system to GL_interface and e-mail to the user the status of load.
What is the right way? Do I need to load to staging table and then put into gl_interface or just load it directly to Gl_interface?
Does anybody have a shell script for this type of process
(I am new to shell).
jai
|
|
|
|
| Re: load data from external system to GL_interface [message #121123 is a reply to message #120367] |
Thu, 26 May 2005 04:19  |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
Jai,
The traditional way would be to
- FTP a flat file to a place where the E-Business Suite database can read.
- Load the file into either a staging table or directly into GL_INTERFACE using SQL*Loader depending on whether you need to do any custom validation or enrichment of the data.
- Do custom data validation and enrichment if necessary.
- Run the import program.
- Set up the concurrent programs to email the user when finished.
But there are many possible varieties. Instead of FTP and SQL*Loader you might use a database link, the XML Gateway, the Business Event System or web services.
--
Aleksander Dragnes
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
