Oracle HRMS Interview Questions and Answers

In oracle HRMS there are so many modules like Core HR, Payroll, Self Service HR, Oracle learning management, iRecruitment, Time and Labour, Compensation Work bench, Oracle Advanced Benefits, Performance Management System etc., Core HR and System Administrator are the Heart of Oracle HRMS.

All basic set ups will do in Core HR with the help of System Administrator.

In system administrator we will create all the Users and Responsibilities, Flex fields, Profile values etc., In core HR we will create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, position Hierarchy, we will create all the employees also. These are the Basic setups in HRMS.

• Core HR Payroll (Includes Standard Benefits)
• Advanced Benefits (OAB)
• Talent Management (Performance Management)
• Oracle Time and Labor (OTL)
• Oracle Learning Management (OLM)
• iRecruitment Self Services HR (SSHR)

Job is general one, whereas Position is specific term to its role and responsibilities.

JOB: MANAGER (generic term), SOFTWARE DEVELOPER

POSITION: Finance Manager, HR Manager, Junior SOFTWARE ENGINEER, (this is position which is specific to the role to be played.

• Business Group
• GRE/legal Entity
• HR Organization

• Value sets
• Key flex fields
• Location

• Job KFF,
• Grade KFF,
• People Group KFF,
• Position KFF,
• Cost Allocation KFF,
• Competence KFF.

There are 6 Core Flex fields are there

• Job
• Position
• Grade
• Competency
• People Group
• Cost Allocation

If we want to assign the employee information to a Business Group, then we need to have HR organization classification under a business group

• Extra person information
• Assignment extra information
• Extra location information
• Extra position information
• Extra job information
• Organization developer DF

• per_all_people_f: This table will provide us the very basic information about the employee. The very data from the first screen we see when we open the ‘People -> Enter and Maintain’ form goes into this table.
• per_all_assignments_f : This table will store all the information which is been entered in the employee assignment form.
• per_addresses : This table will store all the information which is been entered in the employee address form.
• per_pay_proposals : This table will store all the information which is been entered in the employee salary form.
• per_person_types_tl : This table is used to find the type of the employee. This table is linked with the per_all_people_f with the person_type_id to find out the type of person.
• per_jobs_tl : This table will contain the various types of JOBS in oracle. This table is being linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
• per_grades_tl : This table will contain the various types of GRADES in oracle. This table is being linked with the per_all_assignments_f table to retrieve the correct grade name from the employee.
• hr_locations_all : This table will contain the various LOCATIONS in oracle. This table is being linked with the per_all_assignments_f table to retrieve the correct location name from the employee.
• pay_all_payrolls_f : This table will contain the various types of PAYROLLS in oracle. This table is being linked with the per_all_assignments_f table to retrieve the correct payroll name from the employee.
• per_pay_bases : This table will contain the various types of PAY BASES in oracle. This table is being linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.
• per_assignment_status_types_tl : This table will contain the various types of assignment types in oracle. The assignment types generally would be ‘Active Assignment’ etc.. This table is being linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
• per_person_type_usages_f : This table will store the correct person type of the particluar employee. We should never depend on the person type present in the per_all_people_f table. Instead we need to link the person_id with this table and get the correct person type.

Elements are nothing but the components of the salary.

For Example: Basic Salary, House Allowance, Transport Earning, Bonus, Loan Recovery etc.

There are 2 types of Processing

• Recurring: if an entry of this element applies in every period until the entry is ended
• Non-Recurring: if an entry applies in one pay period only.

• Regular pay
• Quick pay

Retro Pay is a payment made for an event of past. Retro Pay stands for some old Payment due for the employee. This is used for Back Dated Salary Increments. There are four ways.

• Retro Pay by Run
• Retro Pay by Aggregate
• Retro Pay by Element
• Enhanced

Oracle Reports, Discoverer, Standard seeded reports, View/List option of the menu – output could be exported in word/excel, WebADI etc.

• Absences Report
• Assignment Status Report
• Current and Projected Progression Point Values Report
• Element Link Details Report
• Employee Increment Results Report
• Employee Movements Report
• Employee Summary Report
• Full Personal Details Report

• Job
• Position
• Grade
• People Group
• Cost Allocation
• Competence
• Bank Details
• Soft Coded
• Personal Analysis crieteria
• Collective Agreement

• It is a flexible area for holding user defined assignment data
• Data can be used for grouping sets of assignment together
• People group can be used for element eligibility
• This information is used by the payroll run
• The data will be held in PAY_PEOPLE_GROUPS.
• Group_name field holds the concatenation of segment data.

Retro Pay – Payment for any previous cycle in the current payroll run

Advance Pay – Payment for any future cycle/advance in the current payroll run

Absence Pay – Payment for leaves like sick leave, maternity leave, annual leave and other statutory leaves

Payroll Name, Period Type and Start Date

Actual Termination: For a nonrecurring element, select Actual Termination if you want the entries to close down at the end of the pay period in which the employee leaves.

Final Close: if you want the entries to stay open beyond the employee’s leaving date so that you can continue to pay the employee.

The Last Standard Process date defaults to the last day of the pay period in which the employee is terminated, but you can set it to a later period when you terminate an

employee.

Costing: Recording the costs of an assignment for accounting or reporting purposes. Using Oracle Payroll, you can calculate and transfer costing information to your general ledger and into systems for project management or labor distribution.

Costing types are:

• Fixed costed
• Costed
• Distributed

• Element Entry => Highest
• Assignment => Second Highest
• Organization => Third Highest
• Element Link => Fourth Highest
• Payroll => Fifth Highest