When you create a new user using the oracle screen (User > Define) you cannot see any other users accounts, as such a standard is not obvious.
Some inconsistencies can be quite visible, e.g. the user’s description is show at the top of the self service welcome screen...
Welcome – John Doe
It is not a good for your users to see
Welcome - Annoying user
Back in the early days of Oracle E-Business Suite (The then Oracle Financials) when the user description was not used, we used to add all sorts of descriptions to describe the user as a warning for other Applications Administrators. With the advent of Self service a clean up was required.
So in some cases you end up with a mess. This is a simple report you can run that has a huge value:
SELECT report_headings.report_date, report_headings.sid_name, fu.user_id, substr(fu.user_name, 1, 40) user_name, substr(fu.description, 1, 40) description, fu.email_address, to_char(fu.last_logon_date, 'DD-Mon-YY HH24:MI') last_logon_date, trunc((sysdate - fu.last_logon_date)) days_since_last_connect FROM applsys.fnd_user fu, ( SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, vd.name sid_name FROM v$database vd ) report_headings WHERE (fu.end_date IS NULL OR fu.end_date > SYSDATE ) ORDER by fu.user_nameI have provided a report (Active Accounts) that lists all the currently active accounts. The report can be found in the free reports page .
What you are looking for is:
Remember you can change a user account name (See tips page)
If you don’t have a standard then create one – management love standards
Want to know more? User Account Management is something many of sites could do a lot better so I have now devoted PAMtutorials to the subject so why not check this out as well!
Last update: May 2009