Oracle Forms (MOSC)

MOSC Banner

How do I find the Forms username in R12

edited Nov 6, 2012 9:29PM in Oracle Forms (MOSC) 2 commentsAnswered
I have a script from EBS 11 that returned the sid and username for forms sessions that were blocking themselves and other.  After the upgrade to R12 it the username is no longer valid.  What tables should I add to the query to find a username?

Here is the 11.5.7 code that was working:

       SELECT DISTINCT a.sid
            , a.id1  bboy
            , vs.username
            , vs.machine
            , vs.event
            , vs.action
            , vs.status
            , vs.module
            , to_char(to_date(vs.seconds_in_wait,'sssss'), 'HH24:MI:SS') last_call
            , fu.user_name
            , fu.description
         FROM v$lock a
            , v$lock b
            , v$session vs

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