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.

Example
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

Posted by Vijayakumar Janagiraman
Comments (4)
May 27th, 2008

Comments (4)

Pete H - March 28th, 2011

Thanks for the solution.

Xiaomin Wang - April 20th, 2010

It works. Thanks.

Johan - October 19th, 2009

Excellent solution ! Thanks !

Mohammed Hussain - November 1st, 2008

Hi I'm getting this following error while adding new values in the Invoice billing, after filling all the values , when i'm trying save it hits this error. SQL error.Stmt #:908 Error Position: 0 Return:8601 - [Microsoft][ODBC SQl Server Driver]String or Binary data would be truncated

Comments are closed.