Oracle Distribution Functional Interview Questions - 3 years of experience

1. Explain Order to Cash process? And Procure to Pay cycle?

2. What is the use of Differ interface check box in Ship confirm?

3. The item attribute ‘Reservable’ is No - what is the impact?

4. Even though Item attributes are correctly set and item is assigned to OE Item validation organization still the item in not available while creating SO. What is the cause?

5. Can one ‘operating unit’ user see the sales order of other operating? How can we achieve this?

6. Where do you define Set of Books? Where can you assign set of books?

7. What are the attributes we need to define for BOM to raise configuration sales order?

8. Auto pick confirm whether required or not where is that set-up done?

• Other than OM System parameters where else?

9. If any delivery grouping attributes in a sales order lines are different then what is the impact during pick release in shipping transaction form

• What changes you observe?

10. If user wants to ship the lines in single delivery when there are different delivery id created for a Sales order, then what process has to be followed

11. What is the difference between Drop ship and back to back order?

12. How do you define an expense item?

13. What are the dependent activities for receiving expense item? What is the accounting? And how is it generated?

14. Is there a way to update schedule ship date for all lines of SO in one go?

15. What is the functionality of Ship set?

16. What are the ‘status control’ attributes of an Item? Explain one attribute in detail.

17. What are the different inventory controls for an item?

18. What are the pre-requisites for Pick release to be successful?

19. Navigation to change the serial numbers from Shipping Transaction form.

20. What are the Item attributes in the ‘Main’ tab.

21. What is meant by Primary UOM and Secondary UOM? Can we change UOM at SO level? If yes, what are the pre-requisites?

22. Explain PO Approval Hierarchy. If owner wants to self approve then what the set-ups required?

23. Do you have knowledge of Inter-Company Invoicing? If yes, explain the process.

24. How many types of Excise Bond registers are there in your current project?

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

26. What are the different types of excise exemptions?

27. Once the SO was booked, the line status changed to ‘Closed. What could be the cause?

28. In India Localization how are generating Excise and VAT Invoice number both shippable and non-shippable Sales Orders/Transactions.

29. After Ship confirm, what programs are submitted by system. What accounting entries/transactions are created?

30. How many KFF are there in Order management? What is the use of Sales Order Flex-Field?

31. What is the link between Inventory and Order Management?

32. What are the various statuses of Sales Order Line? What the corresponding statuses in Shipping Transaction form? Do sales order header also have all those statuses?

33. When does Sales order header get closed?

34. Have you handled SR and worked with Oracle for resolution of issues? If yes, how do you assign the priority while raising a SR?

35. What is the issue of VAT calculation mentioned in your resume?

36. Are you involved in Month-end closing? If yes, what are the challenges you faced? What could be reasons for an inventory period not getting closed?

37. Do you have any idea of Cycle Counting and Physical Inventory?

38. What is the WIP process – from SO to Shipment?

39. What are the three C’s in 11i? What are the changes in SOB’s in R12? What is the 4th C in R12?

40. Have you done Inventory organization set-up?

41. Explain the IRISO (Stock-Transfer) set-up?

42. What is receipt routing? How many types of receipt routing are there? What is the accounting in ‘Standard Receipt’ routing?

43. What are the different types of RG Registers?

44. Where the option to determine whether to use – Approval Position Hierarchy/ Employee-Supervisor Hierarchy?

45. What are profile options? Explain at what levels profile options can be set?

46. What do you meant by modifiers? How do you define modifiers?

47. Have you worked on Advanced Pricing?