Oracle Apps HRMS Interview Questions

1. Important Tables in HRMS

Per_all_people_F,
per_person_types,
per_person_type_usages,
per_addresses,
per_contact_Relationships,
per_periods_of_service
Per_all_assignments_f,
per_pay_groups,
per_jobs,
per_job_Definitions,
per_grades,
per_grade_definitions,
hr_all_positions,
hr_all_position_definitions,
hr_all_locations,
pay_all_payrolls_F
pay_element_entry_values_F,
pay_element_entries_F,
pay_elements_links_F,
pay_element_types_F

2. Key Flexfields (KFFs) in HRMS

Job KFF,
Grade KFF,
People Group KFF,
Position KFF,
Cost Allocation KFF,
Comptence KFF

3.What are Date Track Tables?

every update in the Table, we will save the change in the form of a Record to provide the facility to find the information at any point of time.

These tables are post fixed by _F

4. What are secured Views?
The Views which do not have the _all to be said as secured views.

Per_all_people_F
per_people_f
per_all_assignemtns_f
per_assignments_f
pay_all_payrolls_F
per_payrolls_f

5. The differece between both secured views and non secured views is :

1.Secured views display information only for the current period

2.Unsecured views is used to get the information from the entire rows

6. APIs in HRMS

API are used in HR to insert the data into the Base tables. As its very secured system, the user does nothave the facility to copy the data directly into the Base tables.When we write the inbound interfaces / use WebAdI, the systems will use the APIs to store the data into system.The API are published by oracle with number of parameters.The different types of parameters are IN / INOUT / OUT.Of these parameters few are mandatory, with out which the process wont complete.Generally when we use API we give data for : Object Version Number, Effective Date, P_Validate

HR_EMOYEE_api ex: hr_employee_api.create_employee
hr_PERSON_api
hr_organization_api Ex: hr_organization_api.create_organization
hr_applicant_apI
hr_assignment_api

7. What are the reports which you have done in HR?

HR PAYROLL COSTING :

This report is used to display the information about the employees, the assignements which were given to the employees along with the payroll details including the Hours Paid, Salary, NI, Pension, Car Allowances and Other Allowances.

Jobs & Positions - Comparison

Definitions:

Job: Generic Title or Role within a Business Group, independent of any single organization. Required. Usually more specific if positions are not used.

Position: Specific occurrence of one job, fixed within an organization. Not required.

Jobs:

-- Required

-- Generic within Business Group

-- Independent of any single organization

-- Jobs can occur in many organizations

-- Holds Fair Labor Standards Act (FLSA) Code

-- Holds Equal Employment Opportunity (EEO) Work Category

-- Associated with Worker's Compensation Codes

Positions:

-- Optional

-- Specific occurrence of one job

-- Must be unique within an organization

-- Linked to an Organization, Job and Location

-- Shared with Other Applications (i.e. Purchasing)

-- Position Hierarchies control access to information (security)

Jobs and Positions - Similar Functionality:

· Valid Grades

· Evaluations

· Competencies

· Skills

· Work Choices

· Not Date Tracked

Some Advantages of Using Positions:

· Define jobs more specifically

· Reporting

· Views

· Position hierarchies for P.O. approvals

· Position hierarchies for security

· Occupancy View

· Probation Periods

· Standard Conditions & Working Hours

· Successor

· Position Control for Authorized Positions

· Competencies

· Requirements

· Recruitment

· Career Management

· Career Paths

· Job and Position Skills Matching Report

· Expands Oracle Training Administration

· Allows for eligibility through element linking

· Can view which position it reports to

· Simplifies Assignments by connecting and populating org, job and location

· Web security and online approvals

· ADE (Application Data Export) Position Hierarchy Diagrammer

· Grade relationships

· Evaluations

· Competencies - more specific to job

· Skills - more specific to job

· Work Choices - more specific to job

· Mass Moves: Organizations, Locations, Jobs, GRE's, Standard Conditions

· Succession Planning

· Positions are better (than Job and Supervisor) for P.O. approvals

You may NOT want to use positions in the case of:

· Re-organizations

· Concerned about increased maintenance

Positions for Governments and Unions:

Positions are typical of government/public sector agencies or those companies with a heavy blue collar or union influence. There are a few reasons for this:

1) Public sector agencies are position driven which means that they identify roles and skills based on the position, not the individual. The position carries with it a defined set of criteria that the person who is applying for the position must have, people are not brought into the agency

because they have special skills - they are hired to fill a role and they have the skills/knowledge/abilities that the role defines.

2) You can also have multiple "holders" or people filling one position and that does not necessarily mean job sharing.

3) Companies can define positions and employees on a one to one relationship, meaning each position can have only one employee assigned to it. Unless one is dealing with a small company, this can be an administrative nightmare. This might be used in an organization that wants to define purchasing authority on a per position/person basis (provided there is no costing of

positions so maintenance may remain relatively low).

4) Public sector agencies also practice encumbrance based accounting compared to private enterprise - meaning the funding or budget for departments can be determined ahead of time, providing flexibility in budgetary spending.

5) Positions are tracked and monitored as a result of this type of accounting for another reason as well. .

Typically in government agencies, funding for positions comes from multiple sources, such as 50% of positions X is paid for by the federal government and 50% is paid for by the state therefore, detailed tracking/costing is required on a per position basis.

Summary & Recommendations:

· If you are using Positions, you may wish to create a segment on the Position

Key Flexfield called, "Organization" to simplify the connection process.

· Positions work well to track "reports to" and to see which person occupies which position. Providing the Business Group (the primary organization) is fairly stable, positions make positional mass moves very easy to do. They are also a must for strict security needs and used for purchase order approvals. In using Positions, one must be careful to create generic job names, and make the position names specific..