Top 20 Oracle Inventory Interview Questions You Must Prepare 20.Jul.2024

Q1. What Are The Prerequisite Set Ups For Inter Organization Traction?


Define an inventory item that is common to both organizations. Define at least two organizations, one of which is valid to receive material from the other. Set up inter–organization relationships and their corresponding accounts. Like Shipping Network.  For direct trfers, if the item to trfer is under serial number control, the item must have the same unit of measure in each organization. 

Q2. What Are The Flex Fields In Inventory?

  • System Item
  • Item Catalog
  • Item Categories
  • Stock Locator
  • Account Aliases

Q3. Which Are Required Steps In Inventory Module Set Up?

  1. All the 6 key flex fields i.e. Items, Item Catalog, Account Alias, Sales Order, Locator and Item Category 
  2. Organizations
  3. Change Organizations
  4. Intercompany Relations
  5. Unit of Measure Classes
  6. Sub inventories
  7. Item Attribute Controls, Categories
  8. Default Category set
  9. Item Statuses
  10. Cost types
  11. Profile Options
  12. Inventory Accounting Periods

Q4. What Is A Traction Action?

A traction action is a predefined method of changing the quantity and/or location and/or cost of an item. It is used in Traction Type form.

Q5. Where To Define Inter Organization Traction Charges And What Are The Different Options?

Depending on the inter–organization trfer charge that applies between the organizations, a percentage of the traction value or a discrete amount that Oracle Inventory uses to compute trfer charges.

Q6. Can You Do Inventory Tractions In Prior Periods?

Yes, you can do by setting the profile option INV: Traction Date validation to Provide warning when date in past period or Allow date in any open period. It allows entry of a past date.

Q7. What Is Item Status? Name The Related Table?

INVENTORY_ITEM_STATUS_CODE is the Colum in table MTL_ITEM_STATUS will tell you the different status for item while you defining the item in item master form (INVIDITM). You can have different status as shown in below, also u can define your own custom status in status code form in item setups (INV DOIS)like “easyapps”.

Active, Inactive, Engineer, Obsolete, Phase-Out, Prototype, OPM, Lease, Production, Concept, Design, DEM_Status, Pending.

Q8. What Is Item Master Organization?

An item master organization is a logical entity that you use to define items. After you define an item in the item master, you can assign it to any number of other organizations. You should also define one item master organization per implementation. When you define an item, Oracle automatically changes your current organization to the master organization.

Q9. Can You Apply Material Overheads To Average Costing Organization?

No, you can not apply it to Average Costing Organization. However you can apply it to Standard Costing Organization.

Q10. What Is An Inventory Organization?

Inventory Organization is a facility where you store and tract items. It can be a manufacturing unit, warehouse, distribution centre, item master organization (logical entity), etc.

Q11. Which Is The Table For Storing Organization Information?


Q12. What Does Inventory Interface Do?

Inventory Interface Program populates the interface tables with tractions submitted through Confirm shipment forms. It updates order lines with shipped quantities and updates inventory.

Q13. Different Type Of Inventory Planning?

There are 4 inventory Planning methods as mentioned below:

  1. Min-max planning
  2. Re-order point planning
  3. Kanban planning 
  4. Periodic Automatic Replenishment(PAR)

Q14. What Is The Difference Between Organization_id And Org_id?

Org Id is a unique ID for the Operating Unit. Organization Id: The Organization Id is an ID for the Inventory Organization which is under an Operating Unit.

Q15. In Which Table Sub Inventory Related Information For Item Is Stored?


Q16. What Is The Difference Between Category And Category Set?

Categories and Category Sets can be used to group the items for various reports and programs.

A category is a logical classification of items that have similar characteristics. A category set is a distinct grouping scheme and consists of categories.

Q17. Can You Change Customer Item Name Or Item After You Save It?

Yes, you can change it if you have set the profile option INV: Updatable Customer Item to Yes and INV: Updatable item to Yes respectively.

Q18. What Is The Use Of Item Templates?

There are two types of templates:

Predefined and Custom Template.

Predefined templates are planning item, purchased, outside processing item, lease item. So that once you assign any template, to new item then all default characters are assign to new item.

Q19. Define The Difference Between Cycle Counting And Physical Inventory?

  1. Cycle counting is the periodic counting of individual items throughout the course of the year to ensure the accuracy of item. Physical Inv. counts the entire inventory once a year Physical Inv. takes a snapshot of inv.'s on-hand quantity at the beginning of the process. All adjustments are made against snapshot quantity.
  2. In cycle counting fewer items are counted each day so less disruption to normal production or distribution In PI all items are counted once a year so a lot of disruption.

Q20. Explain Uom And Uom Class?

Unit of measure classes represent groups of units of measure with similar characteristics. For example, quantity is a unit of measure class and each, dozen, and gross are examples of units of measure within the class.