My Oracle Support Banner

Receiving Transaction Processor Takes Long Time To Complete (Doc ID 1981382.1)

Last updated on MARCH 14, 2023

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, Receiving Functions

ACTUAL BEHAVIOR
---------------
Receiving Transaction Processor has bad performance.
It takes long time to complete the process.

The following sql takes long time,

UPDATE PO_SESSION_GT GTO SET GTO.NUM10 = (SELECT (GTI.NUM3/GTI.NUM4)*GTI.NUM9 FROM PO_SESSION_GT GTI WHERE GTI.NUM1 = GTO.NUM1)

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.