PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

trying to run PSQUERY against table that has OPRID in it and getting odd results

edited Feb 20, 2020 5:42AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered

When I run a query against a table that has OPRID as a column, it is adding this to the query criteria, which in turn only gives me one row of data.

The Table has

ORG_NAME         NOT NULL VARCHAR2(30)

OPRID            NOT NULL VARCHAR2(30)

EMPLID           NOT NULL VARCHAR2(11)

when I add this record to a query, it adds the criteria "where OPRID = 'myoprid'

so I am getting only one row.  I need to get all rows from this table, and am not understanding what is causing this to happen. 

There is no security record tied to this table.

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