My Oracle Support Banner

When Executing The TASK ,after Shorting The Units, It Is Giving Error (Doc ID 2423065.1)

Last updated on JULY 17, 2018

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.2 and later
Information in this document applies to any platform.


On: NA version, Core Product Functionality

When attempting to Short pick
the following error occurs.

new row for relation "inventory" violates check constraint "no_negative_curr_qty"

The issue can be reproduced at will with the following steps:
1. Launch RF Screen
2. Select the Execute Task option
3. Scan the OBLPN
4)Scan the Location
5)Scan the Item
6)Press CTRL-P option(User trying to do short pick)
7)Got the error
The issue has the following business impact:
Due to this issue, users cannot able to complete short pick and allocate it again.


To view full details, 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 a vibrant support community of peers and Oracle experts.