My Oracle Support Banner

How to Sort Price List Lines (Doc ID 790785.1)

Last updated on NOVEMBER 29, 2021

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.



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.