in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?
KPMG,
1 7775in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
1 8774what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
IBM,
1 5118A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
1 6784There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
3 9448Post New Oracle Apps Technical Questions
What is instead of trigger in where we will use?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What are the different components you should consider while defining a responsibility in oracle apps?
What do you understand by concurrent programs?
What are the benefits of using soa architecture?
Are you familiar with internet architecture of oracle apps 11i?
Plz anybody send me Technical specification for AP Interface
How can we import the data into a database using sql * loader?
In support project one ticket alloted which steps follows manualy tell me ?
What is oracle soa suite and what are its different components?
How to create a purchase order without a requisition?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is count(*) from po_vendors(any table)?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP