UNABLE TO GET SID, SPID ,FORMS USERNAME INFORMATIO

[mckoy2404]

We wanted to know the front end oracle applications users who are row
locking the data for more time (blocking locks).
And for this we are trying to join the fnd_logins, fnd_user, v$process and V$session views.

We find that for some reason we don't find the pid and spid columns to populating in fnd_logins.
We have turned the profile option Signon Audit to user and Audit Level to yes.

But inspite of that we are not able to find the information.
Please let us know how to find out.
In the past it used to work, but from 11.5.8 or so we think it does not work.

So please let us know how to find the Oracle Application username if we know the SID.

[admin]

Hope the following queries will help you and if still any query then let us know. thanks

select * from v$session where action like '%APPS USER%'

select * from v$session where sid = 93 << Action field provides the info of user/form

select a.session_id, b.OBJECT_NAME from v$locked_object a, dba_objects b
Where a.OBJECT_ID = b.OBJECT_ID

alter system kill session '93,368'