Why is API QP_PREQ_PUB.PRICE_REQUEST Taking a Longer Time During its First Call?
(Doc ID 2667786.1)
Last updated on MAY 07, 2020
Applies to:
Oracle Advanced Pricing - Version 12 and laterInformation in this document applies to any platform.
Symptoms
Find poor performance on the first call to the price_request API for one record in a session.
It completes in 30+ seconds or more.
Trace File shows the following error only on the first run:
ERROR
The following statement encountered a error during parse:
SELECT 1 FROM DUAL WHERE dest.signature = src.signature AND
dest.category = src.category AND
dest.obj_type = src.obj_type AND
dest.plan_id = src.plan_id
Error encountered: ORA-00904
WHAT DOES WORK
However subsequent calls also with just one record, process without any error
and complete in milliseconds.
EXPECTED BEHAVIOR
Expect API to complete in couple seconds
STEPS
The issue can be reproduced at will with the following steps:
1. Using API QP_PREQ_PUB.PRICE_REQUEST
2. Find taking long time to provide the result (30+ seconds) but subsequent calls of API providing result in milliseconds
Changes
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 |
Changes |
Cause |
Solution |
References |