R12: AP: Journal Entries Report (XLAJELINESRPT) Performance Problem (Doc ID 1257804.1)

Last updated on APRIL 12, 2024

Applies to:

Symptoms

Journal Entries Report Performance Problem.

SELECT
TABLE1.GL_DATE GL_DATE
,TABLE1.CREATED_BY CREATED_BY
,TABLE1.CREATION_DATE CREATION_DATE
,TABLE1.LAST_UPDATE_DATE LAST_UPDATE_DATE
,TABLE1.GL_TRANSFER_DATE GL_TRANSFER_DATE
,TABLE1.REFERENCE_DATE REFERENCE_DATE
,TABLE1.COMPLETED_DATE COMPLETED_DATE
,TABLE1.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
,TABLE1.REFERENCE_1 REFERENCE_1
,TABLE1.REFERENCE_4 REFERENCE_4
,TABLE1.PERIOD_YEAR PERIOD_YEAR
,TABLE1.PERIOD_YEAR_START_DATE PERIOD_YEAR_START_DATE
,TABLE1.PERIOD_YEAR_END_DATE PERIOD_YEAR_END_DATE
,TABLE1.PERIOD_NUMBER PERIOD_NUMBER
,TABLE1.PERIOD_NAME PERIOD_NAME
,TABLE1.PERIOD_START_DATE PERIOD_START_DATE
,TABLE1.PERIOD_END_DATE PERIOD_END_DATE
,TABLE1.TRANSACTION_NUMBER TRANSACTION_NUMBER
,TABLE1.TRANSACTION_DATE TRANSACTION_DATE
,TABLE1.ACCOUNTING_SEQUENCE_NAME ACCOUNTING_SEQUENCE_NAME
,TABLE1.ACCOUNTING_SEQUENCE_VERSION ACCOUNTING_SEQUENCE_VERSION
,TABLE1.ACCOUNTING_SEQUENCE_NUMBER ACCOUNTING_SEQUENCE_NUMBER
,TABLE1.REPORTING_SEQUENCE_NAME REPORTING_SEQUENCE_NAME
,TABLE1.REPORTING_SEQUENCE_VERSION REPORTING_SEQUENCE_VERSION

...................
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.00 0 0 0 0
Execute 1 3.03 2.97 0 0 0 0
Fetch 1884 156.47 566.08 232909 1156389 0 37680
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1886 159.51 569.06 232909 1156389 0 37680

Changes

None

Cause

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