Tuesday, July 24, 2012

MTL_RESERVATIONS


On 11.5.10.2 in Production:
Find that when Customer creates Org Level Reservations for Internal  Sales
Orders. If  partial quantity  gets Pick  released and Shipped,  the Org
Level Reservation  for the remaining Back ordered qty  gets relieved.

EXPECTED BEHAVIOR
-----------------------
Expect the reservation should split , and the new line should carry the Org
Level reservation of the remaining qty.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Item Number : XXXXXX
OHQ Picture:
Sub: Secondary LPN1 : 100 qty
Sub: Secondary LPN2 : 100 qty
Sub: Primary Loose : 25 (Not packed)

1) Internal  requisition / Internal Sales Order created for 150 qty
2) Org   Level reservation is created for 150  qty

3) Pick  Release  WITH  PRIOR RESERVATION
4) Based on the WMS Rule (Allocate Full LPN)  system can allocate only  125
(Lpn1 100qty + 25 loose)
5) At this point  the STF shows the following
Released to  Warehouse : 125 , Back  Ordered : 25
6) At  this Point, the mtl_reservations shows
reservation_quantity = 150   and  detailed_quantity = 125
7) After  the Pick  Confirmation , in the mtl_reservations , the
reservation_quantity  changes to
125 , with  Staged_flag = Y
8) Expect the reservation should split , and the new line should carry the
Org Level reservation of the remaining 25 qty.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the  Business Rules which  were set up  for reservations
now have no meaning because of the problem, and it is causing considerable
loss of Business of the organization.

No comments:

Post a Comment