Inv_convert.inv_um_convert Is Giving -99999

(Doc ID 2117436.1)

Last updated on JUNE 05, 2017

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

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