[DYNA] No Allocation 10001178 Fissan Extra Cool Powder 50g 48'

Question:

INCIDENT REPORT

[Dyna Drug Corporation] No Allocation for 10001178 Fissan Extra Cool Powder 50g 48'

Affected Environment:

PROD

Affected warehouse:

1120

Screenshots of error messages:

Time when issue occurred:

1:25PM

Affected module:

Outbound

Detailed description of issue:

Despite having sufficient inventory for SKU 10001178 Fissan Extra Cool Powder 50g 48', the system does not trigger allocation (auto or manually).

First level investigation/troubleshooting taken:

Case replication in original warehouse:

N/A

---

Answer:

Findings:
When checking debug log, the '=' in filter criteria "INV_LOT_ATT.lotAtt01 = '2024-02-06' causes the problem.
The SKU master 10001178 Shelf Life Type is set to "Manufacturing Date" (lotatt01) and Rotation ID set to "FEFO"
When check the Rotation ID "FEFO", it does not have the setting for Manufacturing Date (lotatt01)

2) If they change the the SKU shelf life type to "Expiration Date" = lotatt02, it will be able to allocate as RotationID FEFO already has the lotatt02 setting.

Customer is able to allocate after changing the SKU shelf life type to "Expiration Date".

Checking with flux.

Findings:
1) The existing inventory does not fill the mandatory fields.


2) There is a filter criteria "INV_LOT_ATT.lotAtt01 = '2024-02-06' " due to SKU master 10001178 Outbound Life Days = 91.