Oracle Transportation Management (MOSC)

MOSC Banner

What is the variable I could use that contains the GL_USER_GID that is signed on

edited Nov 12, 2013 2:26AM in Oracle Transportation Management (MOSC) 2 commentsAnswered ✓
I want to create a Saved Query that references the value of who is signed on.  By this I mean, is there a variable that I can use in an SQL statement that will contain the User ID of the person signed on.
If I sign on, my User ID appears in the upper right hand corner as PARKER.DR55069.

If I want to create a Saved Query to references that value, what variable do I use.

For example:

Select VALUE from USER_APPDATA where GL_USER_GID = {the value from the upper right hand corner of the screen, and in my case PARKER.DR55069}

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