Transaction Workbench Performance Issue: Poor Performance in List of Values for Location Number in Paying Customer tab (Doc ID 1506978.1)

Last updated on OCTOBER 11, 2013

Applies to:

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

Symptoms

On 12.0.X transaction workbench took over 7-10 minutes to display List of Values for Location Number in Paying Customer tab.

Review of the trace file shows the following query is causing the delay:

 

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