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

Last updated on JUNE 21, 2016

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)

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