My Oracle Support Banner

An External Inventory Adjustment Created Through Webservice Has No Validation On Stock On Hand (Doc ID 2684586.1)

Last updated on JULY 01, 2020

Applies to:

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

Symptoms

Users are able to move inventory more than the available stock on hand when the inventory adjustment message is sent via Webservice.

Steps to Recreate:

1. Select an item which has QUANTITY_TOTAL > 0 in STORE_ITEM_STOCK table.

ITEM QUANTITY_TOTAL QUANTITY_RESERVED QUANTITY_CUSTOMER_RESERVE QUANTITY_IN_TRANSIT QUANTITY_VENDOR_RETURN QUANTITY_NON_SELLABLE
XXX 924 4 0 0 21 0

2. Invoke InventoryAdjustmentService?WSDL to move inventory  to any non-sellable bucket and specify the quantity more than total available quantity. 

ITEM QUANTITY_TOTAL QUANTITY_RESERVED QUANTITY_CUSTOMER_RESERVE QUANTITY_IN_TRANSIT QUANTITY_VENDOR_RETURN QUANTITY_NON_SELLABLE
xxx 924 4 0 0 21 950

3. There is no warning message and the Inventory check is missing.

4. When the similar activity is performed in UI, there is a warning message.

Cause

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
Symptoms
Cause
Solution
References


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