Payroll Statutory Deductions and Reporting

Payroll Statutory Deductions and Reporting Overview

Oracle Payroll enables you to calculate an employer's tax liability and deduct the appropriate sums from employee earnings. You can calculate employer and employee tax liabilities for all the taxes and statutory deductions that are applicable to your country. For example, this includes employer liability for state taxes such as State Unemployment Insurance and employee liability for federal, state and local taxes in the US, PAYE and NIC in the UK, PAYE, PRSI and USC in Ireland, Social Security, Unemployment and Complementary Pension in France, Standard and Special tax and Social Insurance in the Netherlands, and so on.

In each instance, Oracle Payroll enables you to enter details of the tax liability and process it at regular intervals.

Reporting on Payroll Statutory Deductions

See: Reports and Processes in Oracle HRMS, Oracle HRMS Configuring, Reporting, and System Administration Guide

Payroll Statutory Deductions and Reporting

Oracle Payroll allows you to process tax and insurance deductions for employers and employees, and helps you comply with the legislative requirements applying to your organization.

Is Oracle Payroll flexible enough to calculate different legislative taxes?

Yes. Oracle Payroll supports many country specific models of taxation, including the local, federal and state tax requirements of organizations operating in the US.

Is the entry of tax details flexible enough to meet my organizational needs?

Yes. You can calculate taxes for different types of employer to represent the diversity of your organization. You can also make retrospective adjustments to allow for overpayments and underpayments.

Is Oracle Payroll capable of processing the latest taxation updates?

Yes. The details of taxation policy and social security entitlements are constantly changing, but Oracle Payroll is always promptly updated so that your processing includes the most recent updates.

Can Oracle Payroll transmit PAYE information electronically? (UK only)

Yes. EDI allows two-way electronic transmission of documents between the Inland Revenue and employers. Oracle UK Payroll has developed a specified formatted file that, if used in conjunction with third party software, can be transmitted electronically to the Inland Revenue.

Can you record P11D details and submit an annual return? (UK Only)

You can use Oracle HR to update your records throughout the year to show all the Class 1A National Insurance contributions for which your organization is liable. You can make this information available to employees so that they can preview their NI liabilities. You can then generate a report to view the final details and you can submit the complete and validated records to the Inland Revenue to comply with all reporting requirements.

Payroll Statutory Deductions and Reporting

Pay Related Social Insurance (PRSI) Contributions in Oracle Payroll

Oracle Payroll provides as startup data all the elements, balances and other components you need to correctly administer PRSI. It also provides legislative upgrades to keep your payroll processing up to date with current legislation. It uses the exact percentage method to calculate PRSI.

The system provides the balance PRSIable Pay, which includes the dimensions to correctly sum up all element feeds during the correct tax period dates. These element feeds come from the elements you define as balance feeds for this balance.

You can include employees in more than one payroll run each processing period. Oracle Payroll's calculations for this are based on total PRSIable earnings for the period, reduced by any PRSI already paid in the period.

Note: If selecting the Social Benefits flag on the PRSI tab of the Tax Information window, make sure you choose the sub class A2, in the Overridden Subclass list of values, instead of A1.

PRSI Elements Supplied as Startup Data

The following table shows the Pay Related Social Insurance elements supplied as part of startup data.

Name Type Classification Priority
IE PRSI Recurring Information 10300
IE PRSI Employer Non-Recurring Employer Charges 10302
IE PRSI Detail Non-Recurring PRSI 10302

Benefit in Kind

From 1st January 2004, PAYE and PRSI must be paid by employees (PRSI is also payable by employers) on the taxable value of the following types of benefit in kind and non-cash benefits provided by their employer:

Oracle HRMS enables you to derive or accept a declared value for notional pay of Benefits in Kind provided to an employee (for Company Vehicle, Accommodation, Use of Assets and Loans) and process the relevant contributions for PAYE and PRSI, using the calculation methods recommended by the Revenue Commission.

For Other Reportable Items, Oracle HRMS accepts a declared Taxable Value and depending on whether the benefit is a one off or ongoing:

Notional Pay

Oracle HRMS calculates the Notional Pay for certain Benefits in Kind as follows:

Benefit in Kind Elements Input Values

Oracle HRMS provides the following predefined Information classification elements to enable you to process Benefit in Kind:

Input Values for each Benefit in Kind element

IE BIK Accommodation

Field Entry in Field
Address ID Choose from the list of values
Annual Market Rental Value Annual value
Annual Furniture Value Annual value
Annual Incidental Expenses Annual value
Annual Employee Contribution Annual value. This is offset against the calculated taxable value for the tax year.
Rental Start and End Dates Appropriate dates. If the employee does not receive this benefit for the full year, these dates are used to pro-rata the value.
Landlord Organization Choose from the list of values

IE BIK Arrearage

Field Entry in Field
Net Salary Protected The amount of net salary that is protected from Benefit in Kind Arrearage Recovery

Caution: This will not protect the Net salary if Benefit in Kind processing actually reduce the Net salary to zero or create an arrearage. You should only use this element to spread the recovery of an amount over a number of periods.

