Blog Network Home > PeopleSoft FieldBook > PeopleSoft > OPRID field in PS Query

OPRID field in PS Query

by Vijayakumar Janagiraman on May 27, 2008 in PeopleSoft

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

You might want to read these awesome related posts


{ 4 comments }

1 Mohammed Hussain November 1, 2008 at 10:43 am

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

2 Johan October 19, 2009 at 11:24 pm

Excellent solution ! Thanks !

3 Xiaomin Wang April 20, 2010 at 9:03 am

It works. Thanks.

4 Pete H March 28, 2011 at 2:20 pm

Thanks for the solution.

Comments on this entry are closed.