My Oracle Support Banner

What Scripts do I Need To Provide for Diagnosing Advanced Pricing Performance ? (Doc ID 428842.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Oracle Advanced Pricing - Version 11.5.9 and later
Information in this document applies to any platform.
EXECUTABLE:QPXDENOB - QP: Maintains the denormalized data in QP Qualifiers
EXECUTABLE:QPXPERFO - Performance Analysis script
EXECUTABLE:QPXPSRCB - Build Attribute Mapping Rules
EXECUTABLE:QPXPSRCB2 - Attribute Mapping Rules Error Report
FORM:QPXPRMLS.FMB - Modifier Details
FORM:OEXOEORD.FMB - Sales Orders
FORM:QPXPRMLS.FMB - Modifier Details
FORM:QPXPRQFS.FMB - Qualifier Grouping
FORM:OEXOEORD.FMB - Sales Orders
FORM:QPXCONAT.FMB - Context and Segments
FORM:QPXPRDDI.FMB - Define Discounts



Purpose

This document is intended to provide a complete list of items that will be required for development to accept and work on a performance issue in Oracle Pricing or Advanced Pricing application. This is specific to Order Management modules (QP, OM, WSH), with a focus on the Pricing Engine performance.

Troubleshooting Steps

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
Troubleshooting Steps
 --- Scope and Application ---
 --- Diagnosing Advanced Pricing Performance What Scripts do I Need To Provide ---
 List of traces, logs and files that we will need:
 Profile options that affect performance:
 Action Item Requiring Output:
 A1. Diagnostics: Apps Check
 A2. Run QP: Maintains the denormalized data in QP Qualifiers
 A3. Run Build Attribute Mapping Rules
 A4. Run Attribute Mapping Rules Error Report
 A5. Run Diagnostics: Performance Analysis
 A6. Please provide the raw trace with Binds and Waits.
 A7. Provide TKPROFs for the above raw trace.
 A8. TKPROF that limits the results to the top ten queries(Optional):
 A9. What is the time spent in the pricing engine during this process?
 A10. How to generate an OM Debug File For Performance Analysis
 A11. Please provide the Sales Order diagnostic report
 A.12 Provide Diagnostics: List Line Details
 A.13 Execute this script and Provide the output
 A.14 Create a TraceAnalyzer File (Optional)
 A.15 Execute Script bde_chk_cbo.sql
 A.16 Execute Script bde_last_analyzed.sql
 QUESTIONS REQUIRING RESPONSE
 
Q1. When did the performance issue start happening?
Q2. What is the total time clock time for the benchmark orders the user experiences?
Q3. What is the expected time for performance?
Q4. What is the business justification for this expected time?
Q5. How often do you "Gather Schema Statistics" and when was the last time it was executed?
Q6. How often do you execute concurrent program "QP: Maintain denormalized data?
Q7. What is the profile option Set QP: Blind Discount Option?
Q8. What is the setting for profile option Set QP: Build Attributes mapping options?
Q9. What is the setting for Set QP: Satisfied Qualifiers Option?
Q10. What is the profile setting for OM: Deactivate Pricing at Scheduling?
Q11. What is the profile setting for OM: Sales Order Form: Refresh Method?
Q12. What is the profile setting for OM: send changed lines to pricing to?
Q13. Is Tax calculation on during Order Entry?
Q14. Do all of the unnecessary pricing phases have an end date in the past?
Q15. Are the following packages pinned to the database?
 Q16. Have these performance notes been reviewed?
 Q17. Is anyone charged with the maintenance of your pricing data?
 Q18. What data cleaning steps are routinely used from the above technical briefs? 
 Q19. Do you purge the debugs before your run? Especially Purge Pricing Engine Requests and set the QP Debug to Off?
References

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