Oracle HRMS Interview Questions

If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?

Responsibility level. Responsibility level will override FUNCTION level personalizations.
Say you have done a lot of Personalizations to Self Service Screens.
But all these Personalizations were done in DEVELOPMENT environment.

How will you migrate these personalizations to PRODUCTION environment?

fndload
In DEV you will do è akdload DOWNLOAD ( & other parameters)
In PRD you will do è akdload UPLOAD ( & other parameters)

What are the minimum classifications to create a Business Group?

(i) Business Group
(ii) GRE /Legal Entity
(iii) HR Organization

What are the Pre-Requisites for creating a Business Group?

(i) Value Sets
(ii) Key Flex-fields
(iii) Location

What is the use of HR Organization?

If we want to assign the employee information to a Business Group then we need to have HR Organization classification under a Business Group.

What is People Group?

(i) It is a Flexible area for holding user-defined assignment data.
(ii) Data can be used for Grouping sets of assignment together.
(iii) People group can be used for Element eligibility.
(iv) This information is used by the Payroll Run.
(v) The data will be held in PAY_PEOPLE_GROUPS.
(vi) GROUP_NAME field holds the concatenation of Segment data.

What is the KFF structure for SIT?  

Special Information Types

Personal Analysis Flexfields.

What is the DFF structure for EIT?

Extra Information Types

(i) Extra Person Information

(ii) Assignment Extra Information

(iii) Extra Location Information

(iv) Extra Position Information

(v) Extra Job Information

(vi) Organization Developer DFF

How to enable EIT?

Switch Responsibility to ‘Human Resources, Vision Enterprises’

Double click on ‘Security’

Click on ‘Information Types’

Create your own ‘Information Types’ under your ‘Responsibility Name’.

How to enable SIT?

Switch Responsibility to ‘Human Resources, Vision Enterprises’

Double click on ‘Other Definitions’

Click on ‘Special Information Types’

What is the use of Date Track?

1) It is used 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. 

2) The value of the Data Track record depends on the date.

3) Tables ending with _F are date track tables.

4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date

5) The Effective_Start_Date indicates when the record inserted.

6) The Effective_End_Date indicates when the record updated or deleted.

What is the use of Object Version Number?

1) It is used to capture the latest record from the data base table.

2) When a row is inserted its number is set to 1.

3) If any updates performed on the row then the OVN is incremented.

4) Every API has the OVN parameter.

5) For create API this parameter is defined as an OUT parameter.

6) For update API this parameter is defined as an IN OUT parameter

7) The APIs use it to check a row has been updated by another user, to prevent overwriting their changes.

What is the Element?

It is a Data Structure which is used to hold information for both Human Resources and Payroll.

In Human Resources elements may represents compensation types including Earnings such as Salary, Hourly Wages and Bonuses.

In Payroll, elements constitute all the items in the Payroll run process.

What are the Classification Priorities?

(i) Information

(ii) Non-Payroll

(iii) Earnings

(iv) Pre-Tax Deductions

(v) Tax Deductions

(vi) Employer Tax

(vii) Voluntary Deductions

(viii) In Voluntary Deductions

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.

What are the pre-defined Elements?

UK Payroll legislation provides many predefined elements

--Tax

--National Insurance (Employee/Employer)

--Court Orders

These Elements cannot be modified.

What are the Element Entry Concepts?

Recurring à Recurring Entries can exists over many Payroll periods

Non-Recurring à Non-Recurring Entries are valid for single Payroll period only.

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

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.

What is the use of ID_FLEX_NUM?

It is used to define the Structure Definition.

The Structure Definition is held in FND_ID_FLEX_STRUCTURES

The Structure Segment Definition is held in FND_ID_FLEX_SEGMENTS

What is the Element Link?

Links identify one or more assignment components that must be included in an employee's assignment for them to be eligible.Elements can, but they don’t have to, be linked by: Organization Group Job Position Grade Location Employment Category (i.e., Full time-Regular, Part-time-Regular)

What is API?

API is packaged procedure which can be used as an entry point into Application.

The advantage of using an API is we can enter new information or alter the existing data without manual enters the information into the Application. 

  APIs allow users to maintain HRMS information without using Oracle Application forms

How do i use an API to upload the data?

API package contains many procedures to insert/update/delete the application data.

The API is not executed on its own, the API must be called or executed by other pl/sql program.

The API package should never be modified for custom use, if modified Oracle will not be able to support them

None of the HRMS APIs issue commit, the calling module should manage the commit of the transaction.

How do i identify the Package name and version of the API?

SELECT text FROM all_source WHERE name like ‘HR_EMPLOYEE_API%’ AND text LIKE ‘%Header%’;