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 |
What are the requests groups?
Types of cursors?
In Per_all_people_f table what is the significance of '_f ' ?
i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.
1 Answers IBM, Sierra Atlantica,
whats the use of after parameter form and before report?
link between po and ap modules
Form development process?
explain p2p cycle? what are the tables used for this?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
in GL module specifing org_id or not?
Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?
what is the use of format trigger?a