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

Last updated on OCTOBER 20, 2016

Applies to:

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

Symptoms

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.

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

Cause

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