Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Available to Reserve in On hand quantities form is not matching with the value returned by INV_QUANT

edited Sep 9, 2016 5:00AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 3 commentsAnswered

Hi

We are testing below script two get On hand quantity and quantity reserved already.  Finally, We want to derive Nett Quantity that is available to transact. 

But, for Non controlled items (neither lot controlled nor serial controlled), below API is returning quantity reserved (x_qr) as zero even though there are reservations exists.  Where as Quantity On Hand form is showing correct quantity reserved.

Am I missing any thing or is there any bug?

DECLARE

                                    p_item_id              NUMBER;

                                    p_org_id              NUMBER;

                                    p_subinv              VARCHAR2(20);

                                    x_qoh              NUMBER;

                                    x_qr               NUMBER;

                                    x_return_status    VARCHAR2(10);

                                    x_msg_data         VARCHAR2(4000);

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