Interview Questions.

Oracle HRMS Interview Questions and Answers


Oracle HRMS Interview Questions and Answers

Q1.What are fundamental setups of oracle HRMS?

Ans: In oracle HRMS there are such a lot of modules like Core HR, Payroll, Self Service HR, Oracle gaining knowledge of management, iRecruitment, Time and Labour, Compensation Work bench, Oracle Advanced Benefits, Performance Management System and so on., Core HR and System Administrator are the Heart of Oracle HRMS.

All primary set usawill do in Core HR with the help of System Administrator.

In gadget administrator we are able to create all of the Users and Responsibilities, Flex fields, Profile values etc., In core HR we will create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, role Hierarchy, We will create all the employees additionally. These are the Basic setups in HRMS.

Q2. What is the difference between a Job and a Position?

Ans: Job is general one, while Position is unique term to its role and obligations.


POSITION: Finance Manager, HR Manager, Junior SOFTWARE ENGINEER, (that is function that's unique to the function to be performed.

Q3. What are the difference among greater records type (EIT) and special statistics type (SIT)?

Ans: EIT and SIT Both are supplied through Oracle to Capture Extra Information. Basic differences could be EIT is similar like a DFF and additionally described the use of DFF Definition Screen. SIT is KFF and defined using Personal Analysis KFF Definition display screen.

SIT usually used at Person Level, EIT may be described at PERSON, ASSIGNMENT, CONTACT, ELEMENT, LOCATION and JOB LEVEL.

There are 2 columns start_date_active and end_date_active in SIT at the same time as no such columns are there in EIT.

ORACLE Apps HRMS Interview Questions

Q4. Tell me the name of critical Key Flex-Fields (KFFs) in Oracle HRMS?

Ans: Job KFF,

Grade KFF,

People Group KFF,

Position KFF,

Cost Allocation KFF,

Competence KFF.

Q5. List of some Important Tables in HRMS.

Ans: Per_all_people_F,















Q6. What is the distinction between both SECURED VIEWS and NON SECURED VIEWS?


Secured perspectives display facts most effective for the contemporary length.

Unsecured perspectives is used to get the statistics from the complete rows.

Q7. Define APIs and use in Oracle HRMS?

Ans: API’s are utilized in HR to insert the records into the Base tables. As it’s very secured system, the consumer does now not have the ability to copy the information directly into the Base tables. When we write the inbound interfaces / use WebAdI, the structures will use the APIs to keep the records into device. The API are published via oracle with range of parameters. The exclusive types of parameters are IN / INOUT / OUT of these parameters few are obligatory, without which the technique won’t whole. Generally while we use API we supply records FOR: Object Version Number, Effective Date and P_Validate

HR_EMOYEE_api example: hr_employee_api.Create_employee

hr_organization_api Example: hr_organization_api.Create_organization


Q8. What are processing types of element?

Ans: Elements are nothing however the components of the revenue.

For Example: Basic Salary, House Allowance, Transport Earning, Bonus, Loan Recovery etc.

There are 2 forms of Processing

1. Recurring: if an access of this element applies in every period till the entry is ended

2. Non Recurring: if an access applies in a single pay period best.

Q9. What are termination roles of an detail?


Termination Rules of an Element:

Actual Termination: For a nonrecurring detail, choose ActualTermination if you need the entries to close down at the give up of the pay period in which the employee leaves.

Final close: in case you want the entries to live open past the employee’s leaving date so that you can continue to pay the employee.

The Last Standard Process date defaults to the closing day of the pay duration in which the employee is terminated, however you may set it to a later period while you terminate an employee.

Q10. What is a protection profile?

Ans: Security profile affords greater safety within BG. It allows in figuring out what users have get entry to to what information. The stages where you could have protection profile are: Organization Position Payroll Supervisor User unique: you can restrict / deliver permission to any person you may additionally have Custom protection

HubSpot Video

Q11. What is a security profile in HRMS?

Ans: Need to have: consolidation set payroll employees need to be attached to payroll stability pay methods required factors and run the technique ? Payroll run ? Do accurate in case there may be change.

Q12. What is the distinction among rehire and opposite-termination?

Ans: So the man or woman could have a brand new service report but the private information would possibly continue to be the equal? When an employee is terminated as in step with the procedure or by using mistake and then there is a requirement to name again the employee at once after termination, is referred to as opposite termination .It approach you reverse the manner and maintain the worker ?When you reverse terminate the procedure the termination details are cleared and his employment information keeps with the equal assignments and with the same provider duration.

Q13. How many key flex fields in HRMS?

Ans: Let me short approximately HRMS first: HRMS includes Payroll, however we've Payroll as a separate application when query KFFs. There are 10 KFFs in HRMS.1. Job KFF2. Position KFF3. Grade KFF4. Competence KFF (The above 4 KFFs are component Human Resources application)

Q14. How do you define B.G?

Ans: By default “Setup Business Group” to be had in the gadget. This BG data seen to all the employees, to symbolize a single Unit.Hence with the intention to make partition on the Employee data (create a separate Group) we need to create new BG. On the entire defining.

Q15. What is Retro Pay in Oracle Payroll? How many forms of Retro Pays are to be had?

Ans: Retro Pay is a payment made for an occasion of past. Retro Pay stands for a few vintage Payment due for the employee. This is used for Back Dated Salary Increments. There are 4 approaches. 1. Retro Pay with the aid of Run 2.Retro Pay via Aggregate three.Retro Pay by using Element four.Enhanced

Q16. How many varieties of payrolls are there?

Ans: Two types1. Regular pay 2. Quick pay.

Q17. How do you declare bonus of an employee in Oracle HRMS Payroll?

Ans: You can define one element (earnings) and use it to pay Bonus. Declaration is based on the practical inputs, suppose organization desires to pay Bonus along with January Salary in Every Year, you could write the formulas for that reason. Cheers

Q18. What are the tools used with Oracle HRMS?

Ans: Oracle Reports, Discoverer, Standard seeded reports, View/List choice of the menu – output might be exported in word/excel, WebADI etc.

Q19. What are the blessings of Oracle HRMS over PeopleSoft HRMS?

Ans: Oracle HRMS is extra secured than People Soft HRMS.

Q20. How people control is executed the use of Oracle HRMS?

How is gross pay factors described in Oracle HRMS?

Q21. What are the reports available with Oracle HRMS?

Ans: Absences Report Assignment Status Report Current and Projected Progression Point Values Report Element Link Details Report Employee Increment Results Report Employee Movements Report Employee Summary Report Full Personal Details Report Set Full Applicant Details.

Q22. How Oracle HRMS enables in Budgeting and Costing?

Ans: You can installation budgets for non-financial measures including headcount or full-time equal. When you enter worker assignments to outline the paintings an employee does for your employer, you can specify the value of the task closer to these budgets.

Q23. What are the benefits accomplished by way of an company by the usage of Oracle HRMS?

Ans: Remember the pyramid kind structure: People, WS and Compensation advantages with Assignments being the idea. This model is each bendy and adaptable. It is bendy, so you can mirror the wishes of various groups

Q24. What is superior advantages module in Oracle HRMS?

Ans: Oracle Advanced Benefits (OAB) looks after the control of Benefits Administration component.? It has very advanced functions like Life Event Triggering / Processing, ? FSA management, Reimbursement processing, Communications regarding Benefits and many others.

Q25. What are the modules available in Oracle HRMS?

Ans: Core HRPayroll (Includes Standard Benefits) Adavnced Benefits (OAB) Talent Management (Performance Management) Oracle Time and Labor (OTL) Oracle Learning Management (OLM) iRecruitmentSelf Services HR (SSHR).

Q26. What are the vital functions of Oracle HRMS?

Ans: Vital features are: People, Assignment, Work Structure, Compensation and Benefits.

Q27. How is new reports created in Oracle HRMS?

Ans: Discoverer, BI Reports, Copy existing report and sign in with exclusive call.

Q28. What are the stairs worried in implementation of Oracle HRMS?

Ans: Following are the steps to implement Oracle HRMS, — Define Key Flex fields– Define Descriptive Flex fields– Define Business Group– Set required Profile Options– Define Location– Define Organization– Define Grades– Define Jobs– Define Positions

Q29. What are the key flex fields found in Oracle HRMS?

Ans: 1. Job2. Position 3. Grade four. People Group 5. Cost Allocation6. Competence7. Bank Details eight. Soft Coded nine. Personal Analysis crieteria10. Collective Agreement.

Q30. What is date monitoring, how it's miles used in HRMS ?

Ans: Date tracking is a feature in Oracle HRMS esp with all tables whose name send with _F eg:per_all_people_f .Now what takes place right here is we can't purge a file .

Q31. What are the important thing tables used in HRMS?

Ans: There are many tables used in HRMS. I actually have indexed some tables. PER_ALL_PEOPLE_FPER_ALL_ASSIGNMENTS_FHR_ALL_ORGANIZATIONS_UNITSPER_LOCATIONS_AL

Q32. What is costing?

Ans: Costing:

Recording the fees of an venture for accounting or reporting purposes, Using Oracle Payroll, you may calculate and switch costing statistics in your wellknown ledger and into structures for venture management or exertions distribution.

Q33. What are 2 modes of date music in Oracle APPS?

Ans: Answer)There are two Date Track modes are as observe:



