Oracle Inventory provides complete lot number support for inventory transactions. You can enable lot control for specific items in your inventory. For items under lot control, you assign lot numbers to each receipt into inventory and thereafter reference the same lots each time you perform material transactions. This allows you to have tight control over batches of items in your inventory.
Assigning Lot Numbers
You must assign lot numbers whenever you receive items under lot control into inventory. You can also add quantities to existing lot numbers and split an inventory receipt into several lots, as necessary. Inventory assists you in entering lot numbers by generating defaults using the default lot number generation method you chose in the Organization Parameters window. If the item you are receiving is also under User-defined expiration date Lot Expiration (shelf life) Control, you must specify the expiration date for the lot. See: Defining Organization Parameters, Inventory Attribute Group, and Receipts.
Maintaining Lot Number Information
You can use the Item Lots window to update the expiration date of lots for items under lot expiration (shelf-life) control. Inventory lets you view all lots you created in your current organization and the supplier lot information associated with them. See: Maintaining Item Lot Information.
Issuing Material from Inventory
When you issue items under lot control from inventory, you must specify a lot number for that item. You can specify more than one lot to cover the transaction quantity. If you attempt to transact an item to or from an expired lot, Inventory displays a warning message but does not prevent you from using the lot. See also: Overview of Material Control, Overview of Shop Floor Control, and Overview of Delivery-based Ship Confirm.
You can determine whether a lot has an expiration date by assigning a number of lot control shelf life days or by entering an lot expiration date. The expiration date controls the availability of the lot for transacting and planning purposes. An expired lot:
- is not considered as on-hand supply when performing min-max, reorder point or MRP planning calculations
- cannot be reserved for a date beyond the expiration date
- can be transacted and is included in on-hand quantities
- is included in all inquiries and reports, including inventory valuation reports
- is included in a cycle count and count entry and adjustments are allowed
- is included in a physical inventory and tag entry and adjustments are allowed
Disabling a lot only prevents it from appearing in a list of values when performing receipt transactions. If you type in the lot number it is valid and acccepted even though it was not in the list of values. Disabling is used only for tailoring this specific instance of the list of values for lot numbers. A disabled lot:
- is included in available to transact, available to promise, and available to reserve calculations
- is included as on-hand supply when performing min-max, reorder point or MRP planning calculations
- is included as on-hand in all inquiries and reports, including inventory valuation reports
- can be transacted with Inventory functions and the Transaction Open Interface
Inventory includes the lot numbers of the items to cycle count when it generates a cycle count listing. You must assign lot numbers to all items under lot control for which you enter counts. If there is a difference between the count quantity and the system on-hand quantity, Inventory adjusts the item quantity in that lot. See: Entering Cycle Counts.
Performing Physical Inventories
Inventory includes the lot numbers of the items to count in your physical inventory when it generates tags. You must assign lot numbers to all items under lot control for which you enter counts in the Physical Inventory Tag Counts window. If there is a difference between the count quantity and the system on-hand quantity, Inventory adjusts the item quantity in that lot. See: Entering and Voiding Physical Inventory Tag Counts.
Assigning Lot Numbers to Assemblies
When you complete an assembly under lot control into inventory, you must assign a lot number in the WIP Completion Transaction form in Oracle Work in Process. For assembly completions on discrete jobs, Oracle Work in Process defaults the job's lot number. See: Overview of Assembly Completions and Returns, WIP Parameters., Overview of Material Control, and Overview of Shop Floor Control.
Purging Lot Transactions
You can purge all lot transaction information from your current organization. Note that the transactions must be in closed accounting periods. See: Purging Transaction History.
Attention: Purging lot transactions eliminates information used in lot genealogy reports and inquiries (Supplier Lot Trace Report, Job Lot Composition Report, and Job Lot Composition Inquiry).
Setting Up Lot Control