IE BIK Company Vehicle

Field Entry in Field
Vehicle Allocation Choose from the list of values
Calculation Method Choose from:
  • Business Mileage for Period

  • Declared Annual Business Mileage

  • Alternative Method

Business Mileage Enter either:
  • An annual amount if you have chosen either the Declared Annual Business Mileage or Alternative Method

  • A period amount if you have chosen the Business Mileage for Period calculation method

Total Mileage Enter either:
  • An annual amount if you have chosen either the Declared Annual Business Mileage or Alternative Method

  • A period amount if you have chosen the Business Mileage for Period calculation method

Days Unavailable in Period Amount of days that the vehicle is unavailable to the employee or, employee's family for private use. This figure is added to the cumulative figure for Days of Unavailability.

IE BIK Company Vehicle Retro

Fields Entry in Fields
Vehicle Allocation Choose from the list of values
Calculation Method Choose from:
  • Business Mileage for Period

  • Declared Annual Business Mileage

  • Alternative Method

Business Mileage Enter either:
  • An annual amount if you have chosen either the Declared Annual Business Mileage or Alternative Method

  • A period amount if you have chosen the Business Mileage for Period calculation method

Total Mileage Enter either:
  • An annual amount if you have chosen either the Declared Annual Business Mileage or Alternative Method

  • A period amount if you have chosen the Business Mileage for Period calculation method

Days Unavailable In Period Amount of days that the vehicle is unavailable to the employee or, employee's family for private use. This figure is added to the cumulative figure for Days of Unavailability.

IE BIK Company Vehicle Details Retro

Fields Entry in Fields
Taxable Value for Run Annual taxable value for the run
Vehicle Allocation Id The vehicle allocation ID number
Calculation Method Choose from:
  • Business Mileage for Period

  • Declared Annual Business Mileage

  • Alternative Method

Business Mileage for Run Enter either:
  • An annual amount if you have chosen either the Declared Annual Business Mileage or Alternative Method

  • A period amount if you have chosen the Business Mileage for Period calculation method

Total Mileage for Run Enter either:
  • An annual amount if you have chosen either the Declared Annual Business Mileage or Alternative Method

  • A period amount if you have chosen the Business Mileage for Period calculation method

Days Unavailable in Period Amount of days that the vehicle is unavailable to the employee or, employee's family for private use. This figure is added to the cumulative figure for Days of Unavailability.
Available Days for Run Amount of days that the vehicle is available to the employee or, employee's family for private use.
Declared Bus Annual Mileage The annual amount you enter as the Declared Annual Business Mileage
Declared Tot Annual Mileage The annual amount you enter as the Declared Total Annual Mileage

IE BIK Employer Asset

Field Entry in Field
Asset Type Choose from the list of values
Asset Value Value of the asset when it was first allocated to the employee
Annual Employee Contribution Annual value. This is offset against the calculated taxable value of the asset for the tax year.
Asset Provision Start and End Date Appropriate dates. If the employee does not receive this benefit for the full year, these dates are used to pro-rata the value.
Switch Over Date Use this for an ongoing benefit if the assignment transfers payrolls during the year and the new payroll is set to a different frequency and period dates to the previous payroll. Enter the period start date of the first period of the financial year of the original payroll.

IE BIK Non Recurring Reportable Items

Field Entry in Field
Reportable Item Type Choose from the list of values
Item Description Description of Item
P11D Report Section Choose from:
  • Non Cash Benefits

  • Cash Benefits - Expenses

  • Cash Benefits - Discharge of Employee's Liability

  • Other Benefits

Benefit Date The date on which the employee receives the item. This is for information only.
Benefit Value The value of the item
Annual Employee Contribution Annual value. This is offset against the calculated taxable value of the asset for the tax year.

IE BIK Preferential Loan Details

Fields Entry in Field
Preferential Loan Type Choose from:
  • Principal Private Residence Loan

  • Other Loan

Preferential Loan Reference Reference for the loan for information purposes
Loan Start and End Dates Appropriate dates. If the employee does not receive this benefit for the full year, these dates are used to pro-rata the value.
Annual Initial Loan Amount This is either the Initial or Average Loan amount depending on what figure the notional pay is being calculated on
Annual Interest Charges The monetary amount of annual interest charged
Effective Rate of Interest The interest rate applicable. This is for information and reporting purposes.
Switch Over Date Use this for an ongoing benefit if the assignment transfers payrolls during the year and the new payroll is set to a different frequency and period dates to the previous payroll. Enter the period start date of the first period of the financial year of the original payroll.
Employee Contribution Annual value. This is offset against the calculated taxable value of the asset for the tax year.

IE BIK Recurring Reportable Items

Fields Entry in Field
Reportable Item Type Choose from the list of values
Item Description Description of Item
P11D Report Section Choose from:
  • Non Cash Benefits

  • Cash Benefits - Expenses

  • Cash Benefits - Discharge of Employee's Liability

  • Other Benefits

Benefit Start and End Dates Appropriate dates. If the employee does not receive this benefit for the full year, these dates are used to pro-rata the value.
Benefit Value The annual benefit value of the item
Annual Employee Contribution Annual value. This is offset against the calculated taxable value of the asset for the tax year.

