PosTransaction Webservice Does Not Validate Canceled Quantity In Layaway Transactions

(Doc ID 2240726.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 14.1.2 and later
Information in this document applies to any platform.


On : 14.1.2 version, SIM Integration

POSTransaction Webservice does not VALIDATE the canceled quantity in LAYAWAY transaction. In consequence, if canceled quantity is greater than initial one more quantity is cancelled in SIM and make Customer Reserved Bucket Negative in STORE_ITEM_STOCK table

Steps to recreate:

The issue can be reproduced at will with the following steps:

  1. Create a new order using webservice , with reservation type LAYAWAY and qty X
  2. Cancel the same customer order created at step 1, using webservice , and entering qty Y (Y> X)
  3. Check store _item _stock table and noticed that quantity_customer_reserved is negative


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