My Oracle Support Banner

How to Sort Price List Lines (Doc ID 790785.1)

Last updated on MAY 29, 2020

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

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
Goal
Solution
 A. Forms Personalization Setup Needed
 B. Retest using an Order Management or a Pricing Responsibility
References

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