R12: Performance Issues in Invoice Validation (Doc ID 1116383.1)

Last updated on MAY 26, 2017

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.
Executable:APPRVL - Invoice Validation
***Checked for relevance on 25-Dec-2015***

Symptoms

Invoice validation performance issue ..its taking a long time to complete.
From the trace, the time-consuming sql found to be:


SELECT DETAIL_TAX_DIST_ID,AID.SUMMARY_TAX_LINE_ID
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID, ZX_TRX_HEADERS_GT GT WHERE
AID.LINE_TYPE_LOOKUP_CODE IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV')
AND (AID.ACCOUNTING_EVENT_ID IS NOT NULL OR NVL(AID.MATCH_STATUS_FLAG,'N')
IN ('A','T') OR NVL(AID.POSTED_FLAG,'N') ='Y' OR NVL(AID.ENCUMBERED_FLAG,
'N') IN ('Y','D','W','X')) AND GT.APPLICATION_ID = :B5 AND GT.ENTITY_CODE =
:B4 AND GT.EVENT_CLASS_CODE IN (:B3 , :B2 , :B1 )
AND GT.TRX_ID =AID.INVOICE_ID AND
NOT EXISTS(SELECT 'Tax Distributions' FROM ZX_REC_NREC_DIST ZD
WHERE ZD.REC_NREC_TAX_DIST_ID = AID.DETAIL_TAX_DIST_ID
AND NVL(SELF_ASSESSED_FLAG, 'N') = 'N') AND ROWNUM=1

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