My Oracle Support Banner

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:

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
Press ‘Continue’
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

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