My Oracle Support Banner

Advanced Collections - View Account Form Performance Issue (Doc ID 2532621.1)

Last updated on JANUARY 04, 2023

Applies to:

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

Symptoms

When searching with Organization name and clicking on "View account LOV" it is taking 10 minutes for something to come up

Steps to Reproduce:

Responsibility: Advanced Collections responsibility
Navigation
: Collections Agent > View Account

  1. Notice it is taking a long time to see the View Account LOV

 

Top SQL statement causing the issue is the following:

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
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.