Self Life Control

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 items

Shelf Life Days: Specify a number of days for all lots of this item, beginning on the day you create the lot by receiving the item. Oracle Inventory calculates the expiration date of the lot by adding the shelf life days to the date on which you receive the item. We receive a warning message that the lot expires after the specified number of days.

User-defined: We can enter an expiration date when we receive each lot and issue items from an expired lot to a scrap account. If you perform any other transaction from an expired lot, Oracle Inventory displays a message warning you that the lot has expired. We receive a warning but are not prevented from using the lot after expiration.

No Control: Shelf life control not established for this item

Attention: You cannot change lot expiration control when an item has quantity on hand. If Lot Expiration is controlled at the Item level, the check for on–hand quantity is against the sum of on–hand quantities in all child organizations.

Shelf Life Days: Enter the number of days each lot is active. At receipt, the expiration date is determined by adding the shelf life days to the system date (includes the day you define the lot). This is used only when you choose Shelf life days for Lot Expiration Control.

Define Item in the item master and enable Lot and Lot Expiration (Self Life) Control as User Defined:
Enter the values as per the below screen shot.

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

Navigation: MCR INV > Transactions > Miscellaneous Transactions > Type as Miscellaneous receipt > Transaction Lines

 

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

Here system will ask you to provide Expiration date for lot number due to Lot Expiration (Self Life) Control as User Defined.

Miscellaneous Issues for same item:

Click on Lot/Serial button

Define Item in the item master and enable Lot and Lot Expiration (Self Life) Control as Shelf Life Days: 
Enter the values as per the below screen shot

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

Navigation: MCR INV > Transactions > Miscellaneous Transactions > Type as Miscellaneous receipt > Transaction Lines

Click on Lot/Serial button

Here system will provide Expiration date based on Shelf Life Days (30) for lot number due to Lot Expiration (Shelf Life) Control as Shelf Life Days.

Expired Lots: you can determine whether a lot has an expiration date by assigning a number of lot control shelf life days or by entering a 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

Disabled Lots: 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 accepted 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

can be reserved

To View and disable the Lot numbers: On-Hand, Availability > Lots > Item Number as MI-lot01 > Find. Keep the scroll bar to end and check the check box for lot numbers and save the changes.