XALLOC - Xallocdtlmod Does Not Allow For Cancelling Lines as RMS Online Does (Doc ID 2074269.1)

Last updated on NOVEMBER 23, 2015

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.


Actual Behavior
Unable to use XAlloc message to set an allocation detail line to zero quantity in order to cancel out the allocation lines. If you try to use the XAllocDtlMod message to reduce quantities to zero (in the same manner as the online form) you get the following error message:

"The quantity allocated cannot be less than or equal to zero."  

Expected Behavior
The XAlloc functionality needs to work in the same manner as what happens when using the "Cancel all items" capability in the Order Maintenance screen.  

What is Working
If integrating Purchase Orders (POs) and Allocations from another application and an order with allocations attached needs to have all the lines cancelled, XOrder handles the POs part.

Steps to Reproduce
1. Start with a PO (integrated into RMS via XORDER and XALLOC) that has allocations attached and is in Worksheet status.
2. Notice PO has multiple line items with allocations attached.
3. Query the database to see the allocations exist for the PO.
4. Cancel all the items on the PO using the Options -> Cancel All Items function.
5. Answer Yes, to the "Do you want to cancel the allocations?" question.
6. Enter the "Cancel Reason".
7. Notice in the PO Item/Location screen that the PO line items and the allocation line items have all had the quantities set to zero.
8. Again query the database to see that the allocation detail quantities have been set to zero and the cancelled quantities set accordingly.
9. Now try the same process  using XOrder (XOrderMod, XOrderDtlMod and XAllocDtlMod) messages to cancel the PO lines and PO details.  
10. Notice that the PO header and PO detail lines are cancelled in the same manner that the online forms cancelled.  
11. However, the XAllocDtlMod messages will fail with the following error message:  
"The quantity allocated cannot be less than or equal to zero."



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