How to Find Active Employees, Users and Responsibilities

May 17, 2006 on 11:01 am | by Marian Crkon | In How To Guides | Enter Comments | Print Print | Email Email

Here is a query you may find useful when maintainig users, doing SOX 404 controls audit, creating new users for existing employees in Oracle eBusiness Applications . Use it to find active employees, contingent workers and their user accounts and responsibilities. You will need to know the person_type_id for employees and contingent workers.

Employees, Users and Responsibilities Query

No Comments yet »

RSS feed for comments on this post. TrackBack URI

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^