HR and PAYROLL Interview Preparation - Part I

In the next few posts I’ll post a collection of Oracle HRMS related questions which might prove useful for interview preparation

1. Can you call pl/sql package functions from within a Fast Formula?

Yes, It is done through Define Function screen in HR. In this screen we can register the pl/sql as “External Function” and reference it in Fast formula definition

2. If we want to pass a parameter PAYROLL_ID to this external pl/sql Function, how can we do it?

The “Define Function” screen has a button named “Context Usage”. It contains all those context variables that are available for that formula type; you can refer these variables in pl/sql package function as a parameter

All context variables registered in function need to be in the same order as are defined in pl/sql package function. While calling this function in fast formula, we don’t pass context parameters

3.  How can we debug a Fast Formula?

You can create a message variable in Fast Formula. This message variable must also be registered as a Formula Result ( In “Formula Result Rule” window)

4. What are the various levels where you can set up Payroll Costing Accounts?
Element Entry: Highest
Assignment: Second Highest
Organization: Third Highest
Element Link: Fourth Highest
Payroll: Fifth Highest

5. From which tables we can identify whether an Employee has been terminated?
The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP. 

Record gets updated in table PER_PERIODS_OF_SERVICE with Actual_Termination_date to be kept as NOT NULL

6. Can we make Employee Number generation Automated based on business rule?
There is a Fast Formula where we can configure the logic to generate the employee number

7.  What is the difference between per_people_f and per_all_people_f?

PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F table. The secure view uses an API hr_security.show_person. This API internally checks for an entry in table PER_PERSON_LIST for the logged in person’s security profile

8. If personalization is at both FUNCTION level and Responsibility level, which personalization has higher precedence?

Responsibility level will override function level personalizations

9. Can we delete a created employee?

To delete all records of a person:

§  Query the person in the Delete Person window and choose the Delete Person button.

§  If there is a contact for the person you are deleting, there are two possibilities:

• If the only information held about the contact is the basic person details entered in the Contacts window, then the record of the contact is deleted

• If there is other information held about the contact (for example, assignment or applicant information), the contact is not deleted. However, the record of their relationship to the person you are removing from the system is deleted

10. How to rehire a terminated employee after a certain time period.

Set your effective date to the new hire date and query the ex-employee in the People window. In the Type field, select Employee. The Hire Date field displays your effective date. Save your work

PREVIOUS POST || NEXT POST