Oracle Application HRMS Interview Questions

Question:  How to restrict the users to see the payroll data employee wise, they only can setup the basic elements and pay bonuses but cannot see the gross salaries of employees ?

1) define task flow for your screen 

2) Define the Profile security for his employee

  

Question:  What are processing types of element ?

Elements are nothing but the components of the salary.

Eg. Basic, HRA, TA, BONUS, Loans 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.

  

Question: What are termination roles of an element ?

Termination Rules of an Element:

• a).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.

• b).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.

• c).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.

  

Question: What is costing ?

Costing: Recording the costs of an assignment for accounting or reporting purposes. Using Oracle Payroll, you can calculate and transfer costing information to your general ledger and into systems for project management or labor distribution.

  

Question: What are costing types ?

Costing types are:

1.Fixed costed
2.Costed
3.Distributed

    

Question: Can we name certain DFFs (description flex filed) and their location ?

Yes we can name certain DFF's and their location

   

Question: What are core flexfield ?

Core flexfields are:

·         Job

·         Position

·         Grade

·         Competency

    

Question: What are Two modes of date Track and what is date track ?

Date Track modes are:

·         Update

·         Correction

    

Question: What are six validation types ?

Validation types:

·         Dependent

·         Independent

·         None

·         Pair

·         Special

·         Table

    

Question: What are list types ?

List types are:

·         List of Values

·         Long list of Values

·         Pop list

   

Question: What are basic setups of oracle HRMS ?

• In oracle HRMS there are so many modules like Core HR, Payroll, Self Service HR, Oracle learning management, iRecruitment, Time and Labour, Compensation Work bench, Oracle Advanced Benefits, Performance Management System etc., Core HR and System Administrator are the Heart of Oracle HRMS.

• All basic set ups will do in Core HR with the help of System Administrator.

• In system administrator we will create all the Users and Responsibilities, Flex fields, Profile values etc., In core HR we will create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, position Hierarchy, We will create all the employees also. These are the Basic setups in HRMS.

   

Question: What is element entry ? what is the purpose of element entry ?

Element entry is to define element yet here enter that is Earning element or deduction element then calculate net pay.

Question: How many key flex fields in HRMS?

There are 6 Key Fields, Namely
1. Job KeyFlexFields.
2. Position KeyFlexFields.
3. Grade KeyFlexFields.
4. Cost Allocation FlexFields.
5. Competence FlexFields.
6. People Group FlexFields.

Question:  Important Tables in HRMS
1. per_all_people_f  : This table will provide us the very basic information about the employee. The very data from the first screen we see when we open the ‘People -> Enter and Maintain’ form goes into this table.

2. per_all_assignments_f  : This table will store all the information which is been entered in the employee assignment form.

3. per_addresses  :  This table will store all the information which is been entered in the employee address form.

4. per_pay_proposals   :  This table will store all the information which is been entered in the employee salary form.

5. per_person_types_tl   :  This table is used to find the type of the employee. This table is linked with the per_all_people_f with the person_type_id to find out the type of person.

6. per_jobs_tl  :  This table will contain the various types of JOBS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.

7. per_grades_tl  :  This table will contain the various types of GRADES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct grade name from the employee.

8. hr_locations_all  :  This table will contain the various LOCATIONS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct location name from the employee.

9. pay_all_payrolls_f  :  This table will contain the various types of PAYROLLS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct payroll name from the employee.

10. per_pay_bases  :  This table will contain the various types of PAY BASES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.

11. per_assignment_status_types_tl  :  This table will contain the various types of assignment types in oracle. The assignment types generally would be ‘Active Assignment’ etc.. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.

12. per_person_type_usages_f  :  This table will store the correct person type of the particluar employee. We should never depend on the person type present in the per_all_people_f table. Instead we need to link the person_id with this table and get the correct person type.

Question:  Key Flexfields (KFFs) in HRMS
=>Job KFF, =>Grade KFF, =>People Group KFF, =>Position KFF, => Cost Allocation KFF, => Competence KFF

