Performance Issue on Lot Genealogy Form When Trying To Move To Material Transactions Tab Or Work Order Details Tab
(Doc ID 3014321.1)
Last updated on APRIL 03, 2024
Applies to:
Oracle Inventory Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Querying for work order details or material transactions on lot genealogy form takes a long time
STEPS
1. Inventory super user > Onhand quantity> Lots > Enter lot number > Click on find
2. Click on View Genealogy Button
3. Select the job record in left pane > While moving from workorder details and material transactions tab it takes a long time
Trace file / tkprof shows below query taking long time -
Cause
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
Symptoms |
Cause |
Solution |
References |