OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to find forms Username (R12 , Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to find forms Username [message #531561]

Wed, 16 November 2011 15:16

saagar
Messages: 79
Registered: December 2007

Member

Hi

i need to find PID and also its username for eg its forms username and the person who is using which forms and (MaCHINE NAME).

Is there any query to find out which person is access which forms from Oracle E busniess suite R12 and for how much time

Regards

[Updated on: Wed, 16 November 2011 15:20]

Report message to a moderator

Re: Need to find forms Username [message #531562 is a reply to message #531561]

Wed, 16 November 2011 15:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

USER variable might be what you are looking for. Or, another option is to use GET_APPLICATION_PROPERTY with its USERNAME property (which returns name of the current operator).

No idea about the rest of your questions.

Report message to a moderator

Re: Need to find forms Username [message #531569 is a reply to message #531562]

Wed, 16 November 2011 15:45

saagar
Messages: 79
Registered: December 2007

Member

hi
thanks for the reply

well i am looking for a script that returns me frmweb session from top activity and also get its username and which forms he is acessising ...

if i get frmweb activity from top command and get a script which i gives the input of the PID of frmweb it should return me USERNAME , os user , which forms he is accesing

Just like what OEM does

Regards

Report message to a moderator

Re: Need to find forms Username [message #534920 is a reply to message #531569]

Sat, 10 December 2011 03:51

amit_surana
Messages: 4
Registered: November 2011
Location: India

Junior Member

Use the below two tables, you will be able to get all the details..

FND_LOGIN_RESP_FORMS
FND_LOGINS

You will be required to join more tables regarding the Form and resposibility name from the id's obtained from the above tables.

Regards,
Amit

[Updated on: Sat, 10 December 2011 07:47]

Report message to a moderator

Re: Need to find forms Username [message #552401 is a reply to message #534920]

Wed, 25 April 2012 09:04

saagar
Messages: 79
Registered: December 2007

Member

hi

tried to joined those tables but no luck
is there any query please let me know

Cheers

Report message to a moderator

Previous Topic:	Need to make my forms Read Only
Next Topic:	How to locate user_id in R12

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 18:21:53 CST 2025