Benefit in Kind Arrearage

The predefined element IE BIK Arrearage enables you to track the recovery of PAYE and PRSI contributions that are paid by the employer on behalf of the employee. This arrearage occurs when the employee is unable to pay the contributions at the time of the Benefit in Kind processing due to insufficient funds. You must create a standard link for this element for the tracking to occur automatically.

Oracle HRMS continues recovery of the arrearage until it is all recovered. If an arrearage from a previous tax year is not recovered by the 31st March of the following year then you should create a Non Recurring Benefit in Kind for the amount of outstanding arrearage on the 1st April. Oracle HRMS still continues to recover the outstanding arrearage and the new element taxes the amount of outstanding arrearage in the form of a loan.

Important: If the arrearage still remains unpaid by the end of the year after the benefit was given, then you should use an alternative process of recovery.

Note that, for costing purposes, IE BIK Arrearage Details and IE BIK Arrearage Recovery Details accept the run results of the IE BIK Arrearage element.

Arrearage on Statement of Earnings

The accrual and subsequent recovery of arrearage appears on the Statement of Earnings. In this example, the following assumptions are made:

Period 1

Payment Amount Deductions Amount
Earnings 1000.00 PAYE 1940.00
IE BIK Taxable and PRSIable 4000.00 PRSI 450.00
    IE BIK Arrearage -1390.00
    IE BIK Taxable and PRSIable 4000.00
Total Payments 5000.00 Total Deductions 5000.00
    Net Pay 0.00

Period 2

Payment Amount Deductions Amount
Earnings 1000.00 PAYE 302.00
IE BIK Taxable and PRSIable 100.00 PRSI 103.00
    IE BIK Arrearage Recovery 295.00
    IE BIK Taxable and PRSIable 100.00
Total Payments 1100.00 Total Deductions 800.00
    Net Pay 300.00

Gender Pay Gap Reporting

Employers provide an annual report on the pay differences between female and male employees, including any bonuses. The archived data includes the assignments with a status other than Terminate Assignment on the end date of 30 June.

Oracle provides the balances to store data for Ordinary Pay, Bonus Pay, and BIK Pay.

The balance dimension, _ASG_PAYE_REF_GPR_YTD holds the ordinary pay, bonus pay, benefits in kind pay, actual working hours at the assignment level in a 12-month pay period preceding the end date.

Enhanced Reporting Requirements

Employers must report certain payment details made to employees and directors to the Revenue electronically on or before the payment date. The Enhanced Reporting Requirements (ERR) include :

Oracle HRMS (Ireland) provides elements, archive process, and a report that details the expenses and benefits paid by the organization for their employees. You can use the archive process to archive the details and the generate a JSON file that employers submit to the Revenue through Revenue Online Services (ROS).

See: Predefined Elements

See: Running the IE ERR Archive Process

See: Running the IE ERR Report

Setting Up Benefit in Kind Processing

You must do the following to set up Benefit in Kind Processing:

  1. Create a new non-recurring element for your medical benefit or for each (non-medical) BIK, as required.

    1. Assign the element a primary classification of Information and priority of 1262.

    2. Enter a unique name and reporting name that includes a unique prefix and that will not conflict with any predefined elements. For example, use your company identifier_medical or your unique prefix _gifts.

    See: Defining an Element

    If you already offer your employees medical BIKs and record these medical benefits together with other BIKs using the IE BIK Other Reportable Items (Non-Recurring) element, then you must change your existing BIK set up to meet changed statutory requirements. You must create a new user-defined element for medical benefits and use this to feed a new predefined IE BIK Medical Insurance balance. You must also create new information elements and balances for each benefit that you currently record using the IE BIK Other Reportable Items (Non-Recurring) element to be able to report these items individually. Ensure you feed the elements to the respective balances you create.

    Important: You must set up your medical BIKs in this way to meet statutory P35 reporting requirements

  2. Click Input Values to create an input value with Benefit Value as the Name, and Money as the Units.

    See: Defining an Element's Input Values

  3. In the Balances window, create a balance for each BIK (non-medical) that you have created in the previous steps. Assign each balance a name that is consistent with the user-defined element name, e.g. your unique prefix_gifts.

  4. Link the following elements to your Payroll:

    • IE BIK Company Vehicle

    • IE BIK Accommodation

    • IE BIK Employer Asset

    • IE BIK Preferential Loan

    • IE BIK Non Recurring Reportable Items

    • IE Recurring Reportable Items

    • IE BIK Arrearage (link as a Standard element)

    See: Defining Element Links, Oracle HRMS Compensation and Benefits Management Guide

  5. Enter your vehicle details into the Vehicle Repository and then allocate vehicles to your employees. You must provide the following details:

    • Make

    • Model

    • Registration Number

    • Vehicle Type

    • Date of Registration

    • List Price

    • Accessory Value at Start Date

    See: Vehicle Repository, Oracle HRMS Compensation and Benefits Management Guide

  6. Update the following lookups:

    • IE BIK Asset Types

    • IE BIK Reportable Item Type - use this lookup type to define new benefits items or view the existing benefit items when writing a formula.

    See: Adding Lookup Types and Values, Oracle HRMS Configuring, Reporting, and System Administration Guide

  7. Create a formula and attach it (as described in the next step) to the IE BIK Other Reportable Item Details element. This element will feed your new information element created in step 1, which will in turn feed a new predefined IE BIK Medical Insurance balance or your new user-defined balances.

    Here is an example of a formula (assume that the lookup code is Med for Medical Insurance) that you can use to report the medical insurance benefits:

    inputs are reportable_item_type(text), Taxable_Value_for_Run
     l_medical_ins =0
     if ( reportable_item_type = 'Med') then
      (
        l_medical_ins = Taxable_Value_for_Run
       )
       return l_medical_ins
    /* similarly customer can append similar code for different benefits
       (reportable item types) */

    Here is an example of a formula (assume you use the lookup code Gift for gift BIKs) that you can use to report on the gift benefit:

    inputs are reportable_item_type(text), Taxable_Value_for_Run
     l_gift =0
     if ( reportable_item_type = 'Gift') then
      (
        l_gift = Taxable_Value_for_Run
       )
       return l_gift
    /* similarly customer can append similar code for different benefits
       (reportable item types) */
  8. In the Formula Results Rules window, attach the formula to IE BIK Other Reportable Item Details. In the Formula Results region, create an indirect result for the new element created in step 1 and an input value for l_medical_ins and l_gift.

