Ahmed Oracle HRMS payroll interview questions maahmed09@gmail.com


The main purpose of the payroll run is to calculate employee pay correctly at regular intervals. In addition you can perform other payroll processes to ensure  accuracy and provide flexibility for your organization. For example, you can roll back a payroll run when you want to carry out a test run without keeping any record of it having taken place. You can also run a retro pay process when you want to make retrospective adjustments to allow for backdated pay awards.

What are the mandatory fields while creating payroll?

Payroll name, period type and start date

Define elements?

Elements are the building blocks for earnings, deductions, etc. of a payroll

Salary basis?

Salary basis is the duration on which the salary is reckoned. It is a rule to administer pay.

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.

Define Batch element Entry?

The is an open interface specially designed for elements. With BEE

We can quickly incorporate mass updates in any specific elements.

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

Element set:  Grouping of all individual elements in to one set.

Suppose you want to define a special type of payment and make this available only to employees who work at a particular location. In oracle HRMS you use a compensation element to represent the payment. You define the business rule as a link between the element. And the specipoic location. Then when you assign employees to the location they automatically become elegible for the payment

Assignment set: grouping fo assignments for retro pay is generally referred as assignment set.


Fast formulas are pseudo codes used in the payroll for validating the entry values, assignment sets and element sets.


Three concurrent process will run in the post – payroll process

  • Pre-payment process
  • Costing process And
  • Transfer to Gl process

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

Does Oracle payroll enable you to run part payrolls?

Yes , oracle payroll enable you to run part payrolls. This is useful in each of the following circumstances where you do not want to process payroll for the entire organization;

Calculating pay for an individual employee?

If an employee leaves the company before the end of a payroll period, you will need to calculate the individual pay entitlement. You may also want to calculate individual pay to check the details for an employee before starting a payrll run for all employees.

Can you verify that a payroll run has completed successfully?

On completion of a payroll run you will need to verify that the run completed successfully. You can display run messages and view latest balances and assignement level results.

Can you make adjustments after a payroll run has completed?

Oracle payroll enables you to make each of the following types of adjustments when a payrll run has completed.

Addition of late entries that were not included in initial run

Corrections to details that were wrongly entered in the initial run

Retrospective distribution of current payments to the period in which they were earned

When you have made these corrections and modifications you can then run the paryll again. However, you do not need to rerun the entire payroll. Oracle payroll will only reprocess those items theat were incorrect in the initial run.

Can you produce payment and costing information from a completed payroll run?

Oracle payroll enables you to use the results of a payroll run to allocate payments to tyour emplyees, and to provide costing information.

Can you verify that payments have been made?

Yes, oracle payroll is fully integrated with oracle cash management. This enables you to use oracle cash

Management to verify that payments have been cashed. Reconciliation can be applied to payroll checks and third party checks. You can identify which checks have been cleared and date on which they were cleared. You can also view a reconciliation report which shows if voided checks appear to have been cashed.

What is the termination rule of the element?

  • Actual termination: for a non-recurring element select actual termination 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 employees 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.


What are costing types?

  • Fixed costed
  • Costed
  • distributed

what are six validation types?

  • Dependent
  • Independent
  • None

Ahmed ebs to fusion

oracle hrms and ebs fusion trainings 


support on projects     contact : maahmed09@gmail.com          



Fusion HCM Payroll Interview Questions

Fusion Payroll Interview Questions:

  1. How can I remove someone from the payroll run?

Roll back the person’s record from the View Person Process Result page, which deletes the record

How do you set the payroll license in Releases 10 and higher?

. Navigator>Setup and Maintenance

  1. Search for task Manage Features by Country or Territory
  2. Select Go to Task
  3. Set the Payroll license by country based on your Fusion licensing.

2) What are Object Groups?

Object groups are user-defined sets of elements or people used to restrict which of these items to include in various processes and reports.

There are four types of object groups:

  • Element
  • Payroll Relationship
  • Work Relationship
  • Deduction Card

Users can create and maintain object groups in the Manage Object Groups page from the Payroll Calculation work area. Object groups also could be loaded using the batch loader from the Payroll Administration work area or the Data Exchange work area.

3) What are Element Groups?

Element Groups limit the elements processed for payroll, reporting, or cost distribution purposes.

There are two usages for an element group:

  • Run group

Specifies the elements to use in a process.

  • Distribution group

Defines the grouping of elements to distribute element costing results.

All element groups are static. You select the element classifications to add and then include or exclude additional elements from the group. Or you can select specific elements to include without using element classifications.

4) What are Payroll Relationship Groups?

Payroll Relationship Groups limit the persons processed for payroll, data entry, and reporting. When defining the group specify the payroll definition which retrieves the payroll relationships assigned to it. Every group is limited to the payroll relationships assigned to a single payroll that you select. You can further define the group statically or dynamically.

  • If you define the group statically, select the payroll relationships, terms, and assignments to include or exclude in the group.
  • If you define the group dynamically, use a fast formula of type Payroll Relationship Group to determine the criteria that determines the payroll relationships, terms, and assignments to include in the group. Then you can individually select additional payroll relationships, terms, and assignments to include in or exclude from the group.

5) What are Work Relationship Groups?

