Last updated on AUGUST 31, 2017
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Performance issue with APXPGSEL module: AP/PO Purge Initiation (Selection)
Routine
Issue identified with :
DELETE /*+ PARALLEL(pl) ROWID(pl) */ FROM AP_PURGE_INVOICE_LIST PL
WHERE PL.ROWID IN ( SELECT /*+ ORDERED PARALLEL(pl1) FULL(pl1) */
PL1.ROWID FROM AP_PURGE_INVOICE_LIST PL1, AP_INVOICES_ALL AI,
XLA_EVENTS XE, XLA_TRANSACTION_ENTITIES XTE, XLA_AE_HEADERS XEH,
AP_SYSTEM_PARAMETERS_ALL ASP WHERE XTE.ENTITY_CODE = 'AP_INVOICES'
AND NVL(XTE.SOURCE_ID_INT_1,-99) = PL1.INVOICE_ID AND
PL1.INVOICE_ID=AI.INVOICE_ID AND AI.ORG_ID=ASP.ORG_ID AND
ASP.SET_OF_BOOKS_ID=XTE.LEDGER_ID AND XTE.ENTITY_ID = XE.ENTITY_ID
AND XE.EVENT_ID = XEH.EVENT_ID AND XE.APPLICATION_ID = 200 AND
XEH.APPLICATION_ID = 200 AND XTE.APPLICATION_ID = 200 AND
(XEH.GL_TRANSFER_STATUS_CODE = 'N' OR ( XEH.LAST_UPDATE_DATE > :B1
))
UNION SELECT /*+ ORDERED PARALLEL(pl1) FULL(pl1) */ PL1.ROWID FROM
AP_PURGE_INVOICE_LIST PL1, XLA_EVENTS XE, XLA_TRANSACTION_ENTITIES
XTE, AP_INVOICE_PAYMENTS AIP, AP_SYSTEM_PARAMETERS_ALL ASP,
XLA_AE_HEADERS XEH WHERE XTE.ENTITY_CODE = 'AP_PAYMENTS' AND
NVL(XTE.SOURCE_ID_INT_1,-99) = AIP.CHECK_ID AND XTE.ENTITY_ID =
XE.ENTITY_ID AND ASP.SET_OF_BOOKS_ID=XTE.LEDGER_ID AND
AIP.ORG_ID=ASP.ORG_ID AND PL1.INVOICE_ID = AIP.INVOICE_ID AND
XE.EVENT_ID = XEH.EVENT_ID AND XE.APPLICATION_ID = 200 AND
XEH.APPLICATION_ID = 200 AND XTE.APPLICATION_ID = 200 AND
(XEH.GL_TRANSFER_STATUS_CODE = 'N' OR ( XEH.LAST_UPDATE_DATE > :B1
))
)
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