HR and PAYROLL Interview Preparation - Part II

1. What is Date Track concept in Oracle HRMS?

Oracle HRMS has a date track feature which enables to maintain past, present and future state of data. It enables to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION

All date tracked tables end with _F. In data tracked tables, Oracle identifies the validity of record with ‘effective date’ columns (effective_start_date and effective_end_date)

2. What are Date Track Modes available in Oracle HRMS

To maintain employee data effectively Oracle HCM is using a mechanism called date tracking. The main motive behind the date track mode is to maintain past, present and future data effectively.

Update Date Track Modes

The various update date track modes are:

CORRECTION: Over writes the data. No history will maintain.

UPDATE: Keeps the history and new change will affect as of effective date

UPDATE_CHANGE_INSERT: Inserts the record and preserves the future

UPDATE_OVERRIDE: Inserts the record and overrides the future

Delete Date Track Modes

The various delete date track modes are:

PURGE: wipes all records

DELETE: Deletes current record

FUTURE_CHANGE: Deletes current and future changes.

DELETE_NEXT_CHANGE: Deletes next change

Options appearing on Application Level

When you actually execute a scenario and try to delete a record, following options appear on screen

·        End Date

·        Remove Next Change

·        Remove All Schedules Changes

·        Purge

3. What is a payroll element?

Elements are components of salary e.g. basic salary, housing allowance, loan to deducted, provident fund etc. There are different types of elements like earning, deduction, information etc. In Payroll, elements are processed to prepare an employee’s payroll amount

4. How can we add a new input value to an existing Element?

We can add an additional input values to an existing Element if the element has not been processed in a Payroll run and the Effective data is the same date of creation of the Element

5. What are termination rules of an element?

Termination Rules of an Element:

• 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

6. What is the difference between a Job and a Position?

Job is a general role whereas position is specific responsibility of that role. For example, there could be several people in our company working on the job of manager but every manager would have unique position and role to perform. Persons with job Manager will be working on different positions like accounts manager, finance manager, audit manager etc.

7. What are important Key Flex-Fields (KFFs) in Oracle HRMS?

·        Job

·        Grade

·        Position

·        People Group

·        Cost Allocation

·        Competence

8. What are main tables in Oracle HRMS?

·         per_all_people_f,

·         per_all_assignments_f

·         per_person_types,

·         per_person_type_usages,

·         per_addresses,

·         per_all_assignments_f,

·         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_entries_f,

·         pay_elements_links_f,

9. Can a job have multiple positions? 

Yes a job can have multiple positions. For example, there could be several people in our company working on the job of manager but every manager would have unique position and role to perform

10. What is costing?

Costing is a way to calculate how much we are incurring for an employee with respect to any project/ organization or department. There are five different levels where we can configure costing in oracle HRMS. Using Oracle Payroll, we can calculate and transfer costing information to general ledger and into systems for project management or labour distribution

PREVIOUS POST || NEXT POST