R12.2.x Performance Issue In Oracle Pricing For Entering Online Orders
(Doc ID 2244353.1)
Last updated on APRIL 18, 2018
Applies to:Oracle Advanced Pricing - Version 12.2.5 and later
Information in this document applies to any platform.
Performance issue in Oracle Pricing for Online Orders and change in seeded code
During performance testing, we have identified Online Order Creation Business Process is running long and not meeting the SLA. Upon analysis, we found a query in the seeded package "QP_PREQ_GRP" having high execution time. We have modified the Index and observed performance improvement in next load tests.
I've added the tkprof files, query details, business process for your reference and request oracle support to validate and give blessings on these changes
Run time details from Peak Load performance testing
Target SLA: 43.41sec
Achieved response time: 59.07seconds
after modified the query in seeded package, the runtime was reduced to less than 40sec at business process level during peak load testing
we have modified the same package for another performance issues in a batch job and it is being tracked through SR #3-14107672101
Expect performance to be better in R12.
The issue can be reproduced at will with the following steps:
1 Login to OTC system
2 Navigate to: Sales Order
3 Provide Customer Number in ‘Cust #’ field, Order Type in ‘Order Type’ field, PO Amount in ‘PO Amount’ field in DFF and Customer PO in Customer PO’ field and save the record
5 Navigate to the lines, Enter the Ordered Item, Quantity and Navigate down. Enter the next line and quantity and arrow down again
6 Press ‘Book’ Button after placing all the order lines
7 If the following error message pops up:
“A hold prevents booking of this order.” then
navigate to: Order Information Tab -> Action -> Release Holds -> Press OK -> Enter ‘Configuration is valid.’ In the Reason field -> Press OK -> Press ‘Release’
In case of any other message, ignore and proceed
8 A note ‘APP-ONT-251123: Hold Released Successfully’ will appear. Press OK
9 Press ‘Book’ Button
10 Press ‘OK’ when ‘the message ‘ Order has been booked’ pops up. In case of any other message, ignore and proceed
Verified the issue in the log file as noted below:
See the following expensive statement:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!