OPRID field in PS Query
When you want to select an OPRID field in PS Query, the PS Query will add the User Id in the where condition of the query by default when the OPRID field is an Key field in main table. It is not an expression or criteria in PS query, hence, it cannot be manually removed from PS Query. PeopleSoft performs this action in order to incorporate the Row level security access in Reporting data.
To overcome this Row level security setup, the Record Field property of OPRID field in the base record (from which the OPRID field is selected in PS Query) needs to be set as List Box item. This setup will remove the OPRID field condition from SQL.
OPRID field in‘UG_BDGBAL_OPR_V’ view with out List Box item property setup
Adding the field in PS Query
Setting the OPRID field as List Box item in Record Field properties