Receiving Transaction Processor Takes Long Time To Complete
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.
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)
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