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

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

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:

SQL ID: gr9fhyp0kn836

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

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