Oracle HRMS Interview Questions and Answers
Last updated on 22nd Oct 2020, Blog, Interview Question
If you’re looking for Oracle HRMS Interview questions for Experienced or Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle HRMS has a market share of about 5.1%. So, You still have the opportunity to move ahead in your career in Oracle HRMS Development. Acte offers Advanced Oracle HRMS Interview questions 2019 that help you in cracking your interview & acquire a dream career as Oracle HRMS Developer.
1.How to use an API to upload the data?
- The 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 another pl/sl program.
- The API package should never be modified for custom use, if modified Oracle will not be able to support them.
2.How to identify the Package name and version of the API?
- SELECT text FROM all_source WHERE name like â€˜HR_EMPLOYEE_API%â€™ AND text LIKE â€˜%Header%â€™;
3.Where can you find information on an API and its parameters?
Review the package header file for the particular API file (.pkh).
4.What is the Object version number and how do you 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 creating 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.
5.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.
6.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 everything is validated then rows 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.
7.Can you use an API on an application table on which an event-based alert is defined?
No, if an event-based alert is defined on an application table then the API will give an error.To run API the alert has to be disabled and re-enabled after the API has been executed.
8.What are the types of Element Entry?
There types are as follows:
- Normal Entry
- Override Entry
- Additional Entry
- Adjustment Entry
- Additive Adjustment
- Replacement Adjustment
- Balance Adjustment
9.What are the Important Tables in HRMS?
- 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.
- per_all_assignments_f: This table will store all the information which has been entered in the employee assignment form.
- per_addresses: This table will store all the information which has been entered in the employee address form.
- per_pay_proposals: This table will store all the information which has been entered in the employee salary form.
- 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.,
- per_jobs_tl: This table will contain the various types of JOBS in oracle. This table is linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
- per_grades_tl: This table will contain the various types of GRADES in oracle. This table is linked with the per_all_assignments_f table to retrieve the correct grade name from the employee.
- hr_locations_all: This table will contain the various LOCATIONS in oracle. This table is linked with the per_all_assignments_f table to retrieve the correct location name from the employee.
- pay_all_payrolls_f: This table will contain the various types of PAYROLLS in oracle. This table is linked with the per_all_assignments_f table to retrieve the correct payroll name from the employee.
- per_pay_bases: This table will contain the various types of PAY BASES in oracle. This table is linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.
- 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 linked with the per_all_assignments_f table to retrieve the correct job name from the employee.
- per_person_type_usages_f: This table will store the correct person type of the particular 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.
10.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
11.What are the minimum classifications to create a Business Group?
- Business Group
- GRE/Legal Entity
- HR Organization
12.What are the Prerequisites for creating a Business Group?
- Value Sets
- Key Flexfields
13.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.
Subscribe For Free Demo[contact-form-7 404 "Not Found"]
14.What is People Group?
- It is a Flexible area for holding user-defined assignment data.
- Data can be used for Grouping sets of assignments together.
- People group can be used for Element eligibility.
- This information is used by the Payroll Run.
- The data will be held in PAY_PEOPLE_GROUPS.
- GROUP_NAME field holds the concatenation of Segment data.
15.What is the KFF structure for SIT?
Personal Analysis Flexfields.
16.What is the DFF structure for EIT?
- Extra Person Information
- Assignment Extra Information
- Extra Location Information
- Extra Position Information
- Extra Job Information
- Organization Developer DF
17.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’.
18.How to enable SIT?
- Switch Responsibility to ‘Human Resources, Vision Enterprises’
- Double click on ‘Other Definitions’
- Click on ‘Special Information Types’
19.What is the use of Date Track?
- It is used to maintain the record history by creating a new record when the date track mode is updated and override on the existing record when the Data track mode is CORRECTION.
- The value of the Data Track record depends on the date.
- Tables ending with _F are date track tables.
- To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date.
- The Effective_Start_Date indicates when the record is inserted.
- The Effective_End_Date indicates when the record updated or deleted.
20.What is the use of Object Version Number?
- It is used to capture the latest record from the database table.
- When a row is inserted its number is set to 1.
- If any updates are performed on the row then the OVEN is incremented.
- Every API has the OVN parameter.
- For creating an API this parameter is defined as an OUT parameter.
- For update API this parameter is defined as an IN OUT parameter.
- The APIs use it to check if a row has been updated by another user, to prevent overwriting their changes.
21.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 Workbench, Oracle Advanced Benefits, Performance Management System etc., Core HR and System Administrator are the Heart of Oracle HRMS.
All basic setups will be done 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.
22. What is the difference between a Job and a Position?
- Job is a general one, whereas Position is a specific term to its role and responsibilities.
- JOB: MANAGER (generic term), SOFTWARE DEVELOPER
- POSITION: Finance Manager, HR Manager, Junior SOFTWARE ENGINEER, (this is a position which is specific to the role to be played.
23. Tell me the name of important Key Flex-Fields (KFFs) in Oracle HRMS?
- Job KFF,
- Grade KFF,
- People Group KFF,
- Position KFF,
- Cost Allocation KFF,
- Competence KFF.
24. What is the difference between both SECURED VIEWS and UNSECURED VIEWS?
- Secured views display information only for the current period.
- Unsecured views are used to get the information from the entire rows.
25. Define APIs and use in Oracle HRMS?
API’s are used in HR to insert the data into the Base tables. As it’s a very secure system, the user does not have 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 the system. The API is published by Oracle with a number of parameters. The different types of parameters are IN / INOUT / OUT of these parameters few are mandatory, without which the process won’t complete. Generally when we use API we give data 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
26. What are processing types of elements?
Elements are nothing but the components of the salary.
For Example: Basic Salary, House Allowance, Transport Earning, Bonus, Loan Recovery etc.
There are 2 types of Processing
- Recurring: if an entry of this element applies in every period until the entry is ended
- Non Recurring: if an entry applies in one pay period only.
27. What are termination roles of an element?
Termination Rules of an Element:
- Actual Termination: For a nonrecurring element, select ActualTermination if you want the entries to close down at the end of the pay period in which the employee leaves.
- 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.
- 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.
28. What is a security profile?
Security profile provides more security within BG. It helps in determining what users have access to what data. The levels where you can have security profile are: Organization Position Payroll Supervisor User specific: you can restrict / give permission to any user you can also have Custom security
29. What is the difference between rehire and reverse-termination?
So the person will have a new service record but the personal details might remain the same? When an employee is terminated as per the process or by mistake and then there is a requirement to call back the employee immediately after termination, is known as reverse termination .It means you reverse the process and retain the employee ?When you reverse terminate the process the termination details are cleared and his employment details continues with the same assignments and with the same service period.
30. How do you define B.G?
By default “Setup Business Group” available in the system. This BG info is visible to all the employees, to represent a single Unit.Hence in order to make partition on the Employee data (create a separate Group) we need to create a new BG. On the whole, defining.
31. What is Retro Pay in Oracle Payroll? How many types of Retro Pays are available?
Retro Pay is a payment made for an event of the past. Retro Pay stands for some old Payment due for the employee. This is used for Back Dated Salary Increments. There are four ways. 1. Retro Pay by Run 2.Retro Pay by Aggregate 3.Retro Pay by Element 4.Enhanced
32. How many types of payrolls are there?
- Regular pay
- quick pay.
Learn Oracle HRMS Training with Real-Time Experience to Build Your Skills
- Instructor-led Sessions
- Real-life Case Studies
33. How do you declare the bonus of an employee in Oracle HRMS Payroll?
You can define one element (earnings) and use it to pay Bonus. Declaration is based on the functional inputs, suppose company wants to pay Bonus along with January Salary in Every Year, you can write the formulas accordingly. Cheers
34. What are the tools used with Oracle HRMS?
Oracle Reports, Discoverer, Standard seeded reports, View/List option of the menu – output could be exported in word/excel, WebADI etc.
35. What are the advantages of Oracle HRMS over PeopleSoft HRMS?
Oracle HRMS is more secure than PeopleSoft HRMS.
36. What are the reports available with Oracle HRMS?
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.
37. How Oracle HRMS helps in Budgeting and Costing?
You can set up budgets for non-monetary measures such as headcount or full-time equivalent. When you enter employee assignments to define the work an employee does for your enterprise, you can specify the value of the assignment towards these budgets.
38. What is an advanced benefits module in Oracle HRMS?
Oracle Advanced Benefits (OAB) takes care of the management of the Benefits Administration part.? It has very advanced features like Life Event Triggering / Processing, FSA administration, Reimbursement processing, Communications relating to Benefits etc.
39. What are the modules available in Oracle HRMS?
Core HRPayroll (Includes Standard Benefits) Advanced Benefits (OAB) Talent Management (Performance Management) Oracle Time and Labor (OTL) Oracle Learning Management (OLM) iRecruitmentSelf Services HR (SSHR).
40. What are the vital features of Oracle HRMS?
Vital features are: People, Assignment, Work Structure, Compensation and Benefits.
41. How are new reports created in Oracle HRMS?
Discoverer, BI Reports, Copy existing reports and register with different names.
42. What is date tracking, how is it used in HRMS ?
Date tracking is a feature in Oracle HRMS esp with all tables whose name send with _F eg:per_all_people_f .Now what happens here is we cannot purge a record .
43. What are the key tables used in HRMS?
- There are many tables used in HRMS. I have listed some tables.
44. What is 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.
45. What are 2 modes of date track in Oracle APPS?
There are two Date Track modes are as follow:
46. Can we delete an employee forever? How?
Use Delete personal record form from front end. But the employee should not be an application user (end date the username before delete) and should not be having payroll run data.
47. Can a job have multiple positions?
Jobs are generic. Yes a job can have multiple positions.
48. Can you call PL/SL Package functions from within a Fast Formula?
Yes you can
49. Can we want to pass a parameter PAYROLL_ID to this external PL/SL 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.
50. 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).
51. What are the various levels where you can Set up Payroll Costing Accounts? Which levels take the highest precedence?
- Element Entry – Highest
- Assignment – Second Highest
- Organization – Third Highest
- Element Link – Fourth Highest
- Payroll – Fifth Highest
52. Technically speaking, how do you 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 record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null.
53. How can you make Employee Number generation Automated based on business rule etc?
Use Fast Formula.
Best Oracle HRMS Certification Training Course & Get Hired by TOP MNCsWeekday / Weekend BatchesSee Batch Details
54. 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 Maintenance program” will insert records in PER_PERSON_LIST.
55. If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?
Responsibility level. Responsibility level will override FUNCTION level personalization.
56. Say you have done a lot of Personalization to Self Service Screens. But all these Personalization were done in a DEVELOPMENT environment. How will you migrate these personalization 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 AKLOAD DOWNLOAD ( & other parameters)
- In PRD you will do UPLOAD 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 personalization 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 wouldn’t know where to search for the files to be imported.
57. 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.
58. Is SSHR a dependency for iRecruitment?
iRecruitment has no dependence on SSHR.
59. Does iRecruitment support “Candidateualifyinguestionnaires” where the candidate must answer vacancy-specifications correctly prior to submitting an application?
iRecruitment currently does not support this function, For now this can be achieved by having a set of simpleuestions using flexfield to get those responses and a user hook to validate them as part of the apply process.
60. 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.
61. Ensuring that Costing Information can be provided.
On completion of a payroll run you may need to distribute the associated costs across particular cost centres. Oracle supports this using the Cost Analysis module.
62. Can you run payroll processes and reports multi-lingually?
Payroll processes and reports are always submitted and always run in the local language only. This means that US and UK payroll reports can only be run in English.
63. How to rehire a terminated employee after a certain time period.
- Set your effective date to the new hire date anduery the ex-employee in the People window.
- The Hire Date field displays your effective date.
- Save your work.
64. What are the reports which you have done in HR?
This report is used to display the information about the employees, the assignments which were given to the employees along with the payroll details including the Hours Paid, Salary, NI, Pension, Car Allowances and Other Allowances.
65.What are core flexfield?
There are 6 Core Flex fields are there:
- People Group
- Cost Allocation
66.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.r
67.Define Batch Element Entry?
This is an open interface specially designed for elements. With BEE we quickly incorporate mass updates in any specific elements.
68.What are Reversal and Retry?
Reversal can be used to correct run results for one assignment after post-run actions have already occurred. Retry is for correcting mistakes after a payroll process finishes.
69.Which elements you link openly in Payroll?
Worker’s Compensation and Vertex (Vertex is a third party software to calculate US Canadian taxes) usinguantum files. (It is part of Vertex software which will be updated as and when the tax and legal rules are changed by the US/Canadian Government. So we keep getting the Vertex patches to bringuantum files with the up to date tax rules and conditions)
70.What is Consolidation Set, Element Set & Assignment Set?
Consolidation Set: A grouping of payroll runs within the same time period for which one can schedule reporting, costing, and post-run processing.
71.What are the mandatory fields while creating Payroll?
- Payroll Name
- Period Type
- Start Date
72.Define –quick Pay & Batch Processing
When calculating pay, we can use either
- quick Pay Process, which is for one employee or
- Batch Process for all employees together
73.What is BACS, NACHA?
- BACS: Banks Automated Clearing System. This is the UK system for making direct deposit payments to employees.
- NACHA: National Automated Clearing House Association. This is the US system for making direct deposit payments to employees.
74. 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. Basic differences would be EIT is similar like a DFF and also defined using DFF Definition Screen. SIT is KFF and defined using Personal Analysis KFF Definition screen.
- SIT generally used at Person Level, EIT can be defined at PERSON, ASSIGNMENT, CONTACT, ELEMENT, LOCATION and JOB LEVEL.
- There are 2 columns start_date_active and end_date_active in SIT while no such columns are there in EIT.
75. List of some Important Tables in HRMS.
76. What is a security profile in HRMS?
Need to have: consolidation set payroll employees should be attached to payroll balance pay methods required elements and run the process ? payroll run ? do correct in case there is change.
77. How many key flex fields in HRMS?
Let me brief about HRMS first: HRMS includes Payroll, but we have Payroll as a separate application whenuery KFFs. There are 10 KFFs in HRMS.1. Job KFF2. Position KFF3. Grade KFF4. Competence KFF (The above four KFFs are part Human Resources application)
78. What are the advantages achieved by an organization by using Oracle HRMS?
Remember the pyramid kind structure: People, WS and Compensation benefits with Assignments being the basis. This model is both flexible and adaptable. It is flexible, so that you can reflect the needs of different companies
Are you looking training with Right Jobs?Contact Us
- Workday Tutorial
- Netsuite Tutorial
- What Is SAP Human Capital Management (HCM)?
- “Microsoft Dynamics 365 Tutorial “
- PeopleSoft HRMS Interview Questions and Answers
- What is Dimension Reduction? | Know the techniques
- Difference between Data Lake vs Data Warehouse: A Complete Guide For Beginners with Best Practices
- What is Dimension Reduction? | Know the techniques
- What does the Yield keyword do and How to use Yield in python ? [ OverView ]
- Agile Sprint Planning | Everything You Need to Know