My Oracle Support Banner

PO Acknowledgement On Supplier Portal Times Out Due To Performance Issue (Doc ID 2570813.1)

Last updated on JULY 29, 2019

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms



When running the PO Acknowledgement process it will time out due to a specific SQL.


ERROR:

PS_SCPVNDUSR_VW_FL and hard coded a valid VENDOR_ID and VENDOR_SETID as criteria against PS_SCP_ACKPOLST_FL. This change will return data quickly.
SELECT PO_ID, PO_DT, DATETIME_DISP, DUE_DT, PO_STATUS, VENDOR_ID, BUSINESS_UNIT_PO, SETID, BUYER_ID, PYMNT_TERMS_CD, RECV_STATUS, BILL_LOCATION, VENDOR_SETID, VNDR_LOC, CHNG_ORD_BATCH, CURRENCY_CD, PO_POA_STATUS, POA_STATUS, PO_REF, PO_ACK_SOURCE FROM PS_SCP_ACKPOLST_FL WHERE EXISTS(SELECT 'X' FROM PS_SCPVNDUSR_VW_FL A WHERE PS_SCP_ACKPOLST_FL.VENDOR_ID=A.VENDOR_ID AND PS_SCP_ACKPOLST_FL.VENDOR_SETID=A.SETID AND A.OPRID ='oracle') AND DATETIME_DISP >= '2018-07-19-00.00.00.000000' ORDER BY PO_DT DESC, VENDOR_ID, BUSINESS_UNIT_PO, SETID
 


The issue can be reproduced at will with the following steps:
1.Log into Supplier Portal
2.Click on the Supplier Secure Home Page
3.Click on the Alerts tile
4.Click on the PO Acknowledgement tile.


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.