Oracle HRMS Interview Questions – Part 2

By | August 6, 2014
Oracle Core HRMS Frequently Asked Interview Questions – Part 2

1. What are different ways of correction of mistakes in Payroll Run

·         Rollback
·         Retry
·         Reversal

For their detailed explanation, please refer the link below

2. How we can see the balances for an employee and how to adjust in case we need to do it?

When Balances are calculated wrong, or we have done some manual workaround and want the Balance to be updated for the same, we can opt for Balance adjustments.

 •To view Balance of any particular assignment, we can go to View -> Assignment Process Results -> Employee Assignment Processes
 •To Adjust Balances, we can go to the Assignment Record of the Employee, Others->Adjust Balance.
3. What are the minimum classifications to create a Business Group?

(i) Business Group
(ii) GRE/Legal Entity
(iii) HR Organization
4. What are the types of Element Entry?

There are four types
Normal Entry
Override Entry
Additional Entry
Adjustment Entry
–Additive Adjustment
–Replacement Adjustment
–Balance Adjustment
5. What variables a user table validation or Element Input Validation fast formula must contain?
When writing either type of formula, you must observe the following rules:
  • There must be one input value, of type text, and it must be called entry_value.
  • The formula must set and return a local variable giving the status of the validation (success or error). This variable must be called formula_status and have the value ‘s’ (success) or ‘e’ (error).
  • Optionally, the formula can also return a text variable giving an explanatory message. The returned message variable must be called formula_message and can contain any text. It can be returned with both successful and unsuccessful statuses.
The formula must not return any other results.
Example of Element Input Validation Formula


/* Formula Name: Salary Range */
     /* Formula Type: Element Input Validation */
     INPUTS ARE entry_value (text)
     IF TO_NUM(entry_value) > 200000
     THEN
     (
        formula_status = ‘e’
        formula_message = ‘Too much money . . . try again!’
     )
     ELSE
     (
        formula_status = ‘s’
        formula_message = ‘Fine’
     )
     RETURN formula_status, formula_message
Example of User Table Validation Formula

/* Formula Type: User Table Validation */
        INPUTS ARE entry_value (text)
        IF TO_NUMBER(entry_value) < 10.00 OR 
               TO_NUMBER(entry_value) > 20.00
        THEN
        (
           formula_status = 'e'
           formula_message = 'Error: Union A dues must be between
                              $10.00 and $20.00.'
        )
        ELSE
        (
           formula_status = 's'
           formula_message = ' '
        )
        RETURN formula_status, formula_message
6. What are two conditions for which you cannot make an element standard?

For an element, you cannot check standard check box if the element is nonrecurring or if Multiple Entries are allowed.

7. What are processing types of element?

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
1. Recurring: if an entry of this element applies in every period until the entry is ended
2. Non Recurring: if an entry applies in one pay period only.
8. 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.
9. What is the Element Link?
An Element Link makes an element eligible to be included in one’s payroll when processed. We can define eligibility criteria for elements to be part of payroll if it meets certain criteria. In other words, it identifies one or more assignment components that must be included in an employee’s assignment for them to be eligible.
Eligibility criteria comprises for following fields Organization, Job, Position, Grade, Location, Payroll etc.

10. What the Element can represent?

Earnings –> such as Salary, Wages & Bonuses
Benefits –> such as employee stock & pension plans
Non-Payroll items –> such as Expenses Absences from work
Voluntary and In-Voluntary deductions
Employer Taxes and other Liabilities.
Prev: Oracle HRMS Questions Part 1                                                                                                                 Next: Oracle HRMS Questions Part 3