Unapplied and Unresolved Receipts Register Has a Performance Issue

(Doc ID 1932441.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Unapplied and Unresolved Receipts Register report takes 8 hours to run.

Parent process: ARRXUNAC module: Unapplied and Unresolved Receipts Register
Child process: RXARUNAR module: RX-only: Unapplied and Unresolved Receipts Register
The child process is the one taking 8 hours to run.

The following SQL statement is causing the performance issue:

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