| SQL* Loader in Oracle Apps [message #123471] |
Mon, 13 June 2005 12:07  |
mhkraju
Messages: 14
Registered: April 2005
Location: Hyderabad
|
Junior Member |
|
|
hi,
how to add records into two tables at a time by using sql*loader in apps....................
where can we find more documentation about how to use sql*loader in apps.....................
thanks in advance........
|
|
|
|
| Re: SQL* Loader in Oracle Apps [message #123486 is a reply to message #123471] |
Mon, 13 June 2005 13:11  |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
For information specific to using SQL*Loader in the Orace E-Business Suite (EBS) refer to the section named "SQL*Loader" in Chapter 17 "Coding Oracle Tools Concurrent Programs" in the "Oracle Applications Developer's Guide". This manual is available from the EBS documentation CD available for download from Top Tech Docs on Metalink.
For more general information about SQL*Loader, such as how to load data into two separate tables refer to Part II "SQL*Loader" in the "Utilities" manuals available online and for download on OTN.
I guess you are trying to load some data into an interface. (The Payables Open Interface? -- there being two tables...) Depending on the quality and form of the data you get from your source system, it might be worthwile to create a staging table for doing custom validation, enrichment and transformation of the data.
There is an alternative to SQL*Loader called external tables, which you might find somewhat easier to work with. Basically you can treat flat files as tables from which you can perform for instance SELECT-statements. It is at least worth a look.
--
Aleksander Dragnes
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
