My Oracle Support Banner

Performance Issue With Interface Trip Stop Concurrent (Doc ID 1568178.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Interface Trip Stop

Getting performance issues / hangs when running the Interface Trip Stop program. The problem happens when an order line split exists.

When attempting to run Interface Trip Stop program, the following error occurs:

ERROR
-----------------------
database alert log file shows multiple deadlock errors
in the last dead lock, which associated with trace file, shows:

----- Current SQL Statement for this session (sql_id=3za2jkb0grf5d) -----
UPDATE MTL_TXN_REQUEST_LINES SET TXN_SOURCE_LINE_ID = :B2 WHERE LINE_ID = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object line object
 handle number name
7000009ef648230 2163 package body APPS.INV_TRANSFER_ORDER_PVT
..


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. using order management responsibility
2. submit interface trip stop


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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.