Accounting Program (XLAACCUP) Performance Issue (Doc ID 1958640.1)

Last updated on APRIL 28, 2023

Applies to:

Symptoms

Performance problem with Accounting Program (XLAACCUP) when executed for Payables.
It takes 5+ hours to finish.

The SQL statement that is taking long time is the following:

SELECT /*+ leading(xet) cardinality(xet,1) */ XET.ENTITY_ID ,
 XET.LEGAL_ENTITY_ID ,XET.ENTITY_CODE ,XET.TRANSACTION_NUMBER ,XET.EVENT_ID ,
..
..
FROM
XLA_EVENTS_GT XET , AP_PAYMENT_EXTRACT_DETAILS_V L1 ,
 AP_PO_HEADERS_EXTRACT_V L3 , ZX_AP_DEF_TAX_EXTRACT_V L5 , FND_LOOKUP_VALUES
 FVL34 , FND_LOOKUP_VALUES FVL44 , FND_LOOKUP_VALUES FVL61 ,
 FND_LOOKUP_VALUES FVL70 , FND_LOOKUP_VALUES FVL82 , FND_LOOKUP_VALUES
 FVL174 WHERE XET.EVENT_ID BETWEEN :B5 AND :B4 AND XET.EVENT_DATE BETWEEN
..
..

Cause

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