Who is connected to my apps?

Who is connected to my apps?

Sometimes the apps dba needs to know who is connecting to apps right now and what responsibly are they using, user id, client ip address and other info.

We can get that up and running in simple steps.

-set the profile option (Sign-On:Audit Level) value to form. By default it is set to none.

-run the concurrent program (OAM Applications Dashboard Collection) this concurrent will fill some tables like fnd_oam_forms_rti with important data like IP address of the client, time, …etc.

-go to Oracle applications manager (OAM) and from the drop down menu choose (forms sessions) this will give you users that are connected to your apps with their responsibilities, user id, time, and which from are they using and a lot of other info.

-To get the ip address of those users you have to click on the (rti pid) filed. This will give you other screen with the information needed.

p.s kindly note that some OS like hp-ux have bug and it will show the ip address like rubbish and it need a patch to be applied in order to get the correct ip address displied.

fadi hasweh
Oracle is not Magic, it just takes years of experience