My Oracle Support Banner

Inv_convert.inv_um_convert Is Giving -99999 (Doc ID 2117436.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information 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


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