Interview Questions

Below are the sample questions for the interview. Please go through them while preparing for interview. 

•        difference between 11i and R12 in general

•        difference between process_order API parameters between 11i and R12

•        how to import high volume of orders into Oracle

•        shipping tables and their joins

•        what are versioned components in Oracle Workflow and workflow customizations I have worked upon

•        sequence of event execution in Oracle forms, custom.pll and forms personalization

•        what are business events and how their architecture works

•        what are pragma autonomous transactions

•        difference between pragma exceptions and normal exceptions

•        benefits of bulk collect and how it improves performance 

•        how to improve performance of a concurrent program

•        Questions was mainly focused on Order management, shipping and inventory.

•        For example what are the differences between 11 and r12.

•        Order to Cash flow.

•        what tables are updated.

•        Process in customizing work flows ?

•        what is VPD?

•        Major concentration is how well you know OM in general.

Please find the Questions

1. A conc program is running for more time than usual. What approach you follow to debug and how can you face the customer

2. Order to cash flow

3. Shipping tables and their joins and its time of populating data 

4. Delivery assignment table use

5. Release statues

6. How to know whether order is pick relerased

7. Can we use commit in a trigger

8. What is the other way to commit in trigger

9. How can you approach that

10. What is difference between form personalization and custom.pll

11. What are limitations of using custom .pll

12. What is difference between 11i tables and r12 tables

13 How to set multi org structure

14. What is the difference of multi org in 11i and r12

15 How to approach 1millon of data to process in 10 min What approach you follow

16. What is bulk bind

17. How will be the performance affects if we use indexes and triggers

18. How many ways we can create the index

19. How can we use parallel hints

20. What table changes will happen while the order line gets back order

21. What are Defaulting rules

22. Process constraints

23. Defaulting rule comes under which module

24. can we cancel a order at pick confirmed order

25. How Can we cancel a order

26. Can we get the order number in wsh_delivery_details

27. What are the column joins available in wsh_delivery_details and oe_order_headers and oe_order_lines