Running the Benefit in Kind Arrearage Report

If you have made employer contributions towards PAYE and PRSI deductions on behalf of employees who are unable to make payments, you must report your contributions to the Revenue on the Benefit in Kind Arrearage report. This report summarizes the outstanding amounts owed by employees, and the amounts that they have repaid. You can produce reporting details for the current and previous financial years.

You run this request from the Submit Request window.

To run the Benefit in Kind Arrearage Report

  1. Select the payroll for which you want to see the information.

  2. Confirm which consolidation set you want to use. There is a default consolidation set for your business group, but you can select a different consolidation set if you want to.

  3. Select the assignment set.

  4. Select the preference for viewing and generating the report in the Sort Order field. You can view the report by employee number, name or PPS Number.

  5. Select a start date for your report.

  6. Click Submit.

Configuring and Exempting Employees from USC (Universal Social Charge)

Configuring USC (Universal Social Charge)

To configure USC, you need to create a standard element link for the new predefined element IE USC Element effective 1 Jan 2011 for each of your business group payrolls. When you do this, the application automatically processes the USC for employees effective from 1 Jan 2011. The USC amount calculated by the IE USC Element reduces the Total Pay of the employee, but does not affect the pay on which the application calculates the Tax and PRSI.

Calculating USC (Universal Social Charge)

The Revenue will advise employers of each employee's basis of calculation, individual thresholds, and rates on the RPN or TFA certificate. The Employer is obliged to deduct USC according to the instructions received from the Revenue.

The basis of calculation consists of the following three types:

If an exemption from USC applies, this will be stated on the P2C. Employers are not to apply the lower rates or exemption (i.e. 0% on 4004) threshold themselves, but must instead operate strictly on the figures stated on the P2C issued by the Revenue.

Exempting Employees from USC (Universal Social Charge)

To exempt any employee from the USC calculation or to enter your own value for the USC as an override, navigate to the assignment's element entry for IE USC Element.

To exempt employees from USC

  1. Navigate to the People window - People > Enter and Maintain.

  2. In the Find People window, enter the name or PPS number of the person you wish to exempt and click Find.

  3. In the People window, click Assignment.

  4. In the Assignment window that displays, click Entries.

  5. In the Element Entries window that displays, select IE USC Element and click Entry Values.

  6. In the Entry Values window, enter the following details to exempt employees from USC:

    • Amount at First Band - Enter an amount here to specify the USC at the first band and to ensure the application does not calculate the USC.

    • Amount at Second Band - Enter an amount here to specify the USC at the second band and to ensure the application does not calculate the USC.

    • Amount at Third Band - Enter an amount here to specify the USC at the third band and to ensure the application does not calculate the USC.

    • Exemption Without Refund - Select Yes to automatically calculate the USC as 0 in this period.

    • Exemption With Refund - Select Yes to automatically calculate the USC as 0 in this period and to refund the entire USC amount deducted this year.

    Note: If you select Yes for both the Exemption Without Refund and the Exemption With Refund, then the application refunds the annual USC amount and generates a message advising you of the same.

The IE P30 Paper Report displays the USC in a separate column from year 2011. In IE P30 XML Report, the PAYE value includes the USC value from year 2011.

Irish Legislative Reports Generator

Setting Up Multiple Employer PAYE References

Oracle Payroll enables the reporting of multiple employer PAYE references within a single business group. To achieve this, one employee record is required for each employer PAYE reference an employee is paid for in a business group.

Important: You must create a separate consolidation set for each employer.

