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

Purpose

This Technical Reference will provide an overview of

Maintenance Tasks
Setting that can Impact Performance
Data Cleanup

Denormalized Data
Recommended Patch(s)
Additional Resources

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

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.