Inventory Controls
Any combination of the four controls can be implemented for each item. Inventory controls are optional for all items
Ø Locator
Ø Revision
Ø Lot
Ø Serial Number
Stock Locator / Locator Control
Ø Locators are optional structures within sub inventories.
Ø Locators are the third level in the enterprise structuring scheme of Oracle Inventory.
Ø Locators may represent rows, aisles, or bins in warehouses. Items can be received directly into and shipped items directly from locators.
Ø You can structure your Oracle Inventory installation so some of the subinventories and items have locator control while others do not. If locator control is turned on at the item level, you must specify a locator when transacting the item into or out of a subinventory. If locator control is turned on at the subinventory level, you must specify a locator when transacting any item into or out of that subinventory. Each stock locator you define must belong to a subinventory, and each subinventory can have multiple stock locators. The possible locator control types are:
o None
o Pre-specified
o Dynamic entry
o Item Level
Explaining Locator Control Reports
Locator Quantities Report
You use the Locator Quantities Report to identify items and their quantities stored in the specified stock locators. If the stock locator has a zero on-hand quantity, then the locator is not included in the report.
Locator Listing Report
You use the Locator Listing Report to list stock locators you defined. You also use this report to review volume and weight allowed in a location before transacting items.
Revision Control
Ø A revision is a particular version of an item, bill of material, or routing.
Ø By using the ‘Revision control’ option while defining items item quantities can be tracked by item revision. To do so a revision is a must for each material transaction.
Ø Revision control is enabled for items for which version changes or changes that are significant enough to track but are not affecting the function and feature of the item are tracked.
Ø Revision Control item attributes cannot be changed when an item has quantity on hand.
Ø When defining Revision numbers letters, numbers and characters such as A, A1, 2B, etc can be used.
Ø Letters are always in upper case and numbers may include decimals.
Ø To ensure that revisions sort properly, decimals should always be followed by a number.
Ø Revisions are sorted according to ASCII rules.
Ø Each revision must be greater than the previous revision. For example, revision 10 cannot be used after revision 9 because, according to ASCII sorting, 10 precede 9.
Ø The value entered in the Starting Revision field in the Organization Parameters window displays as the starting revision for the item when assigning revisions to an item.
Lot Control
Ø Inventory provides complete lot number support for inventory transactions.
Ø A lot identifies a specific batch of an item that is received and stored in an organization.
Ø Lot control is a technique for enforcing the use of lot numbers during material transactions, thus enabling the tracking of batches of items throughout their movement in and out of inventory.
Ø If Lot Control is turned on for an item, the lot number must be indicated to perform a transaction.
Ø Lot Control must be turned on at the item level.
Ø Lot numbers must be assigned whenever items under lot control are received into inventory.
Ø An inventory receipt can be split in to several lots, as necessary.
Ø Quantities can be added to existing lot numbers.
Ø Inventory will generate default lot numbers by using the default lot number generation method which is configured in the Organization Parameters window during setup.
Explaining Lot Control Reports
Lot Transactions Register
You can use the Lot Transactions Register to report comprehensive lot number material transaction detail within a specific date range. You can run the report for a range of lots, items, transactions types, transaction reasons, and subinventories. You can also specify a specific category set and display transaction quantities in their primary or transacted unit of measure.
Supplier Lot Trace Report
You can use the Supplier Lot Trace Report to trace a specific lot to its supplier lots. You can run the report for a range of lot numbers and items and a specific supplier lot number. The report shows you the lot material transactions related to the selected items as, lot numbers, transaction dates, and transaction quantities.
Expired Lots Report
You can use the Expired Lots Report to show lots in your organization that expire on or before the date you specify. You can run the report for a range of items or for a specific item only.
Serial Control
Ø A serial number is an alphanumeric piece of information assigned to an individual unit of an item. A serialized unit is a combination of an item number and a serial number.
Ø Individual units of items can be tracked by using serial numbers. Serial number control is a system technique for enforcing the use of serial numbers during a material transaction. Serial numbers can be used to track items over which a very tight control is to be maintained.
Ø One serial number per unit of an item can be assigned
Ø Depending on how Serial Number Control is set at the Master Item level will determine how serial numbers are generated.
Ø If No Control is specified as the serial number control type, no serial number control will be enforced.
Ø If Predefined is specified as the serial number control type, serial numbers for that item must be predefined.
Ø If control ‘At inventory receipt’ or ‘At sales order issue’, optionally serial numbers for the item can be predefined.
Generating Serial Numbers
Ø Inventory uses the starting serial number prefix and the starting serial number specified in the Item screen.
Ø The process of generating serial numbers is done through a concurrent report. This does not assign numbers to units in inventory; it simply reserves serial numbers for an item, for later use.
Serial Genealogy
Ø Enables to view the composition and transaction history of a serial-controlled item through a graphical user interface.
Ø Includes all material transactions within an organization.
Ø Enables to trace serial numbers from an assembly to all components.
Ø Enables to trace serial numbers from a component to a final assembly.
Explaining Serial Number Control Reports
Serial Number Transactions Register
You can use the Serial Number Transactions Register to report comprehensive serial number material transaction detail within a specific date range. You can run the report for a range of serial numbers, items, transaction types, transaction reasons, and subinventories. You can also specify a specific category set and display transaction quantities in their primary or transacted unit of measure.
Serial Number Detail Report
You can use the Serial Number Detail Report to report on information about current serialized units in your organization for a specific source type or serialized unit status. Oracle Inventory enables you to run the report for a range of serial numbers, items, suppliers, and supplier serial numbers.
Oracle Apps Tutorials 