Transaction Register, and Applied Receipt Register Performance Issue - They Run for Days and do not Complete
(Doc ID 2109092.1)
Last updated on NOVEMBER 23, 2021
Applies to:
Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
Symptoms
The following reports run for days and do not complete:
ARRXINVR: Transaction Register, which spawn RX-only: Transaction Register
ARRXARRG: Applied Receipts Register, which spawns RX-only: Applied Receipts Register
Tkprof and AWR reports do not showing a SQL statement causing the issue. They only show the following PL/SQL call running long:
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.