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
Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
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:
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.