Create Accouting - Receiving Concurrent Request Encounters Performance Issue (Doc ID 1136312.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Purchasing - Version 12.0.6 and later
Information in this document applies to any platform.
ConcurrentProgram:RECEIPT_ACCRUALS - Receipt Accruals - Period-End


Symptoms

Receipt Accruals - Period-End Concurrent Request is run and then the Create Accounting - Receiving is submitted
and it is taking a very long time.  Create Accounting - Receiving is having very poor performance.

When running the Request - Create Accounting - Receiving -  with trace enabled, the performance is with the following statement:

SELECT
[...]
FROM
XLA_EVENTS_GT XET , CST_XLA_RCV_HEADERS_V H1 , CST_XLA_RCV_REF_V H3 ,
PO_DISTS_REF_V H4 , PO_HEADERS_REF_V H5 , PSA_CST_XLA_PEA_UPG_V H6 ,
FND_LOOKUP_VALUES FVL7 , FND_LOOKUP_VALUES FVL34
WHERE
[...]

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 3.20 3.21 0 903 0 0
Fetch 1 19776.97 19935.51 12051 3431357430 2446631 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 19780.17 19938.73 12051 3431358333 2446631 0

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