Work Relationship Groups limit the persons processed for human resources and reporting. For example, you can use work relationship groups in custom extracts. If you define the group statically, select the work relationships, terms, and assignments to include or exclude in the group. If you define the group dynamically, use a fast formula of type Work Relationship Group to determine the criteria that determines the work relationships, terms, and assignments to include in the group. Then you can individually select additional work relationships, terms, and assignments to include in or exclude from the group.

6) What are Deduction Card Groups?

Deduction Card Groups are read-only. They are automatically created when deductions cards are created. For example, in the UK, they are used for year-end processing.

7) How to include or exclude an employee assignment from a payroll process?

Create a payroll relationship group to include or exclude employees from payroll processes or reports. In Oracle HRMS in EBS this functionality was called Assignment Set.

  1. Navigate to Payroll Calculation work area.
    2. Open Manage Object Groups task.
    3. Click on Create icon to create a new record.
    4. In Create Object Group pop-up enter a name, select Payroll Relationship Group for Type, click on Static radio button. Click Continue.
    5. In Create Object Group page select appropriate Start Date.
    6. In Object Group Parameter section click on magnifying glass under Value and select a payroll. Click Next.
    7. Under Payroll Relationship, Term or Assignment Inclusions and Exclusions click on green plus to add a new record, then click on magnifying glass.
    8. In Search and Select pop-up select needed record. Click on the hyperlink of the number on the first column.
    9. See the record that has been added to the inclusion or exclusion.
    10. Click on Save and Submit.

What is the best practice for the use of Payroll Relationship Group?

When payroll process completes and there are several employees in error, you can rollback or mark for retry these employees either individually in the View Payroll Process Results page or by submitting a Rollback process or Mark for Retry process for a specific payroll relationship group.

Oracle Fusion Payroll delivers several types of involuntary deduction which are available for the element creation:

  • Bankruptcy
  • Child Support
  • Creditor Debt
  • Educational Loan and Debt Collection Improvement Act (DCIA)
  • Garnishment
  • Spousal Support and Alimony
  • And tax levy


by maahmed






fusion hcm data loader steps

HCM Data loader prerequisite setup steps:
1) Configure HCM Data Loader
and set the Data loader scope : Full mode
2) Add Human Capital Management integration specialist Role and/or Human capital management application Administrator
3)Download the HCM dataloader documentation template from oracle support.
`BusinessObject Documentation  DOC ID :2020600.1
4) Identify the mandatory columns to load Business Object.
5)Prepare .dat file
6) Save .dat
7) Zip the file
8) Set the source system owner in manage common Lookup: HRC_SOURCE_SYSTEM_OWNER
9) Go to navigator work area under My workforce section Select Data Exchange –> HCM DATA LOADER –> Import and Load data –>Import file–> Submit Business Object

for queries contact 


What is fusion Application

Oracle Fusion Applications is an all-encompassing(clouding)  suite of Oracle applications built for comprehensive business tasks such as enterprise resource planning (ERP), customer relationship management (CRM) and human capital management (HCM).

Fusion Applications has many different modules catering to different aspects of business functionality. In addition to CRM and HCM, modules include applications for financials, procurement, Governance, Risk and Compliance (GRC) and supply chain management (SCM). Customers can adopt one or more of these modules and run them in their own data center or in a hosted or cloud computing environment.

Initially announced in 2005, Oracle didn’t make Fusion Applications generally available until 2011. The project was hampered by several delays that were in part due to Oracle integrating portions of several applications into the portfolio. Many of those applications – including J.D. Edwards, PeopleSoft and Siebel – were gained by Oracle through acquisitions.

Fusion Applications is built on top of Oracle’s own middleware platform.

Common tasks used during fusion hcm implementation

  1. Manage Enterprise HCM Information
  2. Manage Legal Entity HCM Information
  3. Manage Legal Addresses
  4. Manage Legal Entity
  5. Manage Location
  6. Manage Divisions
  7. Manage Departments
  8. Manage Business Unit
  9. Manage Actions
  10. Manage Job
  11. Manage Grades
  12. Manage Profile Options
  13. Manage Gallery Portrait
  14. Manage Person Types
  15. Manage Common Lookups
  16. Manage Review Periods

Ahmed fusion hcm technical support post any queries regarding ebs & fusion

AHMED ORACLE HCM TECHNICAL …maahmed09@gmail.com

HCM Data loaders

Data loader overview

Roles required for performance HCM data loader activities

Hcm data loader data flow

Who can load data using hcm data loader

Supported key types

Zip file structure

Data file structure

Data loader business objects and file formats

Data loader data consideration

Data loading using spreadsheet

Payroll data loader

Data extract

Creating an extract

Adding filter criteria

Creating rtf templates

Creating bi publisher report template

Creating extract delivery options

Running a simple extract process

Explore oracle enterprise repository


HCM cloud BI tools

Data models

Data sources

Bi publisher architecture


Data models

Data sources


Steps for personalization

Sandbox manager


Customization layers

Editing pages

Managing customizations

Rolling back, downloading and uploading..



Approval policies

Approval types

Manage approval groups for hcm

Approval structure

Oracle bpm worklist

Approval rules


Role types and role inheritance

HCM security profile types

Tips for customizing oracle fusion hcm

Assign security profiles to roles

Automated user account creation in oracle identity manager

Data roles in fusion hcm…



guys thank u so much for showing immense interest in sharing the knowledge …