This discussion is archived
1 Reply Latest reply: Aug 22, 2013 1:34 AM by HrishikeshJ RSS

Oracle Inventory Stock Location in a Subinventory - Locators vs DFF

924745 Newbie
Currently Being Moderated

Has anyone covered the topic of options for recording the location of an item in a subinventory when the business has a clear rule that an item in a subinventory will only ever exist in one location?


The functionality in Oracle inventory for locators suggests it is for multiple stock locations in a subinventory.  Using it when applying the above business rule of only one locator per item per subinventory seems to require a lot of data maintenance and transaction data entry for the purposes of being able to identify which asile, row, shelve an item is located at.


Has anyone provided such a discussion before on the pros and cons of using locators when an item will only exist in one location within a subinventory vs the use of a DFF field on the item/subinventory record to be used for reporting and lookup purposes for location information?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points