Q34. Can we delete an employee forever? How?

Ans: Use ?Delete non-public file? Shape from front cease. But employee should no longer be a utility consumer (stop date the username before delete) and must not be having payroll run information.

Q35. Can a job have multiple positions?

Ans: Job is time-honored. Yes a activity may have more than one positions.

Q36. Can you name PL/SQL Package features from within a Fast Formula?

Ans: Yes you could

How can we try this?

There is a Define Function screen in HR. In this display you'll sign in the PL/SQL as “External Function”.

Q37. Can we need to pass a parameter PAYROLL_ID to this external PL/SQL Function, how do we do it?

Ans: The “Define Function” display screen has a button named “Context Usage”. This button opens up a window in which you may sign up the parameters.

Q38. How do you debug a Fast Formula?

Ans: You can create a message variable in Fast Formula.

This message variable need to additionally be registered as a Formula Result (In “Formula Result Rule” window).

Q39. What are the various degrees where you may Set up Payroll Costing Accounts? Which degrees take the best precedence?

Ans: Element Entry - Highest

Assignment - Second Highest

Organization - Third Highest

Element Link - Fourth Highest

Payroll - Fifth Highest

Q40. Technically speaking, how do you already know from tables that an Employee has been terminated?


 The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP.

A file gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null.

Q41. How can you make Employee Number technology Automated based on commercial enterprise rule etc?