To set up multiple employer PAYE references:

  1. Enter the required Irish tax information.

    See:Entering Business Group Information, Oracle HRMS Enterprise and Workforce Management Guide

    See: Entering Employer Information

  2. Enter Irish statutory information.

    See:Defining a Payroll

  3. Define one consolidation set for each employer and attach them to your payrolls.

    See:Defining Consolidation Sets, Oracle HRMS Payroll Processing Management Guide

    See:Consolidation Sets, Oracle HRMS Payroll Processing Management Guide

  4. Run your payroll.

    See:Starting a Payroll Run

  5. Run the IE Legislative Reports Generator

    See:Running the Legislative Reports Generator

  6. Run the IE Lookup RPN Report

  7. Running the IE New Lookup RPN

  8. Using the IE UI Upload page

  9. Run the IE JSON Response Upload process

  10. Run the Payroll Submission Archive process

  11. Running the IE Payroll Submission Reconciliation Report Process

Configuring the Termination Lump Sum

Oracle Payroll enables you to make a lump sum payment to an employee for redundancy or retirement. Using a Termination Lump Sum Element, you can identify the taxable and PRSI-able amounts within these lump sum payments.

To set up the Irish termination lump sum:

  1. Define your Irish Termination Lump Sum Element.

    See:Defining an Element

  2. Define the input values for your Irish Termination Lump Sum Element.

    See:Defining an Elements Input Values

  3. Link the IE Termination Lump Sum Element to your payroll.

    See:Defining an Element Link, Oracle HRMS Compensation and Benefits Management Guide

  4. Run your payroll.

    See:Starting a Payroll Run

  5. Produce payslips for your employees.

    See:Printing the Payslip

  6. Self- Service employees can view their own payslips online.

    See:Online Payslip, Oracle HRMS Payroll Processing Management Guide

Setting Up Payments after Termination

Oracle HRMS enables you to process payments after termination (Statutory Instrument 592), in the current year or the previous year.

To set up payments after termination in the current year

  1. For all post-termination payments made in the current year, PAYE must be calculated using the cutoff, credit, and rates as of the date of termination (provided that in the last termination payroll calculation was done on a cumulative basis for the new payments). You need to end date the PAYE element as of the termination date, to process PAYE through RetroPay. The element entries for PRSI and Income Levy remain post-termination by default.

  2. Create an element set with the list of paye-related elements given below and also create their post-termination payment element(s):

    • IE PAYE details

    • IE PAYE adjust

    • IE Net tax

    • IE PAYE Emergency Period Num

    • IE Reduced Std Rate Cut Off

    • IE PAYE at higher rate

    • IE PAYE at standard rate

    • IE Reduced Tax Credit

    • IE PAYE Used Tax Credit

  3. Create an assignment set for the set of assignments to be processed by RetroPay and also create element links for the above elements.

  4. Run the Retropay By Element process. RetroPay processes the payments and corresponding PAYE and brings forward as element entries in the payment period. In the payroll run, this is subject to PRSI and income levy in the current period and the already processed tax is also returned.

To set up payments after termination in the current year

  1. Select Emergency basis in the Tax Basis field because the PAYE calculation must be an emergency, calculated as on the date of payment.

    Note: You do not have to end date the PAYE element after termination or process the retropay.

Running the Legislative Reports Generator

You generate a legislative report by running the Legislative Reports Generator process from the Submit Requests window. This takes a snapshot of the benefits data so that you can perform all future processing on this snapshot of the data. When you take the snapshot, calculations are performed on the input values, and each input value is validated. The process also assigns a unique archive request ID for each listing. You must then supply this archive request ID when you subsequently submit the P30, P35, P60, and the Payslip Advice reports. You can use this generator to format payroll data for employees within a specific date range.

You can retry the Legislative Reports Generator process if you find any errors. When the archive process is running, it automatically calculates any input values for which amounts can be derived, and performs validation to identify any data that is not in a valid format.

Errors on a single assignment do not prevent the process from completing. However individual assignments that contain errors do not appear in your final report, and processing of these assignments is always halted at the first error to be detected.

Note: To run the generator successfully, make sure you enter the PRSI Context balance information in the SOE Balances and SOE Elements windows and not in the Payslip Information window at the business group level. If you enter the balance information in the Payslip Information window, the Legislative Reports Generator will not format the Balance and Elements information correctly.

Security Enabling

You can restrict the archiving of the employee details or an assignment by creating a security profile and attaching it your responsibility. The security profile reports only the assignments to which the security profile has access.

For an employee with multiple assignments, the process archives and reports the details even if the security profile has access to only one assignments to maintain consistency with employee and employer level balances in the payroll submission.

You run the Legislative Reports Generator from the Submit Request window.

To run the Legislative Reports Generator

  1. Select IE Legislative Reports Generator in the Name field.

  2. Select the applicable payroll. You can specify a single payroll or all the payrolls within the consolidation set.

  3. Confirm which consolidation set you want to use. There is a default consolidation set for your business group, but you can select a different consolidation set if you want to.

  4. Enter a start date and an end date for the process.

  5. Click Submit.

Running the Payslip Advice Report

