Poor Performance On The Sales Order Form After Applying RPC 5 Patch
(Doc ID 2197434.1)
Last updated on AUGUST 09, 2021
Applies to:
Oracle Order Management - Version 12.1.3 to 12.1.3.4 [Release 12.1]Oracle Advanced Pricing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 5 [RPC5]
Symptoms
On : 12.1.3 version, Transaction Entry
ACTUAL BEHAVIOR
---------------
Performance issue on the Sales Order form after applying RPC 5 patch.
EXPECTED BEHAVIOR
-----------------------
The performance should not have degraded after applying the RPC 5 patch.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Via the Order Management Responsibility.
2. Navigate: Orders, Returns > Sales Orders
3. Enter Order line
TRACE FILE SHOWS
-----------------------
1) Most expensive statement begins with:
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
To implement the solution, please execute the following steps on a TEST instance where this issue is also present: |
| A. Set mandatory database initialization parameter optimizer_adaptive_features |
B. Run Advanced Pricing Concurrent Requests |
1. Run QP: Maintains the denormalized data in QP Qualifiers |
| 2. Run Build Attribute Mapping Rules |
| 3. Run Build Formula Package |
| 4. Next, if pattern search is enabled, run QP: Pattern Upgrade wide open. If not enabled, omit this step |
C. Create Index then run FND_STATS procedure to gather CBO stats |
D. Retest the issue. E. Migrate the solution as appropriate to other environments. |
| References |