Performance Issue when Opening an Existing Purchase Order (PO) Due to Data on REQ_VALADJ_P_FS
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms