Performance Issue On First Time Lot Generation
(Doc ID 2308207.1)
Last updated on MARCH 26, 2019
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
There is a performance issue every time user tries to generate the very first lot for new item in a child organization.
Highest time running scripts:
1- SELECT 'N' FROM MTL_SYSTEM_ITEMS_B WHERE AUTO_LOT_ALPHA_PREFIX = :B1 AND LOT_CONTROL_CODE = 2 FOR UPDATE NOWAIT
2-UPDATE MTL_SYSTEM_ITEMS_B SET START_AUTO_LOT_NUMBER = :B2 WHERE AUTO_LOT_ALPHA_PREFIX = :B1 AND LOT_CONTROL_CODE = 2
The issue can be reproduced at will with the following steps:
1. Navigation: Inventory / On-hand availability / Lots
2. Select organization / query item
3. Try to generate first lot for new item
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