Run the Payslip Advice report to get printed payslips for your employees.

Before running the report, you need to format the data using the Legislative Reports Generator.

See Running the Legislative Reports Generator

You can run the Payslip Advice Report from the Submit Requests window.

To run the Payslip Advice report

  1. Select the Payslip Advice Report in the Name field.

  2. Enter the date from which you would like to print the data for the payslip in the Start Date field.

  3. Enter the date till which you would like to print the data for the payslip in the End Date field.

  4. Select the payroll in the Payroll field.

  5. Select the consolidation set in the Consolidation Set field.

  6. Select the assignment set in the Assignment Set field.

  7. Select the preferences for viewing and generating the report in the Sort Order fields 1 to 5.

  8. Choose the Submit button.

Running the PayPath Process

Employers run the PayPath process to create a magnetic tape file containing the payment details to send to the bank.

You run the PayPath process from the Submit Requests window.

To run the PayPath process

  1. Select the applicable payroll. You can specify a single payroll or all the payrolls within the consolidation set.

  2. Confirm which consolidation set you want to use. There is a default consolidation set for your business group, but you can select a different consolidation set if you want to.

  3. Enter the start and end dates for which you want to run the process. Enter a start date to restrict the payments to unpaid prepayments from that date. If you do not enter a start date the process includes all unpaid prepayment runs.

  4. Select the payment method.

  5. In the Process Date field enter the processing date. This is the day before payment is made to the employee accounts.

  6. Enter the employer PayPath information.

  7. Enter the employer file number to enable the bank to make payments.

  8. Click Submit.

Running the IE SEPA XML File and Report Process

Running the IE SEPA XML File and Report Process

Oracle HRMS delivers the Ireland Single European Payments Area (SEPA) XML file and report that is Allied Irish Bank, HSBC, and Ulster Bank compliant. SEPA is a new European Payment standard that is common across many European countries. You must adopt this payment method to pay employees with a foreign bank account as well as employees with a domestic bank account

Note: The SEPA process does not affect the existing process for generating the PayPath file.

To set up the IE SEPA XML File and Report process:

  1. Navigate to the Organizational Payment Method window (Payroll => Payment Methods).

  2. Define a new organization payment method of the type SEPA, with the Third Party Payment check box deselected.

  3. Navigate to the Source Bank tab and enter the Bank Details for this payment method and enter the Bank Name, Account Number, Bank Identifier Code, and IBAN number of the employer.

  4. After the application creates the organization payment method, link this payment method to the payroll by adding this payment method to the valid payment methods list.

  5. Navigate to the Personal Payment Method window (People => Enter and Maintain => Query the employee => Assignment => Others. Select Pay Method from the list.)

  6. Create the personal payment method and link the organization payment method created in step 4, for all the assignments that are ready to be paid through SEPA.

  7. Navigate to the Bank Details field and enter the IE Bank Details for this personal payment method and enter the Bank Name, Account Number, Bank Identifier Code, and IBAN number of the employee.

After completing the above setup, you can use the IE SEPA XML File and Report concurrent program by entering the mandatory parameters. After the program completes, it generates the payment xml file with an .mf extension. To view the readable format paper report, click the Output button of the corresponding concurrent request.

Note: The Employer and Employee Bank Identifier Code, IBAN Number, and Country fields are mandatory fields on the xml file. Ensure that you enter these fields through the application interface, else the concurrent program completes with warnings. In such a case, open the log file to read the warning messages. You must correct these warnings by entering the mandatory data. After you correct the data, roll back the previously run concurrent request and submit the new request to generate the payment xml file again

To run the IE SEPA XML File and Report process

  1. Run the IE SEPA XML File and Report process from the Submit Requests window.

  2. In the Name field, select the report name.

  3. Click in the Parameters field to open the Parameters window. This process contains the following parameters:

    • Payroll (Mandatory)

    • Consolidation Set (Mandatory)

    • Start Date

    • End Date

    • Payment Method

    • Process Date (Mandatory)

    • Batch Booking

    • Category

  4. Select the applicable Payroll, Consolidation Set and Process Date.

  5. Click OK.

  6. Click Submit.

Payments Summary Report Window

Running the Payments Summary Report

Run this report when you want to view the payments for each payment method type and organizational payment method for a specified payroll and payroll period. The report also lists the account details for each organizational payment method.

To run the Payments Summary Report

  1. Select Payments Summary Report in the Name field.

  2. Click in the Parameters field to open the Parameters window.

  3. Select the following:

    • payroll - you can specify a single payroll or all the payrolls within the consolidation set.

    • period

    • consolidation set - There is a default consolidation set for your business group, but you can select a different consolidation set.

  4. Select the predefined template the application provides or create a new template to generate the Payments Summary Report. You must have access to XML Publisher Responsibility to create a new template. See: XML Publisher User Guide.

  5. Click OK and then click Submit.

The EHECS Report

Setting Up the EHECS Report

