My Oracle Support Banner

E1: 42: Availability Calculations Incorrect with Lot Status Codes and Groups (Doc ID 2524843.1)

Last updated on JULY 09, 2019

Applies to:

JD Edwards EnterpriseOne Sales Order Entry - Version 9.2 and later
Information in this document applies to any platform.


Branch Availability calculations are not correct when using Lot Status Codes and Lot Status Groups. Commitments made against locations with lots on hold should not subtract from the quantity available for the branch as a whole causing backorders when sufficient inventory is available in no-held locations.

Steps to replicate

  1. Setup a new Item which has no inventory on-hand or available.
  2. Perform Two Inventory Adjustments.
    1. Location 1 has 100 Units – this location and the quantity available will serve the general population of customers.
    2. Location R has 200 units – this location and the quantity available is to be reserved for 1 specific customer.
  3. In Item Location Revisions (P41024) put Lot Status Code P on Location R.
  4. Check Item Availability (P41202). The Quantity Available field for Location R with Lot Status Code P is highlighted in gray, but shows 200 Available. There is 300 available in the entire branch.
  5. Now go to Item Availability Definition (P41001) for Branch 30. In the Subtract Column, the Quantity on Hold check box is unchecked.
  6. Check the Quantity on Hold check box. This caused the quantity available to be reduced by the quantity on hold.
  7. Return to Item Availability (P41202). The Quantity Available field for Location R with Lot Status Code P is highlighted in gray, but now shows 0 Available. The quantity available in the entire branch, is reduced to 100.00.
  8. Go to Lot Status Group Revision (P41081) and add a lot status group named RES for SO Order Types, with Lot Status Code P and Branch 30.
  9. Setup a Sales Order Entry Version (RES) and set the Commitment Tab Option #4 (Enter Allowed Lot Status Group To Validate) to “RES”.
  10. Create a Sales Order using this Sales Order Entry Version for 10 units and hard commit the inventory location as R. Save the order.
  11. Return to Item Availability (P41202). The quantity available on location 1 that is not on hold is 100, but the 10 items committed to location R reduce the total availability in the branch from 100 to 90. The quantity committed in the held location should not reduce the availability in the non-held locations. There should still be 100 available to fill other orders.
  12. Now using a version of Sales Order Entry (P4210) that does NOT have the allowed lot status group, enter a sales order for a customer from the general population for 100 units. The order goes on backorder because the system sees 90 available in the branch when it should be 100 available for general orders.
  13. If the user hard commits the new order to location 1 which has 100 units, the order comes off backorder.




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

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