POSTransaction Webservice Not Updating FUL_ORD Table With Modified Quantities for Customer Order
(Doc ID 2172136.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle Retail Store Inventory Management - Version 14.1.2 and later
Information in this document applies to any platform.
While using the POS Transaction WebService for creation of a Customer Reservation/Order, we cannot find Customer Reservation/ Order MODIFY transaction code in the WebService. We use the ORDER_NEW transaction code to again increase the reserved quantities. But when we modify the customer order (in this case increasing the reserved quantities), FUL_ORDER.QUANTITY_ORDERED does not get updated with increased quantities. However, STORE_ITEM_STOCK.QUANTITY_CUSTOMER_RESERVE gets updated.
Steps to Recreate:
- Navigate to POS Transaction WebService
- Create Customer Reservation / Order
Use data (template) as below for the Webservice xml:
8. Publish the message using WebService
9. Note that FUL_ORD_LINE_ITEM.QUANTITY_ORDERED is updated as 10, but STORE_ITEM_STOCK.QUANTITY_CUSTOMER_RESERVE is updated to 30.
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