The Earnings Hours and Employment Cost Survey (EHECS) Report is a mandatory report that employers must submit to the Central Statistics Office (CSO) of Ireland every quarter. However, before running the concurrent program, you must set up the following:

  1. Select the occupation category from the Employment Category list in the Assignment window.

    See: Entering an Assignment (Assignment Window), Oracle HRMS Workforce Sourcing, Deployment, and Talent Management Guide

  2. If you define your own occupation categories, then you must map the occupation to the categories in the predefined user table EHECS_CATG_TAB using the Table Structures and Table Values windows.

    In the Table Structures window and query the table EHECS_CATG_TAB. Add a new row for each occupation. Ensure you enter the lookup code of the occupation as provided in the EMPLOYEE_CATG lookup.

    Note: Set your effective date to 01-JAN-2008

    In the Table Values window, query for the EHECS_CATG_TAB table and add each of the occupation codes under one of the columns, Managers/Clerical Workers/Production Workers with the values M / C / P respectively.

    If you define your own assignment categories, then you must map those assignment categories to the employment types in the predefined user table EHECS_ASG_CATG_TAB

    In the Table Values window, query for the EHECS_ASG_CATG_TAB table and add each of the assignment codes under one of the columns Apprentice Trainee/Full Time/Part Time with the same Exact and Value details as your lookup code.

    See: Predefined User Tables, Oracle HRMS Configuring, Reporting, and System Administration Guide

    See: Setting Up User Tables, Columns and Rows, Oracle HRMS Configuring, Reporting, and System Administration Guide

    See: Entering Table Values, Oracle HRMS Configuring, Reporting, and System Administration Guide

  3. Select the employment type from the Assignment Category list in the Assignment window.

    See: Entering an Assignment (Assignment Window), Oracle HRMS Workforce Sourcing, Deployment, and Talent Management Guide

  4. Enter the mandatory declarant details

    See: Entering an Assignment (Assignment Window), Oracle HRMS Workforce Sourcing, Deployment, and Talent Management Guide

  5. Enter employer level data, using the EHECS Information window.

    See: Entering EHECS Information

  6. If you use the details specified in the predefined elements, then feed the predefined balances using the Balance Feeds window or if you do not process the data as elements in your payroll, then use the EHECS Override Information window to enter this information.

    See: Entering EHECS Override Information

Running the EHECS Report

The Central Statistics Office (CSO) of Ireland requires a mandatory report - Earnings Hours and Employment Cost Survey (EHECS) every quarter. You run this report using the Submit Request window.

To run the EHECS Report

  1. Enter IE EHECS Report in the name field.

  2. Click in the parameters field and enter the following information:

    • Year - enter the year for which you want to generate the report.

    • Quarter - enter the reporting quarter (1, 2, 3 or 4).

    • Report Type - select whether the report is Original/Amended.

    • Employer - select the legal employer for whom to generate the report.

    • Payroll - select a payroll to generate the report for a subset of employees under a particular payroll.

    • Assignment Set - select an assignment set to generate the EHECS for a set of assignments only.

    • Occupational Category - select this if you want the report to consider a particular occupational category only. Note that the summary for the other categories will be reported as 0 in this case.

    • Declaration Date - enter the date of declaration.

    • Address Change - if there was a change in the employer's address during this quarter, select Yes, else select No.

    • Comments - Enter any comments that you want to report in the Survey report.

  3. Click OK and Submit to generate an XML output.

  4. Click the View Output button to view the output. The application saves the xml file in your environment's output directory. Rename this xml file as required and submit it. To view the formatted version of the report, submit the process XML Report Publisher, providing the request ID of the successful IE EHECS Report process. If you need to change any data and regenerate the report, then you can roll back and rerun the IE EHECS Report process.

  5. If the IE EHECS Report ends in an error, it is possible that there is some missing mandatory data required for reporting or the data does not meet the validation criteria. Click the View Log button to verify the reason for the failure.

Running the NES Report

Oracle HRMS supports the Ireland National Employment Survey (NES). Every year, the CSO requests a sample of employers to complete the National Employment Survey. This survey encompasses general employer information and earnings-related employee information. The employee information includes a reference year and a reference month within that year and is drawn for a sample number of employees. Oracle HRMS provides you the IE NES Report to submit the data required for the survey.

To run the IE NES Report:

  1. Specify the reference year.

  2. Specify the reference month.

  3. Enter the sample fraction. This value specifies the number of employees whose information is reported. The sample fraction can be one in one, one in two, and so on. Enter the denominator of the fraction.

  4. Enter the employer name.

  5. Select the payroll. This is an optional field.

  6. Select the assignment set. This is an optional field.

  7. Select the occupational category. This is an optional field.

  8. Enter the declaration date.

  9. Select if address change is applicable.

  10. Specify a value in the Send To Employee field.

  11. Enter applicable comments. This is an optional field.

Gender Pay Gap Reporting

Setting Up Gender Pay Gap Reporting Process

Before you generate the Gender Pay Gap report, you must set up the following:

  1. Balances are provided to store year to date ordinary pay, year to date BIK pay, and year to date bonus pay. You must set up the individual elements that feed into these balances.

    • IE Gender PayGap Ordinary Pay

    • IE Gender PayGap Bonus Pay

    • IE Gender PayGap BIK Pay

  2. Run the IE Gender Pay Gap Archiver process to archive the data that is required to generate the Gender Pay Gap Report. See: Running the IE Gender Pay Gap Archiver Process

  3. Run the IE Gender Pay Gap Report program for the selected archive process to generate a comma-delimited file. See: Running the IE Gender Pay Gap Report

