Customer Workbench: Customer Account Details (ARXCWMAI) Performance Issue - Taking More Than Three (3) Minutes to Search for a Customer Number (Doc ID 1609140.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

ARXCWMAI: Bad Performance

Attempting to query on a Customer Number in the Account Details form and it is taking more than three (3) minutes to complete the search.

Long running SQL_ID 3rcsgkywnzg91:

Elapsed Time (s): 253.24

Version: ARXCWMAI.fmb 120.7.12010000.2

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