My Oracle Support Banner

EAP8.4SP1: Document Status Inquiry performance issue (Doc ID 619398.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise FIN Cash Management Argentina - Version 8.9 and later
Information in this document applies to any platform.

Information in this document applies to any platform.



SPECIFIC TO:   Enterprise, Payables, 8.4 SP1



This document was previously published as Customer Connection Solution 200748302

Symptoms


There is a performance issue on the Document Status Inquiry, at Payments Home, Document Status Inquiry.  The SQL behind the view does a full table scan on the voucher table, and the page gets timed out.
This is the long-running SQL that times out when attempting to do a Payment Document Status inquiry:

SELECT  SETID, BUSINESS_UNIT, BANK_CD, BANK_ACCT_KEY, PRCR_DOC_ID,  
         PRCR_DOC_TYPE, CB_SELECT_PO, CURRENCY_CD, CURRENCY_CD_BASE,  
         DOCSTAT_DATE, DESCR, STATUS_FIELD, VENDOR_ID, VENDOR_SETID,  
         VNDR_LOC                                                       
 FROM    PS_PRCR_DS_VC_SRCH A                                          
 WHERE   EXISTS                                                         
        (SELECT  'X'                                                     
         FROM    PS_PYMNT_VCHR_XREF E                                  
         WHERE   A.BUSINESS_UNIT = E.BUSINESS_UNIT                     
           AND   A.PRCR_DOC_ID = E.VOUCHER_ID                         
           AND   E.BANK_SETID = ?                                      
            AND   E.BANK_CD = ?                                          
            AND   E.BANK_ACCT_KEY = ?                                    
            AND   E.PYMNT_ID = ?                                        
         )                                                                
  ORDER   BY SETID, BUSINESS_UNIT, BANK_CD, BANK_ACCT_KEY, PRCR_DOC_ID,
          PRCR_DOC_TYPE                                                   
  FOR     FETCH ONLY

Changes

 

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