My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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


    To view full details, sign in with your My Oracle Support account.

    Don't have a My Oracle Support account? Click to get started!

    In this Document

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