My Oracle Support Banner

R12.2 Performance Issue In Application Programming Interface ( API ) QP_PREQ_PUB.PRICE_REQUEST ( PRICE_REQUEST API ) (Doc ID 2818997.1)

Last updated on MARCH 14, 2024

Applies to:

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


Calling API QP_PREQ_PUB.PRICE_REQUEST has poor performance
Experiencing Performance issue when requesting price for Items in Bulk using the API QP_PREQ_PUB.PRICE_REQUEST.
The API is taking 20 minutes to return the price.

Expectation is that this API Should finish in less than 5 minutes

The issue can be reproduced at will with the following steps:
1. Call the API QP_PREQ_PUB.PRICE_REQUEST to Bulk price the Lines.
2. API takes more than 20 minutes to return he price


Trace file shows most expensive query(s)




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.