Ans: Use Fast Formula.

Q42. What is the difference between per_people_f and per_all_people_f?

Ans: PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The cozy view makes use of an API hr_security.Show_person. This API internally exams for an entry in desk PER_PERSON_LIST for the logged in person’s safety profile. A concurrent application named “Security List Maintenance software” will insert information in PER_PERSON_LIST.

Q43. If you do personalization at each FUNCTION level and Responsibility stage, which personalization has better precedence?

Ans: Responsibility stage. Responsibility degree will override FUNCTION level personalization’s.

Q44. Say you have done a variety of Personalization’s to Self Service Screens. But most of these Personalization’s had been executed in DEVELOPMENT surroundings. How will you migrate those personalization’s to PRODUCTION surroundings?

Ans: Before 11.Five.7…Use AKLOAD

This is a java software given via Oracle. This is the best way you can script it.

In DEV you may do AKLOAD DOWNLOAD ( & other parameters)

In PRD you may do AKLOAD UPLOAD ( & different parameters)

On or after 11.5.10 Use obligation “Functional Administrator”, then click on

on Personalization Tab, after which click on on Import/Export.

Next pick the files to be exported.

Go to the UNIX field and tar the personalization’s right into a .Tar report.

On the Production surroundings unzip this tar record in region as entered in profile “FND: Personalization Document Root Path”.

