PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Query Manager: system automatically WHERE ( A.OPRID = 'PS')

edited May 19, 2017 5:03AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

Hi Expert

Currently, we are using Peoplesoft HCM 9.2 with PUM 18, PeopleTool 8.55.07.

When I create new query using record: PSUSEREMAIL, the system automatically (which I did not explicitly specify it) append this where clause: WHERE ( A.OPRID = 'PS') as shown below(note: PS is current login user id):

May I know how to get rid of ‘WHERE ( A.OPRID = 'PS')’ as I intend to query all result.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center