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.
See: Reports and Processes in Oracle HRMS, Oracle HRMS Configuring, Reporting, and System Administration Guide
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.
Yes. Oracle Payroll supports many country specific models of taxation, including the local, federal and state tax requirements of organizations operating in the US.
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.
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.
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.
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.
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.
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 |
You must link the Pay Related Social Insurance elements to the appropriate payrolls before you enter them for employees and include them in payroll runs. If you have set up segments of the Cost Allocation key flexfield to receive entries at the element level, you should enter these account codes in the Element Link window when linking these elements to your payrolls.
Category code elements can receive direct results in addition to indirect results. This is because you may need to correct end of year balances.
You must make sure that if two balances are dependent on each other then changes to one balance are also made to the dependent balance. For example, if you change PRSI Employer, you must also make the same change to PRSI Employer Arrears. This applies to initialization, and to subsequent balance adjustments.
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:
Private Use of Company Vehicle
Free or Subsidized Accommodation
Free Use of Employer Assets
Preferential Loans
Other Reportable Items (recurring and non recurring)
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:
Recurring
Taxable value is spread over the pay periods in which the benefit is received
Non recurring
Taxable value is processed within the period the benefit is received
Oracle HRMS calculates the Notional Pay for certain Benefits in Kind as follows:
Private Use of Company Vehicles
The notional pay value on which PAYE and PRSI is applied is the cash equivalent of the private use of the company vehicle. This is calculated by applying a percentage based on business mileage to the Original Market Value (plus value of any accessories) of the vehicle. Any contributions made by the employee are offset against the notional pay value.
Note: If the vehicle is classed as a Van, a fixed percentage declared by the Revenue Commission is applied
Free or Subsidized Accommodation
The notional pay value is the sum of any expense incurred by the employer in relation to the provision of the accommodation and the annual value of the use of it. Any contributions made by the employee are offset against the notional pay value.
Free Use of Employer Assets
If an asset, which continues to belong to the employer, is used by an employee then the notional pay value is a Revenue Commission declared percentage of the market value of the asset when it was first provided as a benefit to the employee. Any contributions made by the employee are offset against the notional pay value.
Preferential Loans
The notional pay value is the difference between the amount of interest paid or payable on the preferential loan in the tax year and the amount of interest which would have been payable in the tax year if the loan had been subject to the relevant rate specified by the Revenue Commission. Any contributions made by the employee are offset against the notional pay value.
Oracle HRMS provides the following predefined Information classification elements to enable you to process Benefit in Kind:
IE BIK Accommodation
IE BIK Arrearage
IE BIK Company Vehicle
IE BIK Company Vehicle Retro
IE BIK Company Vehicle Details Retro
IE BIK Employer Asset
IE BIK Non Recurring Reportable Items
IE BIK Preferential Loan
IE BIK Recurring Reportable Items
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 | Enter either:
|
Total Mileage | Enter either:
|
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 | Enter either:
|
Total Mileage | Enter either:
|
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 Run | Enter either:
|
Total Mileage for Run | Enter either:
|
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:
|
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:
|
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:
|
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. |
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.
The accrual and subsequent recovery of arrearage appears on the Statement of Earnings. In this example, the following assumptions are made:
Standard Rate Cut Off = 500.00 Euros
Tax Credit = 50.00 Euros
Net Salary Protected = 300.00 Euros
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 |
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.
IE Gender PayGap Ordinary Pay
IE Gender PayGap Bonus Pay
IE Gender PayGap 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.
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 :
Small Benefit
Remote Working Daily Allowance
Travel and Subsistence
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
You must do the following to set up Benefit in Kind Processing:
Create a new non-recurring element for your medical benefit or for each (non-medical) BIK, as required.
Assign the element a primary classification of Information and priority of 1262.
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
Click Input Values to create an input value with Benefit Value as the Name, and Money as the Units.
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.
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
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
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
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) */
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.
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
Select the payroll for which you want to see the information.
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.
Select the assignment set.
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.
Select a start date for your report.
Click Submit.
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.
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:
Weekly Basis – Default.
Cumulative Basis – Similar to PAYE (use of cumulative income and cumulative thresholds).
Emergency Basis – 7% on all USCable income.
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.
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
Navigate to the People window - People > Enter and Maintain.
In the Find People window, enter the name or PPS number of the person you wish to exempt and click Find.
In the People window, click Assignment.
In the Assignment window that displays, click Entries.
In the Element Entries window that displays, select IE USC Element and click Entry Values.
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.
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:
Enter the required Irish tax information.
See:Entering Business Group Information, Oracle HRMS Enterprise and Workforce Management Guide
Enter Irish statutory information.
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
Run your payroll.
Run the IE Legislative Reports Generator
Running the IE Payroll Submission Reconciliation Report Process
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:
Define your Irish Termination Lump Sum Element.
Define the input values for your Irish Termination Lump Sum Element.
Link the IE Termination Lump Sum Element to your payroll.
See:Defining an Element Link, Oracle HRMS Compensation and Benefits Management Guide
Run your payroll.
Produce payslips for your employees.
Self- Service employees can view their own payslips online.
See:Online Payslip, Oracle HRMS Payroll Processing Management Guide
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
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.
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
Create an assignment set for the set of assignments to be processed by RetroPay and also create element links for the above elements.
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
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.
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
Select IE Legislative Reports Generator in the Name field.
Select the applicable payroll. You can specify a single payroll or all the payrolls within the consolidation set.
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.
Enter a start date and an end date for the process.
Click Submit.
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
Select the Payslip Advice Report in the Name field.
Enter the date from which you would like to print the data for the payslip in the Start Date field.
Enter the date till which you would like to print the data for the payslip in the End Date field.
Select the payroll in the Payroll field.
Select the consolidation set in the Consolidation Set field.
Select the assignment set in the Assignment Set field.
Select the preferences for viewing and generating the report in the Sort Order fields 1 to 5.
Choose the Submit button.
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
Select the applicable payroll. You can specify a single payroll or all the payrolls within the consolidation set.
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.
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.
Select the payment method.
In the Process Date field enter the processing date. This is the day before payment is made to the employee accounts.
Enter the employer PayPath information.
Enter the employer file number to enable the bank to make payments.
Click Submit.
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:
Navigate to the Organizational Payment Method window (Payroll => Payment Methods).
Define a new organization payment method of the type SEPA, with the Third Party Payment check box deselected.
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.
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.
Navigate to the Personal Payment Method window (People => Enter and Maintain => Query the employee => Assignment => Others. Select Pay Method from the list.)
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.
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
Run the IE SEPA XML File and Report process from the Submit Requests window.
In the Name field, select the report name.
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
Select the applicable Payroll, Consolidation Set and Process Date.
Click OK.
Click Submit.
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
Select Payments Summary Report in the Name field.
Click in the Parameters field to open the Parameters window.
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.
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.
Click OK and then click Submit.
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:
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
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
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
Enter the mandatory declarant details
See: Entering an Assignment (Assignment Window), Oracle HRMS Workforce Sourcing, Deployment, and Talent Management Guide
Enter employer level data, using the EHECS Information window.
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.
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
Enter IE EHECS Report in the name field.
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.
Click OK and Submit to generate an XML output.
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.
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.
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:
Specify the reference year.
Specify the reference month.
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.
Enter the employer name.
Select the payroll. This is an optional field.
Select the assignment set. This is an optional field.
Select the occupational category. This is an optional field.
Enter the declaration date.
Select if address change is applicable.
Specify a value in the Send To Employee field.
Enter applicable comments. This is an optional field.
Before you generate the Gender Pay Gap report, you must set up the following:
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
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
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
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:
In the Name field, select IE Gender Pay Gap Archiver. The Parameters window opens.
Select Employer PAYE Reference from the list of values. It is a mandatory parameter.
Select the payroll from the list of values.
Enter the end date or the snapshot date (in the format 30-JUN-YYYY). It is a mandatory parameter.
Click OK.
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:
In the Name field, select IE Gender Pay Gap Report. The Parameters window opens.
Select the archive request ID. This is a mandatory parameter.
Click OK.
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:
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
Run the IE ERR Archive process to archive the data. Verify the output for warnings or errors from the archive process.
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.
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
In the Name field, select IE ERR Archive process.
Select the employer PAYE reference in the business group. The default value is NA.
Select the payroll for the given employer PAYEE reference.
Select from the following request type:
Line Item Delete
ERR Submission
ERR Submission & Line Item Delete
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
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.
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.
Select Yes to run the process in debug mode.
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.
Click Ok and then click Submit.
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:
In the Name field, select IE ERR Report.
Select the request ID of the IE ERR Archive processes. This step is mandatory.
Select Yes to run the process in debug mode.
Select the person name in the selected Archive Request ID.
Click Ok and then click Submit.
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:
In the Name field, select the IE Rollback.
Select the year.
In the Payroll Process field, select the IE ERR to roll back.
Select the process type as Magnetic Report.
Select the assignment set.
Click OK and then click Submit.