Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to find forms Username (R12 , Linux)
icon9.gif  Need to find forms Username [message #531561] Wed, 16 November 2011 15:16 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 19315
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.
Re: Need to find forms Username [message #531569 is a reply to message #531562] Wed, 16 November 2011 15:45 Go to previous messageGo to next message
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

Re: Need to find forms Username [message #534920 is a reply to message #531569] Sat, 10 December 2011 03:51 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Need to make my forms Read Only
Next Topic: How to locate user_id in R12
Goto Forum:
  


Current Time: Sat Jul 26 08:44:42 CDT 2014

Total time taken to generate the page: 0.08877 seconds