Oracle Apps Technical Interview Questions
Questions Answers Views Company eMail

where we will put the control file ,where we will run sql star loader what is the cmd?

Cap Gemini, KPMG,

1 8011

how to move the one file from one instance to another instance?and ur scripts also?

KPMG,

1 7741

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 7516

in 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?

Oracle,

1 8358

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

Oracle, Schneider,

2 9193

how to print multi lay outs,muti currency,muti language in xml publisher

Deloitte, Oracle,

2 11595

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

IBM,

1 4803

what is instead of trigger in where u will use?

TCS,

2 7631

How to print multi currency,multi language in xml?

1 8932

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

Satyam,

1 6497

There 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.

Satyam,

3 8856

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

Satyam,

3 8948

Hi Experts How to Create a purchase order without a requisition ?

Amdocs, KPMG, Oracle,

6 13280

Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

16 25755

what is tuning in oracle apps technical

TCS,

3 12389


Post New Oracle Apps Technical Questions

Un-Answered Questions { Oracle Apps Technical }

what are the prerequisites for costing transactions?

2916


What are file in oracle.

2046


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.

2794


1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

14425


Do you know where we can check the status of po?

969


What are the different components you should consider while defining a responsibility in oracle apps?

879


What is a value set? List its various types.

885


how to print multi lay outs,muti currency,muti language in xml publisher

11595


How can a process be deployed in soa?

932


List the types of flexfield?

832


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?

894


what is the difference between request group and request security in oracle apps?

5505


testing tools?

2000


tell my any difficult situtation you solved in your experience in your company?

2119


What is count(*) from po_vendors(any table)?

861