R12.2.x Performance Issue In Oracle Pricing For Entering Online Orders
(Doc ID 2244353.1)
Last updated on FEBRUARY 20, 2019
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.
Following is the most expensive SQL statement:
STEPS TO REPRODUCE THE ISSUE
The issue can be reproduced at will with the following steps:
1 Login to the application
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
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