How to Add User Identification to a PeopleSoft Query?

Oracle Peoplesoft, How to Add User Identification to a PeopleSoft Query

Oracle Peoplesoft

In PeopleSoft (PS) query, it is possible to add the user name of the person who ran the query as a column.  To do so create an expression, substring the %Operator global variable, and use the expression as a field.

Example PeopleSoft Query Expression for UserID

SUBSTRING(%Operator,1,30)

Advertisements