Top 20 Oracle Inventory Interview Questions
Q1. What Are The Prerequisite Set Ups For Inter Organization Traction?
Prerequisites:
Define an inventory item that is common to each organizations. Define at least two organizations, one in every of that's legitimate to acquire fabric from the alternative. Set up inter–enterprise relationships and their corresponding accounts. Like Shipping Network. For direct trfers, if the item to trfer is beneath serial quantity manipulate, the item ought to have the identical unit of measure in every enterprise.
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?
All the 6 key flex fields i.E. Items, Item Catalog, Account Alias, Sales Order, Locator and Item Category
Organizations
Change Organizations
Intercompany Relations
Unit of Measure Classes
Sub inventories
Item Attribute Controls, Categories
Default Category set
Item Statuses
Cost sorts
Profile Options
Inventory Accounting Periods
Q4. What Is A Traction Action?
A traction movement is a predefined method of converting the quantity and/or area and/or price of an object. 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–business enterprise trfer rate that applies among the corporations, a percentage of the traction value or a discrete quantity that Oracle Inventory makes use of to compute trfer fees.
Q6. Can You Do Inventory Tractions In Prior Periods?
Yes, you may do by means of putting the profile choice INV: Traction Date validation to Provide warning whilst date in beyond duration or Allow date in any open length. It allows entry of a beyond date.
Q7. What Is Item Status? Name The Related Table?
INVENTORY_ITEM_STATUS_CODE is the Colum in desk MTL_ITEM_STATUS will tell you the extraordinary fame for item whilst you defining the object in item master form (INVIDITM). You could have distinct popularity as shown in under, additionally u can outline your personal custom popularity in popularity code form in object 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 grasp corporation is a logical entity that you use to outline items. After you outline an item in the item grasp, you could assign it to any wide variety of other agencies. You ought to also define one object master employer in keeping with implementation. When you outline an item, Oracle mechanically adjustments your cutting-edge organisation to the grasp organisation.
Q9. Can You Apply Material Overheads To Average Costing Organization?
No, you cannot use it on Average Costing Organization. However you could use it on Standard Costing Organization.
Q10. What Is An Inventory Organization?
Inventory Organization is a facility where you shop and tract gadgets. It can be a manufacturing unit, warehouse, distribution centre, object master organization (logical entity), etc.
Q11. Which Is The Table For Storing Organization Information?
Mtl_parameters
Q12. What Does Inventory Interface Do?
Inventory Interface Program populates the interface tables with tractions submitted through Confirm shipment forms. It updates order traces with shipped portions and updates stock.
Q13. Different Type Of Inventory Planning?
There are four inventory Planning strategies as referred to underneath:
Min-max planning
Re-order point making plans
Kanban planning
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 that is below an Operating Unit.
Q15. In Which Table Sub Inventory Related Information For Item Is Stored?
MTL_ITEM_SUB_INVENTORIES.
Q16. What Is The Difference Between Category And Category Set?
Categories and Category Sets may be used to group the items for various reports and packages.
A category is a logical class of objects which have similar characteristics. A category set is a awesome grouping scheme and includes classes.
Q17. Can You Change Customer Item Name Or Item After You Save It?
Yes, you can change it when you have set the profile choice INV: Updatable Customer Item to Yes and INV: Updatable item to Yes respectively.
Q18. What Is The Use Of Item Templates?
There are two sorts of templates:
Predefined and Custom Template.
Predefined templates are making plans object, bought, out of doors processing item, hire object. 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?
Cycle counting is the periodic counting of man or woman items in the course of the path of the 12 months to make certain the accuracy of object. Physical Inv. Counts the whole inventory as soon as a year Physical Inv. Takes a picture of inv.'s on-hand quantity at the start of the manner. All adjustments are made against picture amount.
In cycle counting fewer gadgets are counted every day so much less disruption to everyday production or distribution In PI all gadgets are counted as soon as a 12 months so numerous disruption.
Q20. Explain Uom And Uom Class?
Unit of degree lessons represent companies of units of measure with similar traits. For instance, amount is a unit of degree elegance and each, dozen, and gross are examples of gadgets of measure in the class.
 
   
    
 
  
  
  
  
  
 