Performance Issue when Opening an Existing Purchase Order (PO) Due to Data on REQ_VALADJ_P_FS (Doc ID 1612237.1)

Last updated on DECEMBER 01, 2016

Applies to:

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

Symptoms

Degradation of performance impacting the PURCHASE_ORDER Component.

 

1. When the number of rows grows significantly for PS_REQ_VALADJ_P_FS (Base Table - PS_REQ_VAL_ADJ) - starts hanging when trying to open an existing PO or trying to add a new PO.

2. Navigating to the Requisition Selection page - Page times out.

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