Performance When Searching Items To Receive In iProcurement: No Backend Server Available For Connection
Last updated on SEPTEMBER 11, 2015
Applies to:
Oracle iProcurement - Version 12.2.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.3 version,
Executing a search to receive items, after more than 5 minutes, the error message is shown:
Error:
-----
No backend server available for connection: timed out after 10 seconds or
idempotent set to OFF or method not idempotent
SQL Tracing points to the following SQL :
SQL> SELECT * FROM (select REQ_LINE_ID,
null RCV_SHIPMENT_NUMBER,
ORDER_TYPE_CODE,
RECEIPT_DATE,
REQUESTOR_ID,
PO_HEADER_ID,
...
AND pod.project_id = ppa.project_id)
project_number
from por_rcv_purchase_items_v rcv
UNION ALL
select REQ_LINE_ID,
null RCV_SHIPMENT_NUMBER,
..
NULL,
NULL,
NULL
from por_rcv_internal_items_v rcv1) QRSLT WHERE (requestor_id = :0)
STEPS
-----------------------
1. Click iProcurement responsibility > Receiving > Receive Items
2. Clear requester
3. Keep the last 7 days
4. Click Go
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms