My Oracle Support Banner

IProcurement System Times Out When Working With Very Large Requisitions (Doc ID 2570879.1)

Last updated on AUGUST 02, 2019

Applies to:

Oracle iProcurement - Version 12.2.7 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Requisition

ACTUAL BEHAVIOR
---------------
System Times Out when working with very large requisitions

Requisition with 215 lines and cannot complete processing the requisition due to being 'timed out' or kicked out of the system.

Trace shows:
SELECT PoRequisitionLineEO.REQUISITION_LINE_ID,
PoRequisitionLineEO.REQUISITION_HEADER_ID,
PoRequisitionLineEO.LINE_NUM, PoRequisitionLineEO.CLM_INFO_FLAG,
PoRequisitionLineEO.CLM_OPTION_FROM_DATE,
PoRequisitionLineEO.CLM_OPTION_INDICATOR,
PoRequisitionLineEO.CLM_OPTION_NUM,
PoRequisitionLineEO.CLM_OPTION_TO_DATE,
PoRequisitionLineEO.GROUP_LINE_ID,
PoRequisitionLineEO.LINE_NUM_DISPLAY,
PoRequisitionLineEO.CLM_BASE_LINE_NUM
FROM
PO_REQUISITION_LINES_ALL PoRequisitionLineEO WHERE
PoRequisitionLineEO.CLM_BASE_LINE_NUM = :Bind_RequisitionLineId ORDER BY CLM_OPTION_NUM

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 215 0.14 0.14 0 5 0 0
Fetch 277 115.30 118.28 17748 5298460 0 128
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 493 115.44 118.43 17748 5298465 0 128



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
Cause
Solution
References


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