not to allow lots expiring below 6 months from ASN page

Summary:

Requirement

We are using Oracle Fusion Cloud SCM – standard Inventory/Receiving, and Oracle WMS is not currently available.

Suppliers/users create ASNs manually in Fusion, and warehouse users subsequently receive the material against the ASN.

We need to provide a warning message only when a lot being entered on the ASN/receipt has less than 6 months remaining shelf life.

Business Requirement

When the user enters/selects a lot and provides the Lot Expiration Date, Fusion should compare the expiration date with the current/transaction date.

Required logic:

Lot Expiration Date < Transaction Date + 6 calendar months
        ↓
Display Warning

Example:

Transaction Date     : 08-Sep-2026
Minimum acceptable   : 08-Mar-2027

Lot expiry 07-Mar-2027 → WARNING
Lot expiry 08-Mar-2027 → No warning
Lot expiry 15-Apr-2027 → No warning