Count the total Active concurrent users in Oracle HRMS

CuteDBA
CuteDBA used Ask the Experts™
on
Hi Experts,

I am wondering on how to calculate the number of active concurrent users in each of Oracle E-Business suite HRMS modules like HR Intelligence, Human Resources, Self-Service Human Resources and Payroll. Is there any kindl of tools I can use or kindly advice on how to calculate.

Regards,
C.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Commented:
is it something like this you are looking for:

Signon Audit Concurrent Requests Report
Use this report to view information about who is requesting what concurrent requests
and from which responsibilities and forms.

http://download.oracle.com/docs/cd/B15436_01/current/acrobat/115sasg.pdf

else it looks like you are into do some select against the database it could be this table: APPLSYS.FND_CONCURRENT_PROGRAMS

http://etrm.oracle.com/pls/trm1157/etrm_pnav.show_object?c_name=FND_CONCURRENT_PROGRAMS&c_owner=APPLSYS&c_type=TABLE

for more application server data have a look at this page:
http://etrm.oracle.com/pls/trm1157/etrm_fndnav.ls_object

But i think you need to have auditing turned on to have data in teh fnd_ tables

Author

Commented:
Thank you very much. If you can tell the deference between the Applications Manager users per module summary that will be awesome.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial