Receiving Transaction Processor Takes Long Time To Complete
(Doc ID 1981382.1)
Last updated on AUGUST 23, 2020
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Receiving Functions
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)
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