Setting up of this profile is obligatory or else Oracle Framework wouldn’t realize wherein to look for the files to be imported.

Q45. How to restrict iRecruitment external traffic to get right of entry to handiest responsibilities on the outside server?

Ans: Set the Server Trust Level for the server to External, Set the Trust Level of the iRecruitment outside obligations to External too.

Q46. Is SSHR a dependency for iRecruitment?

Ans: iRecruitment has no dependence on SSHR.

Q47. Does iRecruitment support “Candidate Qualifying Questionnaires” where the candidate need to solution emptiness-specific questions successfully prior to filing an utility?

Ans: iRecruitment currently does no longer aid this function, For now this may be performed by means of having a set of easy questions using flexfield to get the ones responses and a person hook to validate them as part of the observe technique.

Q48. Do we track emptiness history?

Ans: iRecruitment does no longer music changes to the emptiness. If changes to a subject are to be traced use the Audit functionality in APPs.

Q49. Ensuring that Costing Information may be furnished.

Ans: On final touch of a payroll run you may want to distribute the related prices across unique price centres. Oracle supports this the usage of the Cost Analysis module.

Q50. Can you run payroll methods and reports multi-lingually?

Ans: Payroll methods and reports are usually submitted and usually run within the neighborhood language handiest. This method that US and UK payroll reports can most effective be run in English.

Q51. Can you call pl/square bundle functions from inside a Fast Formula?

Ans: Yes, It is accomplished via Define Function display in HR. In this display we are able to sign up the pl/square as “External Function” and reference it in Fast system definition

Q52. If we need to pass a parameter PAYROLL_ID to this external pl/sq. Function, how will we do it?

Ans: The “Define Function” screen has a button named “Context Usage”. It includes all those context variables which can be available for that system type, you could reference those variable in pl/sq. Package deal characteristic as a parameter.

All context variables registered in characteristic want to be within the identical order as are described in pl/square bundle feature. While calling the this function in rapid formula, we dont skip context parameters.

Q53. How do you Debug a Fast Formula?

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

Q54. What are the various levels where you can Set up Payroll Costing Accounts?

Ans: Element Entry - Highest

Assignment - Second Highest

Organization - Third Highest

Element Link - Fourth Highest

Payroll - Fifth Highest

Q55. From which tables we are able to discover that an Employee has been terminated?

Ans: The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP. Record receives updated in desk PER_PERIODS_OF_SERVICE with Actual_Termination_date being no longer null

Q56. How can you're making Employee Number generation Automated based on commercial enterprise rule and many others?

Ans: There is a Fast Formula wherein we are able to configure the logic to generate the employee wide variety

Q57. What is the distinction among per_people_f and per_all_people_f?

Ans: PER_PEOPLE_F is a secured view on pinnacle of PER_ALL_PEOPLE_F table. The at ease view makes use of an API hr_security.Show_person. This API internally checks for an access in desk PER_PERSON_LIST for the logged in person’s safety profile.

Q58. If you do personalization at both FUNCTION degree and Responsibility degree, which personalization has better precedence?

Ans: Responsibility level will override function level personalizations.

Q59. Can we delete a wrongly created worker?

Ans: To delete all records of someone: (Answer taken from Oracle Implementation Guide)

Query the man or woman inside the Delete Person window and choose the Delete Person button.

If there's a touch for the person you're deleting, there are two possibilities:

If the handiest information held about the touch is the primary man or woman information entered inside the Contacts window, then the file of the touch is deleted.

If there is different data held about the touch (for instance, challenge or applicant records), the contact is not deleted. However, the document in their dating to the character you are eliminating from the gadget is deleted.

Q60. How to rehire a terminated employee after a sure term.


Set your effective date to the new rent date and query the ex-worker within the People window.

The Hire Date subject presentations your powerful date.

Save your paintings.

Click right here to study More About Oracle HRMS...