Slow Performance on eProcurement Requisitions Page (RQSTR_RCTORD_VW) (Doc ID 2052862.1)

Last updated on OCTOBER 21, 2015

Applies to:

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

Symptoms

Slow Performance on ePro Requisitions Page (RQSTR_RCTORD_VW)

Symptoms
1) Navigation: eProcurement > Requisitions
2) Loading the ePro Requisitions page takes a very long time. Sometimes over 10 minutes.

 We have narrowed down the issue to a query against RQSTR_RCTORD_VW.
SELECT
FILL.REQUESTOR_ID
,FILL.ITM_SETID
,FILL.INV_ITEM_ID
,FILL.DESCR254_MIXED
,FILL.CATEGORY_ID
,FILL.VENDOR_SETID
,FILL.VENDOR_ID
,FILL.VNDR_LOC
,FILL.LN_TYPE
,FILL.MFG_ID
,FILL.ITM_ID_VNDR
,FILL.MFG_ITM_ID
,FILL.UNIT_OF_MEASURE
,FILL.PRICE_REQ
,FILL.CURRENCY_CD
,FILL.BUSINESS_UNIT
,FILL.REQ_ID
,FILL.LINE_NBR
,FILL.SERVICE_METHOD
,FILL.ROLE_TYPE
,FILL.PROJ_ROLE
,FILL.LAST_DTTM_UPDATE
FROM PS_RQSTR_RCTORD_VW FILL
where requestor_id = 'FAR'
ORDER BY LAST_DTTM_UPDATE DESC



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