Oracle Apps Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle Apps AllOther (114)

Oracle Apps Interview Questions

Questions Answers Views Company eMail

why we can use synonym?

6 16739

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 14835

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 7252

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 9688

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 7418

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2112

can we use commit in trigger? If yes how?

Cap Gemini, TCS,

2 18589

what are the balancing segments in AR?

2103

what are the different transaction clauses in AR?

BirlaSoft,

2122

what is flexfield qualifier?

3 8223

what are the match approvals in PO?

3 7688

If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?

4 15174

what is the database size you used?

FIS,

1 6702

what is trace file? what is the use of that?

4 8557

what is the difference between oracle 8i and 9i?

1 5275

Un-Answered Questions { Oracle Apps }

how can i print random rows in plsql table

2507

What are the various levels where you can Set up Payroll Costing Accounts? Which levels take the highest precedence?

1068

What are cycles of ar?

875

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2619

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?

14971

What are the accounting behind consigned inventory in P2P?

1412

What is gap analysis, what are the pre-requisities?

1249

Can any one list out frequently raised issues by core hr and payroll endusers to support consultant?

4682

how to find the instance for null-control item?

2177

Differentiate between jobs and positions in oracle hrms.

1067

Explain the reports available with oracle hrms.

1016

Explain the types of user exits?

837

Explain how your project map with service contract module?

1395

How to stop the evergreen renewal contracts types?

1574

What is the use of LC? How is it useful in export sales?

2300

For More Un-Answered { Oracle Apps } Questions Click Here