Performance Issue while Executing a Query in the Customers Search Form (Doc ID 3049353.1)

Last updated on OCTOBER 15, 2024

Applies to:

Oracle Trading Community - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Performance issue is observed while executing queries in the Customers form.

The query identified is:

The query may have variations as it is constructed depending on the parameters passed in the form.

STEPS

Responsibility: Receivables
Navigation: Customers > Create/Maintain Customers
1. Enter criteria for query and click on the 'Go' button
2. While the query is still executing, do one or more of the following (not limited to the below list):
    a) Change the Party type
    b) Click on 'Go' button multiple times and change party type value
    c) Click on the browser back button and click on the 'Go' button again
3) The above leads to retrieve all data, causing performance and server hogging