Are there any alternate tools other than sql* loader to
load data into oracle apps tables from external systems
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 |
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
what is latest version in reports
What multi org tables . example - difference between app table non all table . Po_header and po_headers_all
What is request group
what is meant by anchoring?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
Can you have two stored functions with in the same name?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
What is Value Set?
how to create requst set in oracle apps and how to send muliple requests at a time,
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?