My Oracle Support Banner

Duplicate Serial Transactions in MTL_UNIT_TRANSACTIONS for Consumptions on Serial Controlled Items, Impacting Inventory Transaction Manager Performance (Doc ID 1931270.1)

Last updated on JUNE 20, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Inventory Transactions

Actual Behavior
Inventory worker took long time when it running on one line on transaction interface with quantity 4000, although it took only one minute when it worked on another line of another item on quantity 5000

Expected Behavior
Inventory worker should not have performance issue.

Steps
The issue can be reproduced at will with the following steps:

1. Process Sales order Issue transactions from Transaction Open Interface (MTL_TRANSACTIONS_INTERFACE, MTL_SERIAL_NUMBERS_INTERFACE) for Serial Controlled items residing in Consigned locations.
2. Inventory transaction worker takes a long time.

Trace files show below queries taking the longest time -

 

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.