My Oracle Support Banner

AP Invoice Is Taking To Much In Case Of Matching, Validation And Initiation After RUP 11 Patch Application (Doc ID 2423236.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financials for India - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, GST Payables

ACTUAL BEHAVIOR
---------------
AP invoice is taking too much in case of matching, validation and Initiation

AP invoice is taking to much in case of matching, validation and Initiation after apply RUP-11 and RUP-11 May consolidation patch

found that following are the 3 most expensive queries.

A) DELETE FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
WHERE
AIDA.INVOICE_ID = :B2 AND EXISTS (SELECT 'X' FROM JAI_REC_NREC_DIST RND
 WHERE RND.TRX_ID = :B2 AND RND.SOURCE_TAX_LINE_NUM =
 AIDA.INVOICE_LINE_NUMBER AND RND.APPLICATION_ID = 200 AND
 RND.EVENT_CLASS_CODE = :B4 AND RND.ENTITY_CODE = :B3 AND NOT EXISTS (SELECT
 'X' FROM JAI_REC_NREC_DIST JRN WHERE JRN.TRX_ID = :B2 AND
 JRN.APPLICATION_ID = 200 AND JRN.EVENT_CLASS_CODE = :B4 AND JRN.ENTITY_CODE
 = :B3 AND (JRN.TRX_LINE_NUMBER = RND.TRX_LINE_NUMBER))) AND
 LINE_TYPE_LOOKUP_CODE = :B1


2) DELETE FROM AP_INVOICE_LINES_ALL AILA
WHERE
 AILA.INVOICE_ID = :B2 AND EXISTS (SELECT 'X' FROM JAI_REC_NREC_DIST RND
  WHERE RND.TRX_ID = :B2 AND RND.APPLICATION_ID = 200 AND
  RND.EVENT_CLASS_CODE = :B4 AND RND.ENTITY_CODE = :B3 AND
  RND.SOURCE_TAX_LINE_NUM = AILA.LINE_NUMBER AND NOT EXISTS (SELECT 'X' FROM
  AP_INVOICE_LINES_ALL AILA WHERE AILA.INVOICE_ID = :B2 AND AILA.LINE_NUMBER
=
   RND.TRX_LINE_NUMBER)) AND LINE_TYPE_LOOKUP_CODE = :B1

3) DELETE FROM JAI_REC_NREC_DIST RND
WHERE
 RND.TRX_ID = :B3 AND RND.APPLICATION_ID = 200 AND RND.EVENT_CLASS_CODE = :B2

  AND RND.ENTITY_CODE = :B1 AND NOT EXISTS (SELECT LINE_NUMBER FROM
  AP_INVOICE_LINES_ALL AILA WHERE AILA.INVOICE_ID = :B3 AND AILA.LINE_NUMBER
=
   RND.TRX_LINE_NUMBER)


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot make vendor payment on time.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.