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.
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 ,
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
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
|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.|