Poor Performance On Query Extracting Onhand Quantity During Allocation And Pick Confirmation Using Lot Numbers
(Doc ID 2623512.1)
Last updated on DECEMBER 23, 2019
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Reservations
Poor performance for allocation and picking using API. Trace lists below sql for getting onhand quantity taking a long time -
This is the query extracting onhand quantity.
The issue can be reproduced at will with the following steps:
1. Change profile option INV: Material Status Support from Null to Yes
2. Perform Picking and allocation using the standard API inv_replenish_detail_pub.line_details_pub and inv_pick_wave_pick_confirm_pub.pick_confirm
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