My Oracle Support Banner

LPNs in Inventory Have Onhand in Multiple Locations Leading to Negative Balance not Allowed Message (Doc ID 1191818.1)

Last updated on NOVEMBER 27, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.2 and later
Information in this document applies to any platform.


Sales orders are not getting shipped. When running Trip Stop Interface, the LPNs do not get issued out.

The items have a message of negative balance not allowed, although the inventory does not show as negative. From the diagnostic report the MTL_ONHAND_QUANTITIES_DETAIL (MOQD) information does not match the WMS_LPN_CONTENTS information and more than 1 record exists in MOQD, for different subinventories.

The issue can be reproduced at will with the following steps:
1. Try to ship LPN


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

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