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:

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

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