Inv_convert.inv_um_convert Is Giving -99999
(Doc ID 2117436.1)
Last updated on JULY 24, 2020
Applies to:
Oracle Inventory Management - Version 12.1.2 and laterInformation in this document applies to any platform.
Symptoms
Process inv_convert.inv_um_convert is giving -99999
Create a new READ ONLY user, the function apps.inv_convert.inv_um_convert( msi.inventory_item_id,5,100,'EA','CA',NULL,NULL) CASE
Is returning -99999. Where as this function is giving proper data when run from APPS user.
EXAMPLE:
select segment1 product_number , primary_UOM_CODE,
apps.inv_convert.inv_um_convert( msi.inventory_item_id,5,100,'EA','CA',NULL,NULL) CASE
from apps.mtl_system_items_b msi
where msi.organization_id=XXX
and MSI.item_type = 'FINISHED GOODS'
and MSI.inventory_item_status_code in ('Active','XXXXXX')
and MSI.Customer_order_flag ='Y'
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 |