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


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.


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

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