My Oracle Support Banner

How to Improve Pricing Performance (Doc ID 1335892.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Advanced Pricing - Version 11.5.9 and later
Oracle Order Management - Version 11.5.9 and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
Form:OEXOETEL.FMB - Quick Sales Orders
Form:OEXOEBSO.FMB - Blanket Sales Agreements


This Technical Reference will provide an overview of



This document is informational and intended for any user.


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
 Ensure Statistics Are Recently Gathered
 Review Database Initialization Parameters
 Turn All Debug Profiles Off
 Use default sales order form folder
 Inactivate Expired Pricing Entity(s)
 Modifier Setup Tip(s)
 Purge Pricing Engine Requests
 Archive / Purge Pricing Entities
 Ensure common pricing packages are pinned to the database.
 Obtain current version key file used by the pricing engine(file QPXGPREB.pls)
 Profile options that affect performance
 Run QP: Maintains the denormalized data in QP Qualifiers
 If pattern search is enabled, run QP: Pattern Upgrade wide open.
 Run Build Attribute Mapping Rules
 Run Build Formula Package
 Review Recommended Patch List
 Optional, Tuning a SQL statement
 Optional Pricing Functionality
 API Has Poor Performance
 Review Additional Resources
  What is needed to Log a Service Request?

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