E1: 41F: Allocation Proposal Calculates Retained Quantity Incorrectly When Availability Calculation Includes Soft Committed Quantities (RCW06/RCW08) (Doc ID 2016449.1)

Last updated on AUGUST 08, 2017

Applies to:

JD Edwards EnterpriseOne Apparel Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

When generating an allocation proposal using RCW06, system incorrectly calculated quantities available for allocation when soft commitment is deducted from availability.

For example, create two sales orders for SKUs of size 36, 38 and 40 which has an Onhand of 100 each.
Run Allocation Proposal over these orders with Fair Share disabled.
For Order 1,
• For size 36: Ordered: 120 Allocated: 60
• For size 38: Ordered: 120 Allocated: 70
• For size 40: Ordered: 120 Allocated: 80
For Order 2,
• For size 36: Ordered: 40 Allocated: 40
• For size 38: Ordered: 30 Allocated: 30
• For size 40: Ordered: 20 Allocated: 20
This result is wrong because the system should have allocated the quantity on hand (100) to each line of the 1st sales order.
The same results are obtained with Fair Share enabled which is also incorrect.

-- Expected results --
For Fair Share = N
Proposed Quantity = Quantity Ordered * Sprinkling Rate
Retained Quantity = Min(Proposed Quantity, Available Quantity)

For Order 1,
   For size 6: Ordered: 120 Proposed: 120 Available: 100 Retained: 100
   For size 8: Ordered: 120 Proposed: 120 Available: 100 Retained: 100
   For size 10:Ordered: 120 Proposed: 120 Available: 100 Retained: 100
For Order 2,
   For size 6: Ordered: 40 Proposed: 40 Available: 0 Retained: 0
   For size 8: Ordered: 30 Proposed: 30 Available: 0 Retained: 0
   For size 10:Ordered: 20 Proposed: 20 Available: 0 Retained: 0

For Fair Share = Y
Proposed Quantity = Quantity Ordered * Fair Share Rate
Retained Quantity = Min(Proposed Quantity, Available Quantity)
Fair share sprinkling rate = (Total available quantity) ÷ (Total open quantity)
Item 6 -> 100/160 -> 0.625
Item 8 -> 100/150 -> 0.666666667
Item 10 -> 100/140 -> 0.714285714

For Order 1,
   For size 6: Ordered: 120 Proposed: 75 Available: 100 Retained: 75
   For size 8: Ordered: 120 Proposed: 80 Available: 100 Retained: 80
   For size 10:Ordered: 120 Proposed: 85 Available: 100 Retained: 85
For Order 2,
   For size 6: Ordered: 40 Proposed: 25 Available: 25 Retained: 25
   For size 8: Ordered: 30 Proposed: 20 Available: 20 Retained: 20
   For size 10:Ordered: 20 Proposed: 15 Available: 15 Retained: 15

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms