The Feature
How to Find Active Employees, Users and Responsibilities
May 17, 2006 on 11:01 am | by Marian Crkon | In How To Guides | |
Print
| 
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
Recent Comments
- Marian: CEO needs to have a supervisor...
- Frapacino: What is the workaround for this because i am also stuck with iExpense going into Pending System...
- Marian: Angela, The attachment feature is pretty basic. You can add attachments to expense reports at the header...
- Angela: Hello Marian, Great documentation as well as informative comments and discussions. We use iExpense but not...
- Marian: Sorry Peter, I haven't had a chance to interface Visa transactions yet. Did you open an Oracle SR? What did...
Popular Topics
-
Analysis
Assets
Billing
BI Publisher
Blogs
Calendar
COLLABORATE
Conversations
Conversion
Costing
DataLoad
EBS
Experience
Financials
Flexfields
FSG
Fun
Fusion
GL
Go Live
Guides
HRMS
Ideas and Opinions
iExpenses
Implementation
Integration
Intercompany
Linux
MOAC
OAUG
OpenWorld
Oracle
OTL
Partners
Payables
Payroll
Press
Projects
Purchasing
R12
Receivables
Reviews
SQL
Support
SysAdmin
Training
Usability
WebADI
Workflow
YouTube
Most Popular
- How to Use XML Publisher to Generate Oracle Reports in Excel and PDF (71,576 Views)
- Application Blogs I Read and Why You Should Too (43,628 Views)
- How To Set Up Oracle iExpenses (38,699 Views)
- New Features in Oracle HRMS Release 12 (35,123 Views)
- Nobody Knows Oracle Projects, Right? (26,656 Views)
- Go-Live Checklist for Oracle Financials (22,616 Views)
- Sample DataLoad Templates for Oracle Financials (22,180 Views)
- Oracle Internet Expenses Has Grown Up (19,607 Views)
- Sample Operational Analysis Questionnaires for Oracle Financials and Projects (19,510 Views)
- 10 Questions for Mark Rittman (18,406 Views)
Most Recent
- How To Set Flexible PO Approval Limits
- Let’s Make Entry of Project-Related Purchasing Documents Easier!
- Sample DataLoad Templates for Oracle Financials
- Confused About Setting Up MOAC in R12?
- Take the Oracle Financials Product Strategy Survey
- OAUG Invites You to Present at COLLABORATE11 in Orlando
- How To Capitalize Legacy CIP Costs in Oracle Projects
- Who Knew? YouTube Becoming a New Oracle Training Resource?
- Projects, Templates Form Does Not Let You Update More Than 25 Records
- Check Out New User Interface Applications from Project Partners
Categories:
Quick Oracle Links
Disclaimer
Opinions expressed on this site are entirely of their authors and do not neccessarily reflect the position of Oracle, its partners and customers, or any other organization.
Oracle Applications and other Oracle products and services mentioned on this site are trademarks of Oracle Corporation, and use of these product names does not imply any association with Oracle.
Any tips or advice provided on this site may not apply to your own particular circumstances and no warranty is offered on their use.
This site looks its best if you
Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds.
Valid XHTML and CSS. ^Top^