Performance Issue On First Time Lot Generation
Last updated on SEPTEMBER 17, 2017
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
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 hundreds of Community platforms