Friday 13 July 2007

To find out the users connected to Oracle Applications Release 11i:

select distinct raf.user_name User_Name,raf.RESPONSIBILITY_KEY Responsibility
from fnd_user raf,
fnd_responsibility raf, icx_sessions hussain
where raf.user_id = hussain.user_id AND
raf.responsibility_id = hussain.responsibility_id AND
hussain.disabled_flag='N' AND
hussain.responsibility_id is not null AND
hussain.last_connect like sysdate;

No comments:

Profile - Oracle 11i AppsDBA
Over 7 years of experience as an Oracle Applications DBA managing Oracle Public Sector HRMS 11.5.10 and Oracle Financials 11i in Unix and Windows NT environments. Strong skills and experience with installing, patching, cloning and troubleshooting various Oracle E-Business Suite products in Oracle database 9i and 10g. Proactive in the different phases of architecture design, development, testing, maintenance, performance enhancement and postproduction support. Currently working as Oracle Application DBA at Warwickshire County Council.

------------------------------------------------------------------------------------------------------------------------------