Performance Issue When Drilling Down to IEXRCALL from the UWQ Bill To Node

(Doc ID 1957460.1)

Last updated on OCTOBER 24, 2017

Applies to:

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


You are attempting to drill down to the IEXRCALL form, from the Delinquent Bill To node of the Universal Work Queue (UWQ), and there is a performance problem accessing customers with a large amount of delinquencies.

Steps to Reproduce:
: Receivables Manager

  1. Open the UWQ, and select a customer from the Delinquent Bill To node.
  2. Double click on the customer, to drill down to IEXRCALL, and verify if there is performance issue.

The problem sql from the trace is:


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