Question: What are Date Track Tables? 

Every update in the Table, we will save the change in the form of a Record to provide the facility to find the information at any point of time.
These tables are post fixed by _F

Question: What are secured Views?
The Views which do not have the _all to be said as secured views.
Per_all_people_F
per_people_f
per_all_assignemtns_f
per_assignments_f
pay_all_payrolls_F
per_payrolls_f

Question: The differece between both secured views and non secured views is :
1.Secured views display information only for the current period
2.Unsecured views is used to get the information from the entire rows

Question:  APIs in HRMS
API are used in HR to insert the data into the Base tables. As its very secured system, the user does nothave the facility to copy the data directly into the Base tables.When we write the inbound interfaces / use WebAdI, the systems will use the APIs to store the data into system.The API are published by oracle with number of parameters.The different types of parameters are IN / INOUT / OUT.Of these parameters few are mandatory, with out which the process wont complete.Generally when we use API we give data for : Object Version Number, Effective Date, P_Validate
HR_EMOYEE_api ex: hr_employee_api.create_employee
hr_PERSON_api
hr_organization_api Ex: hr_organization_api.create_organization
hr_applicant_apI
hr_assignment_api

Question: What are the reports which you have done in HR?
HR PAYROLL COSTING :
This report is used to display the information about the employees, the assignements which were given to the employees along with the payroll details including the Hours Paid, Salary, NI, Pension, Car Allowances and Other Allowances.

 

 

Question: p_datetrack_update_mode, p_datetrack_delete_mode in HRMS API

Understanding the p_datetrack_update_mode Control Parameter in HRMS API
The p_datetract_update_mode control parameter enables you to define the type of DateTrack change to be made. This mandatory parameter must be set to one of the values as mentioned below:
UPDATE - Keep history of existing information
CORRECTION - Correct existing information
UPDATE_OVERRIDE - Replace all scheduled changes
UPDATE_CHANGE_INSERT - Insert this change before next scheduled change

Question: Understanding the p_datetrack_delete_mode Control Parameter
The p_datetract_update_mode control parameter enables you to define the type of DateTrack deletion to be made. This mandatory parameter must be set to one of the following values:
ZAP - Completely remove from the database
DELETE - Set end date to effective date
FUTURE_CHANGE - Remove all scheduled changes
DELETE_NEXT_CHANGE - Remove next change

Question:What are the minimum classifications to create a Business Group?
(i) Business Group
(ii) GRE/Legal Entity
(iii) HR Organization

Question: What are the Pre-Requisites for creating a Business Group?
(i) Value Sets
(ii) Key Flex fields
(iii) Location

Question: 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.

Question: 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.

Question: What is the KFF structure for SIT?
Personal Analysis Flexfields.

Question: What is the DFF structure for EIT?
(i) Extra Person Information
(ii) Assignment Extra Information
(iii) Extra Location Information
(iv) Extra Position Information
(v) Extra Job Information
(vi) Organization Developer DF

Question: 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’.

Question: How to enable SIT?
Switch Responsibility to ‘Human Resources, Vision Enterprises’
Double click on ‘Other Definitions’
Click on ‘Special Information Types’

Question: 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.

Question: 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.

Question: 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.

Question: 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

Question: 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.

Question: 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.

Question: 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.

Question: 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

Question: 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.

Question: 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

Question: 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., Fulltime-Regular, Part-time-Regular)
Payroll Salary Basis

Question: 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.

Question: 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.

Question: 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%’;

Question: Where can i find information on an API and its parameters?
Review the package header file for the particular API file (.pkh).

Question: What is Object version number and how do I assign values for it in an API?
Ø Object Version number is an assigned number to a row in a database table.
Ø When a new row inserted its number is set to 1
Ø If any updates performed on the row then the Object version number is incremented.
Ø Every API has the p_object_version_number control parameters.
Ø For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts.
Ø For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory.

