Performance Issue Due to Usage Of ScrollFlush() In PV_PO_ITM_STG_V.PO_STG_ID.SavePostChange

(Doc ID 2372863.1)

Last updated on MARCH 13, 2018

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Users are facing performance issue when they are doing supplier search. Found issue is with a ScrollFlush() in the PV_PO_ITM_STG_V.PO_STG_ID.SavePostChange PeopleCode. We looked at the code and found two instance where the ScrollFlush() exists, both of which come in the delivered code.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms