Inventory Management - EBS (MOSC)

MOSC Banner

Use of inv_convert.inv_um_convert gives wrong result

I am using EBS 12.1.3 with database 19c (19.10.0.0.0) I am using inv_convert.inv_um_convert function to get secondary quantity but it is giving wrong result which is -9999 (database user is different than APPS which has been granted to execute this function)

select apps.inv_convert.inv_um_convert(item_id         =>  153467,
                                                              lot_number      =>  null,
                                                              organization_id =>  121,
                                                              precision       =>  5,
                                                              from_quantity   =>  4,
                                                              from_unit       =>  'EA',
                                                              to_unit         =>  'SQM',
                                                              from_name       =>  NULL,
                                                              to_name         =>  NULL) from dual;

However while using with APPS user it is giving correct result.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center