Running the IE Gender Pay Gap Archiver Process

Run this process to archive the data that is required for the IE Gender Pay Gap Report. You run this process from the Submit Request window.

To run the IE Gender Pay Gap Archiver Process:

  1. In the Name field, select IE Gender Pay Gap Archiver. The Parameters window opens.

  2. Select Employer PAYE Reference from the list of values. It is a mandatory parameter.

  3. Select the payroll from the list of values.

  4. Enter the end date or the snapshot date (in the format 30-JUN-YYYY). It is a mandatory parameter.

  5. Click OK.

Running the IE Gender Pay Gap Report

Run this program to generate the IE Gender Pay Gap Report in the comma-separated value (CSV) format with data for each selected assignment. Run this report from the Submit Requests window.

To run the IE Gender Pay Gap Report:

  1. In the Name field, select IE Gender Pay Gap Report. The Parameters window opens.

  2. Select the archive request ID. This is a mandatory parameter.

  3. Click OK.

IE Enhanced Reporting Requirement

Setting Up IE ERR

Employers report the details of certain payments made to employees and directors to the Revenue electronically on or before the payment date. Oracle provides an archive process to report the expenses and benefits paid by the organization for their employees. This archive process generates a JSON file to submit to Revenue through Revenue Online Services (ROS). To produce the JSON file to send to the Revenue, perform the following steps:

  1. If you are making payments outside of the payroll system, set up the following elements. You must enter the payment details for employees or directors using element entries for the following categories.

    • IE Small Benefits Exemption

    • IE Remote Working

    • IE Travel and Subsistence

    If you are paying the benefit through the payroll system, then the values to report are selected from the run results(pay_run_results, pay_run_result_values). You must configure your existing formulas and formula result rules to feed these IE ERR elements. When you run the IE ERR Archive, you must specify the source of information as Paid Through Payroll.

    • IE Pay Small Benefits Exemption

    • IE Pay Remote Working

    • IE Pay Travel and Subsistence

  2. Run the IE ERR Archive process to archive the data. Verify the output for warnings or errors from the archive process.

    See: Running the IE ERR Archive Process

  3. Run the IE ERR Report (JSON) to submit the generated JSON file to the Irish Revenue.

    See: Running the IE ERR Report

    The application internally saves the archive information in the extra assignment information type IE_ERR_ARCHIVE_INFORMATION.

    See: Assignment Extra Information Type

Running the IE ERR Archive Process

Run the IE ERR Archive process to archive the required payment details of employees. You run this process from the Submit Requests window.

To run the IE ERR Archive process

  1. In the Name field, select IE ERR Archive process.

  2. Select the employer PAYE reference in the business group. The default value is NA.

  3. Select the payroll for the given employer PAYEE reference.

  4. Select from the following request type:

    • Line Item Delete

    • ERR Submission

    • ERR Submission & Line Item Delete

  5. If you have selected either ERR Submission or ERR Submission & Line Item Delete in the Request Type field, then select one of following options:

    • Paid through Expense System

    • Paid through Payroll

  6. Enter the period start date and end date. You can select the start and the end dates only if you selected Paid Through Expense System as the Processing Type.

  7. Select Request ID To Delete if you selected the Request Type as Line Item Delete or ERR Submission & Line Item Delete.

    Note: You can only delete the requests for which the ERR Archive process has been run.

  8. Select Yes to run the process in debug mode.

  9. If you run in debug mode, then depending on the processing type, you can select the person name.

    • If the parameter Processing Type is set to Paid Through Expense System, then select the Person Name from the given Employer PAYE Reference and Payroll.

    • If the parameter Processing Type is set to Paid Through Payroll, then select the Person Name from the given Pre-Payment Request ID.

  10. Click Ok and then click Submit.

Running the IE ERR Report (JSON)

Run this report from the Submit Requests window to generate the JSON output based on the IE ERR archive.

To run the IE ERR Report:

  1. In the Name field, select IE ERR Report.

  2. Select the request ID of the IE ERR Archive processes. This step is mandatory.

  3. Select Yes to run the process in debug mode.

  4. Select the person name in the selected Archive Request ID.

  5. Click Ok and then click Submit.

Rolling Back the IE ERR Archive Process

You can roll back the ERR Processes using the IE Rollback process. This ensures that additional information held in the Assignment EITs is also deleted and kept in sync.

You must roll back the IE ERR report process before rolloing back the archive process.

Run the IE ERR Archive Rollback process from the Submit Requests window.

To run the IE ERR Archive Rollback process:

  1. In the Name field, select the IE Rollback.

  2. Select the year.

  3. In the Payroll Process field, select the IE ERR to roll back.

  4. Select the process type as Magnetic Report.

  5. Select the assignment set.

  6. Click OK and then click Submit.