Saturday, September 3, 2016

Oracle Inventory Interview Questions

01. Which are required steps in Inventory module set up?
02. What is the item relationship and item cross relationship? What is the purpose of it?
03. Where the penalty for delay in supply to the Supplier is setup?
04. How many item master organizations can be created in Multi org structure?
05. What are the steps required for setting min-max planning?
06. How do you define a expense Sub-Inventory
07. What is the difference between lot control and serial control?
08. What is the difference between min-max planning and reorder point?
09. What is the purpose of item master organizations? Can we define more than one item master?
10. What do you mean by Required with Defaults Steps?
11. Which are Required with Defaults Steps in Inventory module?
12. There is no stock locator control in your Inventory organization. Do you still need to configure it?
13. What is the use of a picking rule?
14. Can you apply material overheads to Average Costing Organization?
15. What is a Transaction Action?
16. How many Predefined Transaction Actions are available in Inventory module?
17. Can you do Inventory transactions in prior periods?
18. Can you change customer item name or Item after you save it?
19. Move Order can be created through multiple sources, name them.
20. What is Move Order Time Out
21. Which are different Inventory Planning methods?
22. What is a Category Set?
23. What is an Item Category?
24. What is a Subinventory?
25. What is a Workday Calendar?
26. What is a Stock Locator?
27. In R12 How many key attributes and other attributes are there?
28. What is the difference between expense item and inventory item
29. What is the difference between item category and item catalog
30. What is the manufacturing part number?
31. At the time of PO receipt, how to change destination (One Inventory to Another Inventory) type?
32. What is the difference between Standard and Average Costing
33. How do you differentiate Purchase Price Variance and Invoice Price Variance
34. What are the diff types of calendar in R12? Please explain their feature?
35. What is the different between 11i and R12 in oracle?
36. What is the difference between cycle counting and physical inventory?
37. What is the difference between org_id and organization_id?
38. What is a Pick Slip Report?
39. Name the key flex fields in Oracle R12 Inventory?
40. In a Multi-Org at which level PUR/INV/OM are defined
41. If the business entity has 5 Operating Units, How many times do you have to implement Apps?
42. I have around 10 orgs in our instance. How can I restrict organizations access to users. Out of 10 one has to access /can see only 4
43. What is the difference between org_id and organization_id?
44. What is Inventory Organization?
45. What is Ledger in R12? How is it different from 11i
46. In which setup you control the costing method?
47. Mention the navigational steps for ABC analysis.
48. Which of these is mandatory A.Subinventory B.Locators.?
49. Can you copy inventory org structure?
50. What is Shipping network?
51. Difference between UOM and UOM class?
52. What is the purpose of standard cost update?
53. How to get the on hand quantity of an item across all organizations?
54. How can you define/create custom item attributes
55. Name the status attributes
56. How Item types are defined?
57. Explain the use of cross-references?
58. What are the prerequisites for costing transactions?
59. How do you assign items to item categories?
60. How do you load /import items?
61. Explain the use of Item revisions?
62. How do you search items?
63. How do you delete an item?
64. What are deletion constraints?
65. Can we have custom deletion constraints?
66. How do you generate serial numbers?
67. Can serial numbers and lot numbers co-exist for an item?
68. Where do you enable or disable serial / lot number capabilities for an item?
69. What are material status and the use of material status?
70. List some of the seeded material transaction types?
71. What are transaction sources?
72. Can we have custom transaction sources types?
73. What are the benefits of account aliases?
74. What is the difference between sub-inventory transfer and move order?
75. Can move orders support inter-org transfer?
76. What is a miscellaneous transaction?
77. Explain the use of shortage notifications
78. Where do you define shortage notifications
79. How do you perform Inter-org transfer?
80. Is Sales Order mandatory in inter-org transfer?
81. Explain the difference between direct transfer and in-transit transfer?
82. Can we import material transactions through API?
83. What is vendor managed Inventory (VMI)?
84. What is consigned Inventory?
85. Explain the life cycle of move orders?
86. Different ways to create move orders?
87. What forecasting methods oracle inventory supports?
88. When do you generate forecast automatically and when do you setup manually?
89. What are the prerequisites for costing transactions?
90. What are the required ROP Setups
91. Name at least five reports in oracle inventory related to transaction?
92. What is safety stock?
93. How safety stock is calculated?
94. Explain replenishment counting?
95. What is the purpose of ABC analysis?
96. Steps involved in Cycle Counting process?
97. Steps involved in Physical Inventory process?
98. Is UOM maintained at master level or organization level or both?
99. How do you assign expense Item to Expense Sub-inventory?
100. Which is the default Cost Type in Item Cost?
101. Once an item is assigned to an organization, is it possible to remove this association at a later time?
102. How do you setup Unit of Measure for an item?
103. How do I change an item’s locator control method once I have transacted against it, for example from No Control to Pre-specified?
104. How do I change an item’s Unit of Measure?
105. How do I delete an Item Template I no longer use?
106. Differentiate between intra & inter UOM class conversion with examples.
107. Why does the application prompt you for Organization when you enter the Master Item form for the very first time even though you have only one Master Organization.
108. How do you change the control level for item attributes from master level to organization level for example. When I try to change this in the Attribute Control Form, I get the message: frm-40200: field protected against update.
109. How do I inactivate an item?
110. What characters can I use in an item name (including special characters)?
111. Can you change the costing enabled and inventory asset flags on an item that has already been transacted against even if there is no on-hand quantities for the item?
112. When I create a new item, and choose to assign to All orgs, the application allows me to even though some of those organizations are restricted to my responsibility. Is this the way it is supposed to work? If I assign in an Organization by Organization fashion, I am not allowed to assign to the restricted organizations.
113. How do you tell that an item is an expense item or asset item?
114. Is there a way to delete or disable an item revision once entered?
115. What are centralized and decentralized level of control of item attributes?
116. Define steps of assigning items to an organization.
117. What is unit of measure classes? Give at least two examples.
118. What are stock locators and how to define them?
119. Where to define inter-organization transaction charges and what are the different options?
120. What is unit of measure classes? Give at least two examples.

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect