Inventory Control - Lot Control

 
A lot is a specific batch of an item that you receive and store in your 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. We can enable lot number control for specific item in our inventory. For items under lot control, we assign lot numbers to each receipt, and thereafter reference the same lots each time we perform material transactions. This enables us to have tight control over lot controlled items in our inventory.

We can divide each lot into child lots that can reflect whatever characteristics we choose for items within the lot. For example, we may divide a lot of items from a supplier into child lots to reflect differences in quality specifications.

Child Lots:
 
A child lot is a subdivision of a lot that we can use produce a lot over period of time, but still want group the material as a single lot. Using a child lot maintains the integrity of the lot, but enables you to consume it in manageable pieces. When process transactions for material under child lot control, we enter child lot as the lot number. The system also maintains a genealogy (Family three) relationship between parent and child lot. 
Lot Number Uses in Oracle Inventory:

Material transactions you can trace item movements by lot number.

Reservations you can place hold on batches of items.

Perishable items you can establish shelf life control to regulate the use of perishable items.

Accuracy you can enter lot number information when you enter physical inventory counts and cycle counts for lot-controlled items.

Reports and inquiries Oracle Inventory displays lot number information on reports and inquiry windows that list item quantity and transaction information. 
Define Organization Parameter for Lot Control:
Navigation: MCR INV > Setup > Organizations > Parameter > MIB > Go to Revision, Lot, Serial and LPN Tab.
 
Uniqueness Level of Lot Numbers:

 
None: None can assign the same lot number to multiple part numbers in the same organization and across organizations.

Across items: Across items can assign a specific lot number to only one item in the same organization. 
Lot Number Generation Options:

 
At Item Level: We can specify a starting lot number prefix and a starting lot number when you define an item under lot control. When you receive the item, Oracle Inventory uses this information to generate a default lot number for the item. You can always override default lot numbers.

At Organization Level: We can specify the starting prefix and lot number information when you enter the organization parameters. When you receive a lot controlled item, Oracle Inventory uses this information to generate a default lot number for the item. You can always override default lot numbers.

User-Defined: Oracle Inventory does not generate a default lot number when you receive your item.

Define Item in the item master and enable Lot Control:

Lot Control:

 
No control: Do not establish lot control for the item

Full control: Track inventory balances by lot number. You must specify a lot number for issues and receipts. 
Starting Lot Prefix: Enter a starting prefix for all lot numbers you define for this item. When Lot Number Generation is At item level in the organization parameters, this prefix is used when you define a lot number.

Starting Lot Number: Enter a starting numeric suffix for this item only. When Lot Number Generation is at item level in the organization parameters, this starting numeric suffix is used when you create a lot number. Thereafter, this number is incremented for each succeeding lot.
Navigation: MCR INV > Item > Master Items. Enter the values as per the screen shot and save the changes.

 
Assign this item to MIB Inv. Org. Tools > Organization Assignments check the assignment check box for MIB Inventory Organization and save the changes.

Create Miscellaneous Transactions for Item which is enabled for Lot Control:

Navigation: MCR INV > Transactions > Miscellaneous Transactions > Type as Miscellaneous receipt > Transaction Lines
 
We cannot save the transactions until we enter the lot numbers for 100 quantity.

Click Lot/Serial button and enter the lot numbers and save the changes and click on Done and save the transaction.

To View the Lot numbers: On-Hand, Availability > Lots > Item Number as MI-lot01 > Find

Create Miscellaneous Transactions for Item which is enabled for Lot Control:
Navigation: MCR INV > Transactions > Miscellaneous Transactions > Type as Miscellaneous Issues > Transaction Lines

Click Lot/Serial button and enter the lot numbers and save the changes and click on Done and save the transaction.

Here there no lot MI-LOT005 for 10 quantity, but system will accept with caution message as inventory Negative. Click on OK and done and save the transaction close the form.

To View the Lot numbers: On-Hand, Availability > Lots > Item Number as MI-lot01 > Find. Select lot MI-LOT005 and click on On-Hand button to see negative quantity.

 
Establishing Shelf Life Control
We can establish shelf life control for items under lot control and use shelf life control to regulate the use of perishable item...read more