Performance Issue On First Time Lot Generation (Doc ID 2308207.1)

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.

Symptoms

ACTUAL BEHAVIOR

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


STEPS
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

Cause

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