Question: When the HR_7155_OBJECT_LOCKED raised?
The current value of object_version_number must be passed in the API call and it is compared to the version on the row in the table. If the versions are different then the HR_7155_OBJECT_LOCKED is raised.

Question: What is the p_validate control parameter?
Every API has a p_validate control parameter.
When the parameter is set to FALSE then all the business function validation is performed.
If every thing is validated then row can be inserted/updated/deleted.
If p_validate is set to TRUE then only the actual operation is validated.
A savepoint is issued at the start of the call and a rollback is done at the end of the call.
Can I use an API on an application table on which an event-based alert is defined?
Ø No, if an event-based alert defined on an application table then the API will give error.
Ø To run API the alert has to be disabled and re-enabled after the API has been executed.

Question: What is the difference between an API and a publicly callable API?
Ø An API is an alternative entry for data to be insert/update/delete from the application.
Ø The Oracle HRMS Publicly callable APIs engage in validation in the same manner as the forms do with in the application.
Ø Validation is performed in terms of data integrity, insuring that data relationship exist properly between related tables.
Ø Validation is also performed against business functionality as the application form would enforce it.
Ø Therefore, only p

Question: Can you call pl/sql package functions from within a Fast Formula?
Yes you can
-->How do we do this?
-->There is a Define Function screen in HR. In this screen you will register the pl/sql as “External Function”.
-->If we want to pass a parameter PAYROLL_ID to this external pl/sql Function, how do we do it ?
-->The “Define Function” screen has a button named “Context Usage”. This button opens up a window in which you can register the parameters.

Question: P35 report is run after the “End Of Year (EOY)” process.
Do you know which tables does EOY process populate.
P35 and P60 reports uses these tables which get populated by EOY?
FF_ARCHIVE_ITEMS
FF_ARCHIVE_ITEM_CONTEXTS

Question:  How do you 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).

Question: What are the various levels where you can Set up Payroll Costing Accounts?
Which levels take the highest precedence? **Assume Labor Distributions is not implemented**
Element Entry => Highest
Assignment => Second Highest
Organization => Third Highest
Element Link => Fourth Highest
Payroll => Fifth Highest

Question: Technically speaking, how do you know from tables that an Employee has been terminated?
a) The Person_Type_ID  in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP
(b) A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null

Question: How can you make Employee Number generation Automated based on business rule etc.
Use Fast Formula.

Question: 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. 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. A concurrent
program named "Security List Maintainence program" will insert records in PER_PERSON_LIST

Question::
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.

Question:
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?

Before 11.5.7…Use AKLoad
This is a java program given by Oracle. This is the only way you can script it.
In DEV you will do è akdload DOWNLOAD ( & other parameters)
In PRD you will do è akdload UPLOAD ( & other parameters)
On or after 11.5.10 Use responsibility “Functional Administrator”, then click
on Personalization Tab, and then click on Import/Export.
Next select the documents to be exported.
Go to the unix box and tar the personalizations into a .tar file.
On the Production environment unzip this tar file in location as entered in profile “FND: Personalization Document Root Path”.
Setting up of this profile is mandatory or else Oracle Framework would’nt know where to search for the files to be imported.

Question: How to restrict iRecruitment external visitors to access only responsibilities on the external server?

Set the Server Trust Level for the server to External, Set the Trust Level of the iRecruitment external responsibilities to External too.

Question: Is SSHR a dependency for iRecruitment?

iRecruitment has no dependence on SSHR

Question:  Does iRecruitment support “Candidate Qualifying Questionnaires” where the candidate must answer vacancy-specific questions correctly prior to submitting an application?

iRecruitment currently does not support this function, For now this can be achieved by having a set of simple questions using flexfield to get those responses and a user hook to validate them as part of the apply process.

Question: Do we track vacancy history?

iRecruitment does not track changes to the vacancy. If changes to a field are to be traced use the Audit capability in APPs.