Oracle HRMS Interview Questions – Part 3

By | September 27, 2014
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 effect 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
ZAP                                            : 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
For further explanation of this topic, please refer the link mentioned below
https://blogs.oracle.com/manojmadhusoodanan/entry/date_tracking_in_oracle_hrms
 
3. What is the 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 general role and 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 labor distribution.
Prev: Oracle HRMS Questions Part 2                                                                                                                 Next: Oracle HRMS Questions Part 4