My Oracle Support Banner

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

Last updated on JANUARY 16, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.