My Oracle Support Banner

API Inv_Quantity_Tree_Pub.Query_Quantities Does Not Calculate Availability at Cost_Group_Id Level ? (Doc ID 2394648.1)

Last updated on MAY 03, 2018

Applies to:

Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Onhand and Availability

API inv_quantity_tree_pub.query_quantities doesn't consider cost_group_id.  We need to query quantities at cost group level but API doesn't consider it. If you pass value to p_cost_group_id or not , it still returns same quantities.

API Should return the quantities based on the input parameters.

The issue can be reproduced at will with the following steps:
1. Call the API inv_quantity_tree_pub.query_quantities with all the required parameters and also input is cost group.
2. API returns the result same with cost group as input and without cost group as input.


To view full details, 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 a vibrant support community of peers and Oracle experts.