Issue with eProcurement Requisition Component Load Time due to Field PO_OPRDEFN_VW.OPRDEFNDESC
(Doc ID 2552747.1)
Last updated on MARCH 09, 2020
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When the eProcurement page loads, the view PS_PO_OPRDEFN_VW is defined on the secondary page PV_REQ_MASSCHG_SEC has the field PO_OPRDEFN_VW.OPRDEFNDESC placed next to the PV_REQ_APLY_DEF.BUYER_ID field.
The field (PO_OPRDEFN_VW.OPRDEFNDESC) has the 'Display Only' and 'Invisible' flags selected so it cannot be seen. It is not marked as a related display, and because it is at level 0 there is no 'where' filter applied to the select. - The view itself will return 523,952 rows.
Steps to reproduce the issue:
1) Navigate to Main Menu > eProcurement
2) Click on Requisition
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