Performance Issue While Querying A Transaction With Sales Order Number

(Doc ID 739568.1)

Last updated on JUNE 20, 2016

Applies to:

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


    -- 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


    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