Oracle ERP – Webinar – Current & Future Trends – Business Factors & Project Execution

Youtube URL –

Here is recording from our Webinar – on Oracle ERP – Trends in business factors and project execution. Do share with your friends and subscribe KnowOracle youtube channel and Facebook group to get updates on upcoming webinars and interaction.

Oracle Financials – Now & Future ( Online Webinar )

KnowOracle ( Online Learning & Sharing community on Oracle ERP ) along with Oracle ERP Experts’ from different domains and regions coming together to present their perspective on current and future trends on Oracle ERP’s technology shift, business factors, consulting approach and career guidance.

Expected Audience : professional transitioning or about to transition to cloud erp

Dial-in number (US): (641) 715-3580
India+91 172 519 9056
Access code: 230-868-884
International dial-in numbers:
Online meeting ID: 230-868-884
Join the online meeting:
For 24/7 Customer Care, call (844) 844-1322

Submit your Questions / Queries here :
Try to join 5-10 minute earlier to avoid any technical or connectivity issues :
Moderator : Shivmohan Purohit / email – / phone-whatsapp +91 70284 76376

Expert Panet memebers’ name and detail will be posted soon


Image may contain: 3 people, people sitting and text

Webinar – on Oracle ERP trends – Now & Future

Planning to have – Webinar / Forum discussion on Oracle ERP – Now & Future trends on technology, business , consulting & career

will update more information on experts and webinar details.

meanwhile , share with friends and post your questions and queries here to include those question in webinar.

My Post (1)

fusion payroll taxes regarding.

fusion payroll taxes  particularly for us implementation team:

Vertex is used by fusion hcm for address validation and tax calculations.

vertex is a mandatory step for US payroll clients.

vertex provide address validation, these validations come from ORAMAST.txt geography file..

payroll tax  calculation rules from QFPT.dat tax file.

vertex licence is included with the  product licence to the saas customers, and others have to purchase the vertex licence.

load geographies and load payroll tax processes need to be run to get the things into effect..



fusion and ebs consultant and trainer

fusion payroll important points

Involuntary deductions and how to deal with them in fusion payroll

Involuntary deductions include court ordered deductions like wage garnishments and child support withholding orders also are involuntary deductions. These deductions are legally binding, and are withheld from gross pay.

Involuntary deductions are mandated by the courts, federal or state government. Upon receipt of formal documentation, the Payroll Office is required by law to deduct funds as directed by the agency.

Before loading involuntary deductions the following objects have to be created:

  • Third-party payment methods and payees
  • Involuntary deduction elements and their element eligibility

Information about the  payslip in fusion payroll                        

  • The Archiver needs to be run before the Payslip job.
  • Make sure that the user has Employee role.
  • You can see the payslip depending on Payslip View Date in Payroll Definition UI.
  • You can not see the future dated payslips

What is vertex used for in fusion payroll ?

Vertex is used by Fusion HCM for address validation and tax calculations

It provides address validation this comes from ORAMAST.txt (Geography file)

Payroll Tax Calculation Rules which updates comes from the file QFPT.dat (Tax file)






Ahmed Oracle HRMS payroll interview questions


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 :          


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