My Oracle Support Banner

Performance Issue While Querying A Transaction With Sales Order Number (Doc ID 739568.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle Receivables - Version: 12.0 to 12.1 - Release: 12 to 12
Information in this document applies to any platform.
ARXTWMAI.fmb
  • ***Checked for relevance on 30-Apr-2010***

    Symptoms

    -- Problem Statement:
    When searching in transactions form by sales order number, the system hangs with the following sql:

    select distinct sales_order
    from ra_customer_trx_lines order by sales_order







    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!


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