My Oracle Support Banner

How to Improve Pricing Performance (Doc ID 1335892.1)

Last updated on MAY 13, 2019

Applies to:

Oracle Order Management - Version 11.5.9 and later
Oracle Advanced Pricing - 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

Purpose

This Master Note will provide an overview of

 

Scope

This document is informational and intended for any user.

Details

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
Purpose
Scope
Details
 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?
References

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