My Oracle Support Banner

How to Sort Price List Lines (Doc ID 790785.1)

Last updated on DECEMBER 28, 2023

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
 There are two potential workarounds: (1) Forms Personalization or (2) Sort Using a Folder
 (1) Forms Personalization
 (2) Sort Using a Folder
References

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