Beginner's Guide: System Administration in Oracle HRMS*

The tasks in System Administration responsibility can be grouped under following activities:

1. DBA Activity – Installation and System Maintenance
2. Security – User Account Administration
3. Implementation – Functional Setups

DBA Related Activity includes (This is not handled by Oracle HRMS Consultant)

1. installation of the Oracle Application on server
2. monitoring the instance by running alerts and reports
3. providing access
4. applying oracle specified patches
5. configuring system profiles
6. Enabling audit trails

Security Related Activities includes

- Creating users, menu’s and responsibilities
- Attaching security profiles to the user, responsibility, organization or at site level.

Before creating users, responsibility and security profiles it is important to understand the following
o Understanding the hierarchy of the organization
o User grouping depending on the access level and role played that needs to be provided.
o Creating the access of functions, menu’s, data based on organization and role.
o Co-relating responsibilities with the application users
o Appling restrictions to data based on organization, payroll, position, supervisor.

Functional Activities includes designing and implementing the business requirements into the application. Some functional users also do the mapping for the technical reports and interfaces to be developed.

1. Creating Value Sets
2. Defining Flexfields – Key as well as Descriptive
3. Attaching Validations to the flexfields
4. Printer Management
5. Workflow Administration

Once the installation is done and system is in place and DBA has created a user id with access to System Administration Responsibility, then the job of HRMS functional consultant starts. Of course before even touching the application it is important to understand the requirements from the user and have the documents in place as much as possible. To have some draft ready to start with is really helpful. Also have a roadmap ready for organization and flexfield definition especially the ones which will be used by other modules too, like cost allocation flexfield is mapped with financials chart of accounts.

*user is expected to know and understand the basic navigation and terminologies of Oracle. Also please use Oracle Implementation Guides for complete reference.