How to Sort Price List Lines (Doc ID 790785.1)

Last updated on JANUARY 08, 2014

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
FORM:QPXPRDPL.FMB - Define Price Lists



Goal

The standard functionality of the application, for performance reasons, is to not sort price list lines.
Enhancement request <Bug 16085591>- QPXPRLST: NEED METHOD TO SELECT HOW PRICE LIST LINES ARE SORTED
is logged with Oracle Development for consideration in a future version of Oracle Applications.

As a potential workaround, this document will suggest how to set the Order_by property using Form Personalization to sort price list lines by effective date range.
The steps provided may also be slightly modified to sort differently such as by the list_line_no to meet various business requirements.

Solution

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