My Oracle Support Banner

E1: 46L: Cancelling Pick Request Containing License Plates Incorrectly Updates Commitment In Primary Location - P4600 (Doc ID 2436380.1)

Last updated on DECEMBER 01, 2020

Applies to:

JD Edwards EnterpriseOne Warehouse Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When a Picking Request is canceled using P4600 for Sales order updating the sales status code(999), the system updates committed quantity in F41021 incorrectly in the primary location with incorrect UOM qty

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new item with structure PL-CA-EA within a license plate branch
2. UOM Conversion is setup as below :
Primary UOM : EA
1 PL = 768 EA
1 CA = 6 EA
3. Create Inventory Adjustments/Putway to assign items to the License Plates
4. Current Item Availability(P41202) in EA for above Item :
Primary Location : Qty Committed is zero, Qty Available is 0, Secondary Location(01.A.01) Qty Available is 3072, Qty Committed is zero
5. Create a Sales Order is created for a qty of 500 CA against warehouse B/P
6. A pick requested was created for a created for a qty of 500 CA
7. Current Item Availability(P41202) in EA for above Item :
Primary Location : Qty Committed is 3000, Qty Available is -3000, Secondary Location(01.A.01) Qty Committed is zero, Qty Available is 3072
8. Run R46171
- In P4600,Pick Suggested for Qty of 500 CA and at status 220(Request Suggested)
- In P4617, Under Pick Confirmation, the order qty of 500 CA(3000 EA) is split into multiple License Plate as follows for location 'BS-022--' :
SAILP001 for 768 EA
SAILP002 for 768 EA
SAILP003 for 768 EA
SAILP004 for 696 EA
9. Item availability(P41202) in EA for the above Item shows the following results :
Primary Location : Qty Committed is 0, Qty Available is 0
Secondary Location(01.A.01) Qty Committed is 3000, Qty Available is 72
10. Access P4617, cancel all the License plate quantities Pick suggestion
11. Under P4600, pick status is 200 for the above sales order line
12. Item Availability(P41202) in EA for the Item has following results :
Primary Location : Qty Committed is 3000, Qty Available is -3000
Secondary Location(01.A.01) Qty Committed is zero, Qty Available is 3072
13. Under P4600,Cancel Pick request using P4600. This cancelled the Sales Order line as well(980/999)
14. Item Availability(P41202) in EA for the Item has following results :
Primary Location : Qty Committed is 2500, Qty Available is -2500
Secondary Location(01.A.01) Qty Committed is zero, Qty Available is 3072
Qty Committed on Primary location is relieved by 500 EA instead of 500 CA(3000EA). There is a residual false commitment of 2500 EA on Primary location

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.