My Oracle Support Banner

Performance Issue on Approve Change Request Component (Doc ID 3057676.1)

Last updated on NOVEMBER 05, 2024

Applies to:

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

Symptoms

Performance Issue on Approve Change Request Component.

Performance Issue on component SUP_OB_MNG_APR when existing around 40K Supplier Change Request in PS_SCR_RSNCD.

The below SQL is fetching all the rows into buffer even without taking any action yet on the component.

SELECT SCR_ID, REASON_SETID, REASON_TYPE, REASON_CD, TO_CHAR(CAST((DATETIME_ADDED) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), USERID, EMAILID, COMMENTS, SCR_RSCD_TO_EDITOR FROM PS_SCR_RSNCD
 

The issue can be reproduced at will with the following steps:

1. Login as SCR approver
2. Navigate to Suppliers > Supplier Change Request > Approve Change Request component

 

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.