My Oracle Support Banner

How Is The Column MTL_ITEM_LOCATIONS.LOCATION_CURRENT_UNITS Updated? (Doc ID 3016645.1)

Last updated on APRIL 15, 2024

Applies to:

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

Goal

Under Stock Locators form, the location current units has a value of 10100009550109322103036501199285 but under MTL_ITEM_LOCATIONS it has a value of 1.01000095501093E31 under LOCATION_CURRENT_UNITS. How is MTL_ITEM_LOCATIONS.LOCATION_CURRENT_UNITS updated normally?

Is there any reason for the MTL_ITEM_LOCATIONS to be showing 1.01000095501093E31 instead of the value of the form 10100009550109322103036501199285. Is this expected functionality?

How can the value 1.01000095501093E31 be updated in MTL_ITEM_LOCATIONS for location current units?

Solution

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
Goal
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.