My Oracle Support Banner

EAP: Performance issue with Document Tolerance, FS_DOC_TOL, process (Doc ID 621693.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, AP, 8.4 SP1, 8.8



This document was previously published as Customer Connection Solution 200762649

Symptoms


Performance issue with Document Tolerance, FS_DOC_TOL , process.  Process is taking 20 minutes for 49 rows for the given SQL below.  

FS_DOC_TOL.STATV000.Step06) (SQL)
INSERT INTO PS_DOTL_VLIQ_T (PROCESS_INSTANCE , TXN_CURRENCY_CD ,
BUSINESS_UNIT_PO , PO_ID , LINE_NBR , SCHED_NBR , PO_DIST_LINE_NUM ,
BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM , DISTRIB_LINE_NUM , INVOICE_DT
, LIQUIDATED_AMT) SELECT VD.PROCESS_INSTANCE , DS.TXN_CURRENCY_CD ,
DS.BUSINESS_UNIT_PO , DS.PO_ID , DS.LINE_NBR , DS.SCHED_NBR ,
DS.PO_DIST_LINE_NUM , MAX(DS.BUSINESS_UNIT) , MAX(DS.VOUCHER_ID) ,
MAX(DS.VOUCHER_LINE_NUM) , MAX(DS.DISTRIB_LINE_NUM) , MAX(VD.INVOICE_DT) ,
SUM(DS.FOREIGN_AMOUNT - DS.MISC_AMT_NP - DS.FREIGHT_AMT_NP - DS.SALETX_AMT_NP
- DS.USETAX_AMT_NP - DS.VAT_NR_AMT_NP - DS.VAT_RCVRY_AMT) FROM PS_DOTL_VDST_T
VD , PS_DISTRIB_LINE DS , PS_VOUCHER VCH WHERE VD.PROCESS_INSTANCE = 10275
AND VD.BUSINESS_UNIT_PO = DS.BUSINESS_UNIT_PO AND VD.PO_ID = DS.PO_ID AND
VD.LINE_NBR = DS.LINE_NBR AND VD.SCHED_NBR = DS.SCHED_NBR AND
VD.PO_DIST_LINE_NUM = DS.PO_DIST_LINE_NUM AND DS.BUSINESS_UNIT =
VCH.BUSINESS_UNIT AND DS.VOUCHER_ID = VCH.VOUCHER_ID AND VCH.ENTRY_STATUS <>
'X' AND VCH.VOUCHER_STYLE IN ( 'ADJ', 'REG', 'CORR') GROUP BY
VD.PROCESS_INSTANCE , DS.TXN_CURRENCY_CD , DS.BUSINESS_UNIT_PO , DS.PO_ID ,
DS.LINE_NBR , DS.SCHED_NBR , DS.PO_DIST_LINE_NUM
/
-- Row(s) affected: 49

-- 20.54.33 .....(FS_DOC_TOL.STATV000.Step06A) (Call Section FS_DOC_TOL.STATV300)

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.