Monday, January 19, 2015

2015 Latest Interview Questions - Oracle Apps Technical


SQL & PL/SQL
------------------

1. What is difference between snapshot and materialized view.
2. What is the Use of cascading triggers?
3. In which scenario's pragma autonomous transaction is used and the syntax and flow?
4. Explain about Bulk collect and for all.
5. What are the different types of collections and use of varray.
6. Database Trigger syntax
7. What is the use of external table and syntax?
8. Use of global temporary table and difference between the temporary table, global temporary table.
9. What are the new concepts in 11G?
10.Query to displayed the locked sessions?
11. Difference between subquery and co-related subquery?
12. What is meant by nested table?
13. Performance tuning steps?
14. Qualifiers, modifiers in price list?
15. Difference between truncate and delete
16. Difference between union and union all



XML Publisher Reports:
--------------------------------
1. What are the steps to develop multilingual report with the use of XLIF?
2. XML Bursting?
3. What are the different ways to develop the multilingual reports?
4 .How to validate the parameters while using data template .XML?
5. How to use the fillers and watermarks in check printing.
6. Use of lexical parameter and syntax.
7. How to pass the one data query value to another data query value?
8. How to develop multi template reports based on conditions?
9. What are the ways to send xml publisher report as an email.?
10. What are the steps to develop a new xml publisher report using .RDF and .XML?
11. How to show no data found message when the query is not retrieving any data?
12. How to send ccp output as an email using ccp delivery options?
13. RDF report VS XML publisher report performance comparision?
14.What is the short name of executable in XML publisher reports?
15. Is short name of ccp and data definitions short code should be same?
16. How to generate ouputs in multiple formats based on the parameters like excel yes or no (text)? if parameters excel is set to yes, it should show the ouput in excel , otherwise it should show in pdf.

17. Navigation for XML publisher fonts?
18. How to display images in the report from a specific location based on validaton?
19. How to show MICR Font in check printing?


Oracle Forms:
------------------------
1. What are the steps to create a new oracle apps form?
2. How to call another form within the current form and how to open another form as a new form ?
3. Trigger firing sequence?
4. Use of AGRCUS.pll?
5. How to compile the form in 11i and R12?
6. How to migrate the form to another instance?
7. How to open a custom form using tools-->menu option?
8. How to customize form using custom.pll  ?
9. Custom.pll compilation syntax?
10.Why oracle forms are still used in R12? eventhogh we have the OAF and ADF pages?
11. Form personalization migration steps?
12. How to trigger a ccp in a form?


Oracle Apps:
-------------------------------
1. Order to cash cycle and procure to pay cycle
2. MOAC architecture?
3. R12 features ?
4. What are major changes in R12 in OPM  ?
5. Credit memo?
6. After booking a sales order (10 lines) , items are available for only 5 lines, what will happen? what the status of each line?
7. Use of ap_invoice_lines in R12?
8. How to update an item after creating the sales order in R12?
9. How to Show operating units in the concurrent program submittion window based on the user ?
10. Profiles used for MOAC?
11. 4c's in R12?
12. What is the subledgers in R12?
13. What are the workflows fired while creating a sales order?
14. 3way match process?
15. TCA architecture?
16. Customer conversion, item comversion,sales order conversion
17. AR invoice interface, vendor interface
18. What are the validation used while  converting customers?
19. API used in customer conversion?
20. Use of g_misc api while creating the sales order?
21. Link between sales order and AR invoice?
22. How to generate a receipt for an AR invoice?
23. What is the difference beween journal transfer and journal posting?
24. Auto Invoice master program use?
25. Blanket purchase and blanket release?
26. different types of purchase orders?
27. How to get the ingredients used for an item?
28. ic_tran_prod is replaced by which table in R12?
29. tables used in sales agreement?
30. what is the use of incentive compensation?
31. Navigation for viewing the sales order status?



Workflow:
-------------------
1. What are the steps to create new workflow?
2. What is the table for workflow processes?
3. How to push a workflow ?
4. How to migrate the workflow to another instance?
5. Different tables used in workflow?
6. How to call a workflow from a package?
7. What is the use of item key?
8. What are the mandatory processes in the workflow creation?
9. How to customize an existing workflow?
10. While applying a patch, will workflow customization will be removed?
11. Difference between workflow notification, and oracle alerts?
12. What are the workflow's triggered while creating  a sales order  and purchase orders?