Material Already Expired & Material Expired Date Exception Setup For HLA [LN Interface_GetLotSql]
User is getting error message 'Material already expired' when user is trying to do Part Line Verification (HLA/Rework)through Mobile > Part Line Verification (HLA/Rework).
This is because the material has already expired and user check the checkbox for Check Expired Date in Product Tree setup.
Solution 1: Check the data in LN (generally once publish in LN it will take 10minutes to sync and MES will take retrieve the latest data after 10 minutes)
Solution 1.1: User is required the preferred is being set at table below tdipu001 MES will generally select the preferred one.
For user: User is required to check expiration date in LN. Current logic in MES is following the largest date from these field.
- select cdf_eidt from whltc100 with(nolock)
- select cdf_expi from whltc100 with(nolock)
- select ldat from whltc100 with(nolock)
For support: Stored Procedure Interface_GetLotSql
Lot information and expire date
SELECT * FROM whltc100with(nolock)
SELECT * FROM whwmd404with(nolock)
Manufacturer and MSL Level
SELECT * FROM tdipu049 with(nolock) [manufacturere information]
SELECT * FROM tdipu045 with(nolock) [msl level from column mch4]
Solution 2: Adding Material Expired Date Exception
If user still want to use the material without checking the expiry date, user can untick the checkbox or user can add exception for the material.
If user wants to add exception, user can go to Maintenance -> Material Expired Date Maintenance.
This screen is to allow the lot number able to use within a period of time that set by user when the lot number is expired.
Lot Number: Part Number + Lot Number
- Able to add exception which the lot number already expired.
Date Effective From Time MUST BE later than current time. If not, the system will not allow you to save the exception record.
- After save the exception will be show in the grid below.
- Able to add main lot by check the checkbox Main Lot.
- User will saw the record save as main lot.
- Able to search the record by fill in the lot number and click Search button.
- Error will be prompt
· Able to block user to create duplicate record.
Condition of the Duplicate record.
- Effective From date cannot within the range of exist record
- Effective To date cannot within the range of exist record
- Effective From cannot early than exist effective from and Effective To cannot late than exist effective To.
· Able to block user when create child lot number while the main lot exist.
- After add expired date exception, the lot number can continue proceed the HLA scan.
