My Oracle Support Banner

Pricing Engine Performance Issue After R12 Upgrade (Doc ID 2278974.1)

Last updated on SEPTEMBER 22, 2018

Applies to:

Oracle Advanced Pricing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR
---------------
Pricing Engine Performance issue after R12 upgrade

- We have a custom wrapper from where we are calling pricing engine API, This API behaving strangely in R12.
- Issue here is when it is getting invoked with around 300-400 item, then the response time is too high i.e 10-15 mins where as in 11i it is taking around 2-4 mins.
- We have compared the trace files from both the environment and have found several JTF tables are getting called in R12 where as they are not present in 11i trace.
- So please check and let us know what is the difference between two API and how we can minimize this performance issue.
- We have attached the trace from 11i and R12 as well. In the attached trace SOTCPROD and SOTCUAT are referring to our R12 instance and PDV1 referring to our 11i instance.


EXPECTED BEHAVIOR
-----------------------
Expect performance to be better in 11i.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Service - APPS.MHE_ESP_FRT_CALC_WITHMOD_PKG.MHE_ESP_FREIGHT_CALC_MAIN_PR
- This is freight service being called for 300+ items.17-18 minutes in 12.2 instance.
In 11i, it took 7 minutes.



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
Cause
Solution
References


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