Application Utilities Lookups

Lookups provide lists of valid values for certain items of information. This has two key advantages: 

• It ensures that all users use the same terminology, which makes it easier to inquire and report on the information.

• It speeds up data entry because you can enter just enough to identify the value, and the system completes the entry.

In Oracle HRMS, a list of values is called a lookup type. Each value comprises a code, a meaning, and sometimes, a legislative tag.

HR and PAYROLL Interview Preparation - Part IV

1. What is the Process to Reverse a Termination of employee?

You reverse a termination in order to make an employee active again.

Navigation: HR Responsibility >> Enter & Maintain >> Others >> End Employment

Search for the separated employee record  and click on ‘Reverse Termination’ button to undo the termination of an employee. As a result the person will become active employee again.

HR and PAYROLL Interview Preparation - Part III

1. What is the difference between Extra Information Type (EIT) and Special Information Type (SIT)?

EIT and SIT Both are provided by Oracle to Capture Extra Information. Following are the main differences:

• EIT is based on DFF whereas SIT is based on KFF of Person Analysis
• EIT is stored in PER_EXTRA_INFO tables where as SIT is store in PER_PERSON_ANALYSES and PER_ANALYSIS_CRITERIA tables

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

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