Are there any alternate tools other than sql* loader to
load data into oracle apps tables from external systems
- 5 Answers
- 18630 Views
- Deloitte, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raam
Apart from sql*loader you can use UTL_FILE package to
upload the data from external systems to oracle tables.
| Is This Answer Correct ? | 21 Yes | 3 No |
Answer / amit trivedi
If you are on 9i and above you may use External Tables as
well. Though this feature has some limitations as to type
of delimiters that can be used.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / viswa
data loder,
utl_file,
with dba link(data should be in table),
pro*c,
style sheet convertion,
ora loader(tool)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sachind
Apart from SQL Loader, web-adi can be used.Data Load is
another one but its windows specific.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kks
You can use data pump (IMPDP) connect to external DB via DB
link and load the data.
| Is This Answer Correct ? | 1 Yes | 0 No |
where the accounting related data is stored ?
how will you refer a report column (data column,formula,summery,placeholderr)?
Is SOB is attached with Business grp ?
how do you describe O2C along with tables
what is difference between d2k report and oracle apps report
What are the validations you don in .CTL file in inbound interface process?
What is the difference between base table and multi-org table?
what is pl/sql table and pl/sql records? what is the use of that?
Presently u are working in which version?
What is MO operating units. Why it need to to set this and where .
what is the difference between request group and request security in oracle apps?
how can we get odd numbered pages in output of a report
Oracle Apps Technical 
