Oracle HRMS enables employers to meet the real time information (RTI) reporting every time a payment is made to the employee as required by HMRC. As the RTI reporting replaces End of Year reporting and In-Year filing, Oracle HRMS enables you to align employee data with HMRC data. Along with RTI, Oracle HRMS continues supporting P45, P60, and P11D reporting as they are in use.
RTI reporting collects information about tax and other deductions automatically each time you run the payroll. This could be monthly, weekly, or fortnightly. HMRC receives this automatically at the same time as the employees are paid. This reporting process gets information on those joining and leaving employment to HMRC more quickly. For example, RTI enables the date of leaving to be submitted before the final earnings information. A more accurate HRC database reduces queries and the need for recalculations of employee's tax. Additionally, HMRC receives the full amount payment due from the employer each pay period. RTI reporting means that the following procedures will be simplified or discontinued:
Issuing a P45 to all employees who leave employment.
Notifying HMRC of those employees who join.
Determining a tax code by requiring new employees to complete a P45.
Submitting end of year P14, P35, and P38A returns to HMRC.
To meet RTI reporting requirements, you can submit the following outgoing and receive the incoming XML messages:
Outgoing
Full Payment Submission
Employer Payment Summary
NINO Verification Request
Incoming
NINO Verification Reply
Full Payment Submission (FPS) to be submitted to HMRC each time the employer makes a payment to an employee. It picks up data relating to the payments processed for the relevant period for the PAYE scheme. A number of scenarios have been published by HMRC to demonstrate what values need to be reported under different circumstances. The data relates to employment within the PAYE and as such all payments and deductions are reported as this period and year to date figures. You can submit this after submitting the EAS. HMRC uses this to update their records with the YTD values for your employees. You must submit this on or before the date of payment to your employees. You can send it per Payroll within the PAYE Scheme if required. Additionally, this submission includes any company declaration details if PAYE Scheme has ceased and End of Tax year FPS. The first FPS that you submit includes:
All employees reported on the Employer Alignment Submission (EAS).
Any new starters since you submitted the EAS.
All employees who have been paid this tax year (includes all those leavers in the last tax year if they had a payment after leaving).
The subsequent FPS includes all employees that have been paid in the period being reported.
Employer Payment Summary (EPS) can be submitted where the employer needs to notify HMRC of adjustments to their overall liability. If the EPS is not submitted, then the values determined from the regular FPS submission are expected to be paid over by HMRC. Employers can make adjustments to the overall employer-level amounts due (the total PAYE / NI, which should have been paid to HMRC to cover all individual employee-level amounts). Amounts which the employer is entitled to recover for payments of SMP / ASPP and also for NIC compensation relating to statutory payments, can also be submitted via the EPS. In addition, a final declaration to be made relating to values to be reported at the end of year is covered by this XML message. This is an optional XML file to be submitted for the tax period. Additionally, this file includes any company declaration details.
NINO Verification Request (NVREQ) - an ad-hoc process which allows employers to request either a validation of existing NI numbers for employees or obtain a valid NINO for new employees. HMRC sends an acknowledgement file with a correlation ID (in case employers want to stamp the employee record for audit purposes) and then follows up by sending the verified or new NI number via the (incoming) NINO Verification Reply message.
NINO Verification Reply (NVREP) - this is a message from HMRC notifying the NI number to be used for the employee. The NVREQ message can be either a response to a NI number Verification Request (NVREQ) from the employer, or as a result of an incorrect / missing NI number on the FPS or EAS submission. Contains the NINO to be used and indicates the action to be taken by the employer. Employers must update their employee records and report this notified NI number for future submissions.
If you pay your employees via BACS, then the RTI data forms part of the BACS submission. The data is submitted at the same time as the employees' salary payment details.
Oracle HRMS enables you to use the pre or post RTI BACS file creation process to ensure that if you are not on RTI as yet, then you are not impacted by the changes introduced for RTI within the BACS file. You can continue to use the existing BACS file creation functionality that does not generate the random number which is required to accommodate the HASHing requirement within RTI. Additionally, if you are migrating your PAYE schemes in batches, then you have the option for the non-RTI PAYE schemes. You can use the RTI Uptake profile option for this purpose along with the RTI Uptake configuration type that enables you to migrate your PAYE Schemes all at once or in batches.
From 2024, HMRC no longer uses the BACS Hash, hence the random string output is not generated in the FPS file. The positions from 32 to 35 in the Field 7 of the Standard 18 BACS are filled with blanks.
See: User Profiles topic in Oracle HRMS Configuring, Reporting, and System Administration Guide and Mapping Existing Data for RTI
For further details about RTI Reporting, see My Oracle Support Note 1324671.1
Where ever possible, RTI reporting uses the current application payroll balances. However, as the RTI information goes beyond the End Of Year reporting (currently P14), the following secondary classifications and classification balances are available. You can attach elements that are already in use to the classifications to establish the feeds to these balances so that the relevant figures needed for RTI reporting are picked up.
The following tables show the secondary classifications, elements, and their balances available for RTI:
Secondary Classification | Balance Required | Description |
---|---|---|
Secondary Classification: Post Tax Pension For Existing Classification: Voluntary Deduction Description: Post Tax Pension deductions |
Classification Balance: Post Tax Pension Contributions Description: Post Tax Pension Contributions Balance Category: RTI Reporting |
Predefined secondary classification and balance to add the Pension Contribution element where it is taken as deduction from Net pay. Attach if required |
Secondary Classification: Pre-Tax Pension For Existing Classification: Pre-Tax Deductions Description: Pre Tax Pension deductions |
Classification Balance: Pre-Tax Pension Contributions Description: Pre Tax Pension Contributions Balance Category: RTI Reporting |
Predefined secondary classification and balance to add the Pension Contribution element where it is Pre-Tax deduction. Attach if required |
Secondary Classification: NI'able Free of Tax For Existing Classification: Pre-Tax Deductions Description: NI'able Deductions Free of Tax |
Classification Balance: NI'able Deductions Free of Tax Description: NIable deductions Free of Tax |
Predefined secondary classification and balance to add the pre-tax deduction elements (if these deductions affect taxable pay). Attach if required |
Secondary Classification: Free of Tax For Existing Classification: Earnings Description: Earnings Free of Tax |
Classification Balance: Earnings Free of Tax Description: Earnings Free of NI |
Predefined secondary classification to feed the existing balance to report all pay that is not subject to tax. Attach if required |
Secondary Classification: Free of NI For Existing Classification: Earnings Description: Earnings Free of NI |
Classification Balance: Earnings Free of NIC Description: Earnings Free of Tax |
Predefined secondary classification and balance to report all pay that is not subject to NIC Attach if required. |
Secondary Classification: Free of Tax and NI For Existing Classification: Earnings Description: Earnings Free of Tax and NI |
Classification Balance: Earnings Free of Tax and NI Description: Earnings Free of Tax and NI |
Predefined secondary classification and balance to report all pay that are not subject to tax nor NIC. Attach if required. |
Existing Classification: Direct Payment | Classification Balance: Total Direct Payments Description: Total Direct Payments |
Predefined balance to be fed by existing classification - Direct Payments to collect all payments classified under the Direct Payments classification. Attach if required |
Secondary Classification: Taxable Benefit Earnings Subject to NIC For Existing Classification: Earnings Description: Taxable Benefit Earnings Subject to NIC |
Classification Balance: Benefits Taxed Thru Payroll Subject to NIC Earnings Description: Benefits Taxed Through Payroll Subject to NIC as Earnings |
Predefined secondary classification and balance to add the Earnings elements for benefits that are taxed through payroll but not actually paid. Attach if required. |
Secondary Classification: Taxable Benefit Earnings NOT Subject to NIC For Existing Classification: Earnings |
Classification Balance: Benefits Taxed Thru Payroll NOT Subject to NIC Earnings Description: Benefits Taxed Through Payroll NOT Subject to NIC as Earnings |
Predefined secondary classification and balance to add the earnings elements for benefits that processed through payroll but not actually paid. Attach if required. |
Secondary Classification: Taxable Benefit Subject to NIC Information For Existing Classification Information Description: Taxable Benefit Subject to NIC Information Elements |
Classification Balance: Benefits Taxed Thru Payroll Subject to NIC Information Description: Benefits not earnings Taxed Through Payroll Subject to NIC Information |
Predefined secondary classification and balance to add the Information elements for benefits that are taxed through payroll but not actually paid and are subject to NI deductions. Attach if required. |
Secondary Classification: Taxable Benefit NOT Subject to NIC Information For Existing Classification: Information Description: Taxable Benefit NOT Subject to NIC Information Elements |
Classification Balance: Benefits Taxed Thru Payroll NOT Subject to NIC Information Description: Benefits not earnings Taxed Through Payroll NOT Subject to NIC Information |
Predefined secondary classification and balance to add the Information elements for benefits that are processed through payroll but not actually paid and are not subject to NI deductions. Attach if required. |
Secondary Classification: SNCP Earning |
Name of Classification | Associated Indirect Element | Classification Balance feed |
---|---|---|
SMP Non Payment Recovery | SMP Recovery | SMP Recovery |
SMP Non Payment NIC Compensation | SMP NIC Compensation | SMP NIC Compensation |
SAP Non Payment Recovery | SAP Recovery | SAP Recovery |
SAP Non Payment NIC Compensation | SAP NIC Compensation | SAP NIC Compensation |
SPP Birth Non Payment Recovery | OSPP Recovery Birth | OSPP Recovery Birth |
SPP Birth Non Payment NIC Compensation | OSPP Birth NIC Compensation | OSPP Birth NIC Compensation |
SPP Adoption Non Payment Recovery | OSPP Recovery Adoption | OSPP Recovery Adoption |
SPP Adoption Non Payment NIC Compensation | OSPP NIC Compensation Adoption | OSPP NIC Compensation Adoption |
ASPP Birth Non Payment Recovery | ASPP Recovery Birth | ASPP Recovery Birth |
ASPP Birth Non Payment NIC Compensation | ASPP NIC Compensation Birth | ASPP NIC Compensation Birth |
ASPP Adoption Non Payment Recovery | ASPP Recovery Adoption | ASPP Recovery Adoption |
ASPP Adoption Non Payment NIC Compensation | ASPP NIC Compensation Adoption | ASPP NIC Compensation Adoption |
Element | Balance |
---|---|
Setup SMP Recovery Balance | SMP Recovery Amount, SMP NIC Compensation |
Setup SAP Recovery Balance | SAP Recovery Amount, SAP NIC Compensation |
Setup SPP Recovery Balance | SPP Adoption Recovery Amount, SPP Adoption NIC Compensation, SPP Birth Recovery Amount, SPP Birth NIC Compensation |
Setup ASPP Birth Recovery Balance | ASPP Adoption Recovery Amount, ASPP Adoption NIC Compensation, ASPP Birth Recovery Amount, ASPP Birth NIC Compensation |
Element | Balance |
---|---|
Setup SNCP Recovery | SNCP NIC Compensation, SNCP Recovery Amount |
Setup NIC Compensation | SNCP NIC Compensation |
SNCP Recovery | SNCP Recovery Amount |
For RTI users, HMRC refers to the Payroll ID instead of Works Number in any incoming files to employers and therefore sends that in place of the Works Number. Hence, the P6/P9 update process checks if it is being run for RTI PAYE as it needs to match on the RTI Payroll ID instead of Works Number. There is no separate process for RTI users as the checks are made internally within the existing process to determine what to use for matching the assignments. The following apply to all RTI users running the P6/P9 process:
You must ensure that the RTI Uptake profile is set to either Full or Partial. When the P6/P9 process runs, the following applies:
Partial only picks up RTI Payroll ID for the PAYEs configured in the Configuration Module
Full picks up RTI ID for all the PAYEs within the business group.
When Aggregation is in place for assignments, the process updates the information received in the P6/P9 file as follows:
PAYE aggregation - updates all assignments.
NI Only aggregation - updates only those assignments with the RTI Payroll ID match.
If PAYE aggregation exists and the RTI Payroll ID is not the same across the aggregated assignments (or null against any assignment), then the process raises an error. You must examine and correct the information on RTI Payroll ID before processing the record again.
For RTI customers, HMRC does:
Not supply works number in the field ATT2 / 19 of the MOVDED record.
Instead, it supplies the RTI Payroll ID (as defined within Oracle HMRS).
You must ensure that the RTI Payroll ID is present on all assignments as follows:
Run the Populate RTI Payroll ID with Assignment Number process. See: Running the Populate RTI Payroll ID with Assignment Number
For PAYE aggregation, if you change the RTI Payroll ID manually, then ensure that it is the same across all the aggregated assignments.
If you have migrated to RTI reporting, then note the following:
There are no P14 returns for RTI users.
Running the Final FPS indicates to HMRC that this is an EOY submission.
You can send FPS Final Submission multiple times as required until 19th April.
For most employers, the final Full Payment Submission (FPS) return is made on or before 5th April when you make the final payment of earnings for the tax year.
You should indicate that this is your final submission for year through the FPS. However, if you discover on or before the 19th April, following the end of the tax year, that you need to make any amendments or corrections to the information reported you can submit an additional FPS. You must indicate on your amended FPS that this is your final submission for year. If you have to make any amendments or corrections on or after 20th April, use the RTI - Full Payment Submission Process (FPS) Amendments process. Within the year, you can make corrections to an FPS by sending a corrected FPS.
The Final FPS indicator lets HMRC know that the employer has completed their submissions for the year. You must report this on the last FPS that you submit which does not include all employees who have been reported during the tax year, but only contains records for employees who have a payment to be reported in this final run. It may be that the last FPS is reporting only a very small number of payments (if this is a supplementary run after the last main payroll of the tax year).
If the Final Submission option is set on the process parameter for EPS and/or FPS, then you must complete the Declaration parameters, otherwise HMRC rejects the file.
Use RTI - Full Payment Submission Process (FPS) Amendments process to send any amendments to employee values for the previous tax years.
Any FPS submission which is for a process in the new tax year (the payroll run / balance adjustment process is on or after 6 April), then you must use the new FPS process. You must run the EPS also for the appropriate year that the payments relate to in the same manner as the FPS.
To generate P60, you must run the RTI P60 process. See: P60 and RTI
There is no change to running the P11D processes for RTI users and you must follow the existing processes.
There are no changes to Start Of Year for RTI users and you must follow the normal processes for SOY.
Upload P6/P9 by running the existing process. For RTI users, this process determines whether to use RTI Payroll ID to match the records depending on the RTI Uptake profile value. See: P6/P9 and RTI
For information about setting up your system for RTI reporting requirements, see Setting up Real Time Information Reporting.
To meet RTI reporting requirements, you must ensure that the following are set up:
Register the following extra information types (EITs) and assign them to your responsibility:
RTI Information (Table Name parameter value while registering is PER_ASSIGNMENT_INFO_TYPES and code while assigning to responsibility is GB_PAY_RTI )
RTI New Starter Information (Table Name parameter value while registering is PER_ASSIGNMENT_INFO_TYPES and code while assigning to responsibility is GB_RTI_ASG_DETAILS)
RTI Assignment Aggregation (Table Name parameter value while registering is PER_ASSIGNMENT_INFO_TYPES and code while assigning to responsibility is GB_RTI_AGGREGATION)
Real Time Information - NINO Verification (Table Name parameter value while registering is PER_PEOPLE_INFO_TYPES and code while assigning to responsibility is RTI_NINO)
See: Running the Register Extra Information Types (EITs) Process and Setting Up Extra Information Types for a Responsibility in Oracle HRMS Configuring, Reporting, and System Administration Guide
Ensure you have the Employer Office Reference Number to enter it in the Tax Reference Details organization EIT.
Ensure that all PAYE references are available within the application as RTI is submitted per PAYE.
Passport number is the optional data item required for RTI. If this is available, then map it using the configuration values module type Passport Number. If you are using the Documents of Reference functionality, then ensure that the Document Type is passport and the Document Number is the passport number. The FPS process picks up the passport number from this field, if present.
If your employees have valid NI numbers that have been in use as verified by HMRC, then you may want to run the Pre-RTI NINO Verification process to set the NINO verified flag as a mass update. This prevents the NINO Verification request process from picking up all the employees un-necessarily when you run it for the first time.
Examine your pay or information elements to deduce if they belong to any of the items listed for reporting in the mapping of the XML fields and allocate them to the additional new secondary classification introduced as part of the RTI functionality. This ensures that the (new) balances being reported on FPS have the correct value.
Creation of the Employer Payment Summary XML requires you to submit the values for verification to an Approver who can then verify that the EPS record is correct and ready for XML. Ensure that you have approvers notification set up using workflow to the appropriate individuals so that they get the notifications to approve and verify the EPS record. The XML process does not pick up any records that have not been verified (status should be Verified). If you wish not to use the approver functionality, then you must ensure that the RTI Employer Payment Summary approval process required profile option is switched off by setting the value to No; the default is Yes.
You must run the one-time process called RTI Payroll ID Defaulting to ensure that this attribute on the new RTI Aggregation tab is populated for your existing employees. The EAS, FPS, and NINO processes pick up this field value. It is not necessary to populate this field on an on-going basis and is a one-time uptake procedure only. For further details on this process, see Running the Populate RTI Payroll ID with Assignment Number Process
To uptake the RTI option of reporting, you must set the RTI Uptake profile option with an applicable value. See: User Profiles, Oracle HRMS Configuring, Reporting, and System Administration Guide. Additionally, you need to provide values for the configuration type RTI Uptake depending on the value set for the profile option.
Once you are on RTI, ensure that you enter all new starter information using the RTI tab only. You must not use the other original pre-RTI tabs namely, New Starter, P46 Pension Notification, and P46 (EXPAT) Notification, for those PAYE schemes on RTI, as RTI reporting does not pick up information from these tabs.
Enter RTI aggregation information. See: Entering RTI Aggregation Information
Record RTI specific data using the assignment and person extra information types.
Additionally, set up your own elements that are deemed as Trivial Commutation Payments and the Payment Type for the following balances:
Trivial Commutation Type A
Trivial Commutation Type B
Trivial Commutation Type C
If there is any value in the balances, then the FPS process reports these in the FPS employment record section in pairs of type and value. It reports up to three iterations (one per type).
Map existing data using the configuration module if data required for RTI is available in your system and if you are migrating partially (staged approach for groups of PAYE Schemes). Additionally, you can choose the correct BACS process (with or without HASHing field). See: Mapping Existing Data for RTI
Run the following RTI processes to generate the RTI archive and output XML files:
Pre RTI Migration
Run the Populate RTI Payroll ID with Assignment Number Process.
Run the Pre-RTI NINO Verification Process.
Post RTI Migration
Run the Create EPS Payment Values
Run the Employer Payment Summary Process (EPS)
Run the Employer Payment Summary Reset Status
Run the Full Payment Submission Process (FPS)
Run the Full Payment Submission Output
Run the NINO Verification Request Process (NVREQ)
Run the NINO Verification Reply Upload Process (NVREP)
Run the P60 and RTI
Run the P6/P9 and RTI
Run the End of Year for RTI
Submit the RTI messages.
Oracle HRMS enables you to record the new starter information for RTI reporting. Use the New Starter (RTI) tab in the Statutory Details window. This tab combines the information for starters that is currently held in the current New Starter and P46 tabs. If you are on RTI, then you must use this tab to input the relevant data instead of the current practice of using the New Starter and P46 tabs. The New Starter RTI tab is for input of new starter declaration, pension amount, and expat information only. You must enter the P45 information using the PAYE details tab and any NI information the NI details tab. RTI reporting uses information from the PAYE details and NI details tabs. After you migrate to RTI, the following tabs will become redundant and RTI reporting does not use any information recorded in the tabs:
New Starter
P46 Pension Notification
P46(EXPAT) Notification
The New Starter (RTI) tab displays three sections which represent starter information being brought in by an employee, an ex-pat, or a pensioner. This tab combines the three types of starters' information that you need to file new starters using RTI.
To enter new starter information for RTI
Query the employee assignment and choose the Tax Information button.
Click New Starter (RTI).
In the New Starter section, the RTI Sent check box is automatically selected after you have run the FPS process to indicate that the starter information has been sent to HMRC. You can manually select it too. The record is not re-sent in subsequent FPS process. This is the same as the current new starter in-year filing (pre-RTI) process behavior.
As new starter declaration, enter what type of starter this person is where a P46 is sent. Choose from a list of values as follows:
A for First Job since 6th April
B for Only job currently
C for Have another job or pension
Select the Continue with Student Loan check box as required for continuing with student loan deductions.
In the Pensioner section, the RTI Sent check box is automatically checked after the FPS process has been run to indicate that the pensioner information has been sent to HMRC. You can select it manually too. The record is not re-sent in subsequent FPS process. This is the same as the current new starter in-year filing (pre-RTI) process behaviour.
Enter the date when the pension started. The RTI reporting process sends the starter declaration for the pensioner from the date the pension started.
Enter the annual pension.
Do not enter starter declaration but specify if the pensioner is in receipt of occupational pension.
In the EXPAT section, the RTI Sent check box is automatically selected after the FPS process has been run to indicate that the Expat information has been sent to HMRC. You can select it manually too. The record is not re-sent in subsequent FPS process. This is the same as the current new starter in-year filing (pre-RTI) process behaviour.
Do not enter the starter declaration but select the expat P46 statement from the following:
A Intention to live in the UK for more than six months.
B Intention to live in the UK for less than Six months.
C Living abroad, intend to work both inside and outside UK.
Select the EEA/Commonwealth Citizen check box as required.
Select the EPM6 (Modified Scheme) check box as required.
Enter the start date of employment in the United Kingdom.
Select the Continue with Student Loan check box as required for continuing with student loan deductions.
Note: Regarding the RTI Sent check box:
Whenever EAS process is run, the process selects the RTI Sent check box in the New starter section within the New starter (RTI) tab for all the employees picked up by the EAS process.
For new hires created after EAS process, whenever FPS process is run, the process would report the error message "Starter Declaration is Missing" if you have not entered the required data on the corresponding blocks (New Starter, Pensioner, EXPAT) in New Starter(RTI) tab.
If you have entered the data prior to running the FPS process, then the process would not report the error; instead it processes the assignment and checks the corresponding RTI Sent check box and reports the relevant values on FPS XML.
If EAS process is rolled back, then the roll back process deselects the RTI Sent check box selected earlier by the EAS program.
If FPS process is rolled back, then the roll back process deselects the RTI Sent check box selected earlier by the FPS program.
Oracle HRMS enables you to enter data required for aggregation of PAYE and NI by RTI reporting. The Full Payment Submission requires this data for processing aggregated assignments. Use the RTI Aggregation tab on the Statutory Details window.
To enter RTI aggregation information
Query the employee assignment and choose the Tax Information button.
Click the RTI Aggregation tab.
Select the RTI NI Reporting Assignment check box where there is aggregation for NI only, to indicate the assignment record used to pick up the NI YTD values for reporting in the NI section of the FPS employment record.
For NI aggregation, there are multiple employment records output to ensure that the reporting of FPS record is a per HMRC expectation. This check box is not relevant for those assignments that are set for PAYE and NI aggregation as RTI reporting process treats these assignments as one record and output as a single employment record.
Note: The RTI NI Reporting Assignment check box is enabled only when the NI Multiple Assignments check box is selected (this indicates NI only aggregation).
The Effective Date field becomes mandatory after you select the RTI NI Reporting Assignment check box.
You must change the RTI NI Reporting Assignment check box only if the assignment that was the reporting assignment for NI, is terminated. In this case, ensure that you select this check box on the new or different assignment as appropriate.
Enter the effective date to enable the RTI Reporting Assignment check box to be date tracked as the information here is not date tracked as a rule.
Note: At the time of migration to RTI, the process that populates the RTI NI Reporting Assignment check box, sets the effective date to the start of the current tax year (06-April-YYYY).
The application populates the RTI Payroll ID and the effective dates as follows:
Defaults to primary assignment number if the PAYE Aggregated Assignments check box is selected.
Defaults to assignment number of each assignment if the PAYE Aggregated Assignments check box is not selected.
Ensure that you run the Populate RTI Payroll ID with Assignment Number concurrent program to enable the application to populate the Payroll ID Effective Start Date and Payroll ID Effective End Date with the appropriate values. The application sets the effective start date to the hire date of the assignment and the effective end date to end of time (31-DEC-4712). The effective dates ensure that the track history is maintained for NI Reporting flag along with RTI Payroll ID. If the payroll ID is changed for any reason, then all assignments aggregated for PAYE must be updated with the same RTI Payroll ID. This number assists in identifying the person's ID for RTI purposes. RTI reporting process use the RTI Payroll ID for reporting the payroll ID fields on the RTI XML files sent to HMRC. Additionally, the FPS process uses this ID to report employment records as one per payroll ID in cases of aggregation of NI.
Note: Use the Populate Payroll IDs concurrent program to populate the payroll IDs if you are already on the previous version of RTI. You must run this program to ensure that the payroll IDs are correctly updated as assignment numbers for non-aggregated assignments. See: Running the Populate RTI Payroll ID with Assignment Number Process
Some data items required by RTI may already exist within your Oracle HRMS application. RTI reporting process can use and report these data items. You can map your existing data that RTI requires using the configuration types within the Real Time Information configuration module in the Configuration Values page.
You do not need to configure the following items if you are using the RTI Information assignment extra information type:
Number of Periods Covered
Irregular Employment
One-Off Payment
Normal Hours Band (Hours Worked listed above)
Receiving Occupational Pension
Ex Pat
Payment to Non-Individual
On Strike
Unpaid Absence
Off-Payroll Worker Indicator
This module is only for mapping the given information if you have it stored already in your own placeholders. The configuration module mapping ensures that the data is picked up from your placeholders and not from the RTI Information EIT.
If you are using the standard Oracle functionality of Documents of Record to hold passport information, then you do not need to configure this item as this RTI processes pick up this information automatically. However, if you have stored passport number elsewhere using your own flexfield, then map it using the Employee Details - Passport Number configuration type.
The following configuration types are predefined:
Employee Hours - The mapping is entirely optional as the RTI processes pick up the hours from assignment normal hours or if the RTI Information assignment EIT has a Normal Hours band value specified, if the configuration is not present.
Irregular Payment - The mapping is entirely optional as the RTI processes pick up the Indicator from the Irregular Payment value specified in the RTI Information assignment EIT, if the configuration is not present.
Number of Periods Covered - The mapping is entirely optional as the RTI processes pick up the Indicator from the Number Of Periods Covered value specified in the RTI Information assignment EIT, if the configuration is not present.
One-Off Payment - The mapping is entirely optional as the RTI processes pick up the Indicator from the On-Off Payment value specified in the RTI Information assignment EIT, if the configuration is not present. If you are using the User Function option, then note the following:
Provide the inputs of assignment_id and effective_date for the function to work.
Ensure that the user function returns the appropriate values as expected by the relevant data item (for example, for Flags the value Y should be returned; for Hours Worked the value of total number of hours should be returned).
FPS picks up the FF and executes it to return the value expected for the XML field in question.
Off-Payroll Worker Indicator - Use the Off-Payroll Worker indicator to flag an employee as an off-payroll worker.
Student loan deductions to not apply to off-payroll workers. This includes Plan 1 and Plan 2 student loans and postgraduate loans.
Off-payroll workers are not entitled to receive statutory payments (SSP, SMP, SAP, SPP, ShPP or SPBP).
Pensions automatic enrolment does not apply to off-payroll workers.
Secondary (employer) Class 1 NICs relating to employment of off-payroll workers are disregarded when calculating entitlement to claim the employment allowance.
The FPS submission includes the Off-Payroll Worker indicator.
Terminations are processed for an off-payroll worker in the same way as for a regular employee. A P45 will be produced after termination according to employer configurations, reporting taxable pay and other details as usual.
If a person is set up as an employee on the payroll and they also provide services which mean they become a "deemed employee" for that contract, they must have two separate employment records with different payroll IDs. The record relating to the deemed employment would have the Off-Payroll Worker indicator checked; the other would not. The two employments must be completely independent of each other and are processed and reported separately.
No aggregation of either PAYE or National Insurance applies.
Passport Number - The mapping is entirely optional as the RTI processes pick up the passport number from Documents of Records if used or configuration value mapping. The passport number is an optional field to be reported for RTI and is left blank if not present anywhere.
RTI Uptake - Use this configuration type if you have multiple PAYE Schemes and need to migrate to RTI in a phased manner. This configuration type ensures the following:
Differentiates between the BACS process to be used (Post or PRE) as the post RTI BACS process has been changed to include the random number field on the BACS record.
Allows Oracle users with a multiple number of PAYE schemes with large population of employees to migrate in a phased manner (this must be agreed first with HMRC).
Removes the need for Oracle users to choose the pre and post RTI BACS process to be utilised and prevent serious issues on employee payment through BACS.
In order to take up RTI for PAYE Schemes, you must set up the schemes on this configuration type. Mapping the schemes ensures that the schemes are processed for RTI BACS correctly. This configuration type is optional but you must use it in conjunction with the RTI Uptake profile option as follows:
If profile value is None, then there is no need to set configuration value here as the application uses the Pre-RTI version BACS process without generating the random number.
If profile value is All, then no need to set configuration value here as the application uses Pre-RTI version BACS process that generates the random number.
If the profile value is Partial, set this configuration type for each of the PAYE Schemes that are migrating to RTI.
The effective date is the date on which the PAYE Reference is going over to RTI. The RTI functionality checks this date and decides which BACS process needs to be used for the given PAYE Reference. You can create multiple configuration types one for each PAYE in question with its own effective date. For any PAYE scheme reference that does not have a configuration type set up when the profile value is Partial, then the application uses the Pre-RTI BACS process for these schemes.
To map your existing data to the required configuration type
Navigate to the Configuration Values page through Other Definitions > Configurations Values.
Query the Real Time Configuration using the search icon next to the Module Name field and select it from the Search page.
Select the applicable configuration type and click Add Configuration Values.
In the Add Configuration Values page for the selected configuration type, enter the following details:
Source - Identify the placeholder source, for example an extra information type, descriptive flexfield, or function.
Context Name - The application populates the list of values with the context names of the source specified and you can select as required.
Segment Column - If the source is an EIT or DFF, then specify the segment column that holds the applicable value.
User Function Name - If the source specified is a function, then select the function name from the list of values.
Click Apply.
If you are migrating to RTI functionality, then you need to populate the RTI Payroll ID field for your existing employees. The application defaults the payroll ID for all new employee assignments once the RTI functionality is implemented, however, prior to RTI migration, you must populate the payroll ID for all existing employee assignments to ensure that all the payroll ID's are in place for RTI reporting. Use the Populate RTI Payroll ID with Assignment Number to populate the RTI Payroll ID with either:
Assignment number as is (for non-aggregated assignments).
Primary assignment number for PAYE aggregated assignments.
This is a one-time process that you must run to ensure the existing assignments have this field populated correctly. All subsequent assignments started after RTI migration default to the appropriate assignment number taking aggregation type into account automatically. Use the Submit Request window.
To run the Populate RTI Payroll ID with Assignment Number process
Select Populate RTI Payroll ID with Assignment Number in the Name field.
Enter the following parameters:
PAYE Ref num - Select from the list of PAYE reference numbers in the organization.
Effective Date - Enter a date from which you want all employees to be picked up. This would normally be the date RTI was implemented as Live to ensure that all employees are picked up.
Oracle HRMS for UK enables you to migrate the existing normal hours bands to the revised bands. This concurrent program migrates the normal hours band recorded against the RTI Information assignment EIT to the RTI Information element's input value 'Normal Hours Band'. This enables the application to maintain the date track history.
This program migrates the normal hours band as follows:
A - A
B - B
C - D
D - E
You can run the program in Validate Only - Updates Not Applied To The Database mode first, to ensure that the program reports the expected list of employee records with appropriate normal working hour bands. If you are satisfied with the results, then you can run the process in Validate and Commit mode to commit the changes to the database.
Use the Submit Request window.
To run the RTI - GB Populate Hour Bands
Select RTI - GB Populate Hour Bands in the Name field.
Enter the following parameters:
PAYE Reference - Select from the list of all the PAYE references within the organization.
Effective Date - Enter the effective date from when to migrate the existing normal hours band. The default is 6-APR-YYYY.
Mode - Select the mode to either validate only or to validate and commit to the database.
Oracle HRMS enables you to process and report foreign tax. Employers can give foreign tax credit relief (FTCR) through the payroll where there is a foreign tax withholding obligation as well as PAYE due on the same income for employees. The Statement of Earnings (SOE), payslip, and FPS report the foreign tax. On submitting FPS, the value of PAYE reported reflects the amount actually deducted against UK PAYE, the amount of PAYE reduced by the amount of FTCR. This relates both to 'This Payment' and 'Year To Date' values. As FTCR is already deducted while computing PAYE deduction in PAYE formula, the PAYE balance reported on the FPS and other reports relate to net PAYE. The application adds foreign tax to Deductions from Net Pay on the FPS.
To set up net of foreign tax reporting for RTI
Link Foreign Tax element to the required payrolls or all payrolls.
Attach an element entry for this element.
Enter the foreign tax amount against the Amount input value for this element.
Oracle HRMS enables you to run three RTI reconciliation reports to aid reconciliation and audit the data to be sent to HMRC. These reports are:
RTI FPS Run Reconciliation Report - you can run this report as required for an FPS. Additionally, the FPS process run spawns this report automatically.
RTI Year to Date Reconciliation Report - you can run this report as required, especially after P60 for a tax year to reconcile all the values reported. It reports the entire population within the PAYE Reference specified.
RTI Year to Date Reconciliation Report (Discrepancies) - This report identifies records with discrepancies, as opposed to RTI Year to Date Reconciliation Report which would report.
To run RTI FPS Run Reconciliation report
Select RTI FPS Run Reconciliation Report in the Name field.
Enter the FPS Archive Request ID.
To run RTI Year to Date Reconciliation report
Select RTI Year to Date Reconciliation Report in the name field.
Enter the following parameters:
Employer PAYE Reference - Select from the list of all the PAYE references within the organization. This is a mandatory field.
Effective Date - The date entered here determines the timeframe for which the YTD values are to be reported. For example if 05-April 2025 is supplied, then this process reports all the balances up to that point. This is a mandatory field.
Run Mode - Select from the following:
Payroll vs Last FPS - Reports all employees that have FPS runs, compares the reported values reported with the payroll values, and reports discrepancies.
Payroll vs Amended FPS - Reports all employees that have amended FPS runs, compares the amended FPS values with payroll values, and reports discrepancies. This option gets enabled when the effective date parameter specified relates to tax year 2019-20 or future tax years.
Payroll vs P60 - Reports all employees that have a P60 run, matching the specified P60 request ID, compares the reported P60 values with payroll values, and reports discrepancies. If you select this option, then the P60 Request ID parameter gets enabled. Based on the effective date set, this parameter is populated for that relevant tax year.
Compare All - Reports all employees that have reported values for a payroll run, an FPS run, an FPS amendment, or a P60 run
P60 Request ID - This field is enabled when the mode is Compare All or Compare vs P60.
Number of Threads - Specify the number of threads that this process must take into account. Based on the number of threads specified, the report runs in multi threaded mode.
Assignment Set - Optionally, select an Assignment Set.
The Reconciliation Report displays all relevant information on employees/assignments extracted onto the XML file and this report is similar to the one from P14 EOY extract. This report displays the relevant YTD balance values as follows:
If the Run Mode is set to: Compare Payroll vs Last FPS, then it reports all the employees that have a FPS run. It compares the FPS values reported with payroll values and reports discrepancies, if any.
If the Run Mode is set to: Compare Payroll vs P60, then it reports all the employees that have a P60 run, specified by the P60 request ID. It compares the P60 values reported with payroll values and reports discrepancies, if any.
If the Run Mode is set to: Compare All, then it reports all the employees that have payments, reporting figures for payroll run, FPS run, P60 run, specified by the P60 request ID parameter. It compares these values reported with payroll values and reports discrepancies, if any.
To run RTI Year to Date Reconciliation Report (Discrepancies)
Select RTI Year to Date Reconciliation Report (Discrepancies) in the Name field.
Enter the following parameters, which are same as those of the RTI Year to Date Reconciliation Report:
Employer PAYE Reference
Effective Date - Date range is limited from 06-APR-2019 to 06-APR-2026.
Run Mode
P60 Request ID
All employers are required to send information to HMRC using the real time information (RTI) system. Certain message types have a version that is specific to a single tax year, so each year new versions of certain reports are required.
Employer Payment Summary
Full Payment Submission
Run Reconciliation Report
Additional Full Payment Submission
Oracle HRMS enables you to start sending Full Payment Submissions (FPS) after you have submitted the live EAS and HMRC has accepted it. You can send it as follows:
First FPS to follow immediately after a live EAS is accepted. This is a one-time FPS that includes all the payment details for the employees paid that period as well as the year to date values of all the employee records sent on the EAS that are not actually processed through the payroll. for example, leavers in the tax year. As these employees may never get processed through payroll again, you can submit their information to HMRC for them to update the YTD figures for these employees. Each group of employees who have had an EAS sent to HMRC must also go through the submission of the First FPS. You must set the First FPS parameter to Yes when running the FPS process.
You can send subsequent FPS on or before any payment is made to employees every time. The FPS covers all employees who have had a payment through the payroll process regardless of the method of payment (BACS, cheque). The period values as well as year to date figures are present on this FPS for all these employees. You must set the First FPS parameter to No, while running the subsequent FPS process for any group of employees.
HMRC uses the information submitted on FPS to update their records for the employees on an ongoing basis ensuring that the data they hold is as accurate as possible. If there are no payments made to any employee in any one period, then an FPS is not required, however, you must submit an Employer Payments Summary (EPS) with no payment made indicator for such periods. In order to produce the Full Payment Summary, you must complete your payroll cycle (payroll run) for each group of employees and also the Pre-Payment process. Once these two processes are completed, you can initiate the FPS process. This process archives the data required for reporting on the FPS XML file.
Scenarios for Reporting Dates
The following table shows the results when you enter different combinations of reporting dates in the RTI - Full Payment Submission - (FPS) Request:
Scenario | Reporting Date | Reporting End Date | Result |
---|---|---|---|
Scenario 1 | No value | No value | In this scenario, the program reports no late leavers, only the normal employees who got paid in the current prepayment. |
Scenario 2 | Any date | No value | In this scenario, the program reports all the late leavers from the Reporting Date until the current FPS run date along with the Normal FPS employees. |
Scenario 3 | Any date | Any date | In this scenario, the program reports all the late leavers from the Reporting Date until the Reporting End Date along with the Normal FPS employees. |
Use the Submit Request window to select the version of the Full Payment Submission Process (FPS) that corresponds to the desired tax year.
Important: Oracle supports corrections to tax year using the FPS through the Amended FPS process.
This process reports both the normal FPS employees along with the additional FPS late leavers. The summary output also combines both set of employees (normal FPS employees and late leavers).
To run the RTI - Full Payment Submission Process (FPS) 2025/26
Navigate to the Submit Request window.
In the Name field, select the RTI - Full Payment Submission Process (FPS) 2025/26.
Enter the following data.
Note: The following table describes the main parameters for the RTI - Full Payment Submission - (FPS) Request process. Due to changing legislative requirements, the parameters listed for your process may vary depending on the tax year.
Parameter | Description |
---|---|
PAYE Reference | Select from the PAYE references available in the application. This is a mandatory field. |
First FPS | Select Yes if this is the first FPS being sent in place of an EAS (this is determined by HMRC). Always submit for each group of employees in the EAS. The default value of this field is No. Entering data in this field is optional. |
First FPS Effective Date | Select the date for which the First FPS is being sent. This is mandatory if the First FPS parameter is Yes. The process uses this to determine the first pre-payment to be listed in the list of values for the Pre-Payment Request ID parameter and to filter pre-payments that were processed prior to migration to RTI. Ensure that this date is the date of RTI migration. |
Payroll | Select from the available payrolls in the PAYE. This is a mandatory field. |
Pre-Payment Request ID | Select a value from the Pre-Payment Request ID list for the PAYE you selected. The list of values shows the earliest pre-payment run that has not yet had an FPS run. The list of values ensures that the values being reported in FPS runs, where there are multiple pre-payments present, are correct for YTD and "this payment" values. This is a mandatory field.
Note: Ensure that each pre-payment has an FPS run separately regardless of BACS being run for multiple pre-payments. It is imperative the FPSs are run in sequence to ensure that the values being reported for "this payment" and year-to-date equal the employees' payments being made by BACS. For a normal FPS, the list of values of pre-payment IDs displays only those pre-payments that have not had an FPS since. |
Reporting Date | Optionally, enter a date within the tax year for which the FPS is being submitted. This date represents the retrospective or current period start date from which the late leavers will be considered for processing. |
Reporting End Date | Optionally, enter the end date until which date the late leavers will be processed. |
FPS Payment Date | Optionally, enter the FPS Payment Date. If you specify a payment date, then the application reports this date as the payment date for all employees processed within the FPS. |
Final Submission | Optionally, select from the following values:
When you select Yes, optional parameters are enabled. |
Date Scheme Ceased | Enter the date on which the date scheme ceased using the date format DD-MON-YYYY. For example, 10-JUL-YYYY. This is a mandatory parameter if you selected Yes - Final as the option for Ceased PAYE. |
Include Address Details | Select the option for reporting address details to HMRC:
This is a mandatory field. |
Gateway Test Indicator | This is a mandatory field, containing a list of values with the default set to Live. The other values in the list of values are Test, Test In Live , and Test In Live (Software Developer Only). The options Live and Test in Live are available only to end users, whereas the options Test, and Test in Live (Software Developer Only) are available only to software vendors. |
XML Storage Type | This field is optional and contains a list of values with the default set to File System and Database. The other value in the list is Secure Database. |
Late PAYE Reporting Reason | Select one of the following reasons:
|
Debug Mode | Optionally, select whether to set the debug mode for troubleshooting. The default value is No. The other value is Yes. The Debug Mode is enabled if the Gateway Test Indicator is set to Test, Test in Live , or Test in Live (Software Developer only). |
Person Name | Enables you to select all the person names that are processed in the selected PAYE Reference. This field is enabled only if the Debug Mode parameter is set to Yes. This is an optional parameter. |
Compress File | This is an optional parameter containing a list of values with the default set to Yes. The other value is No. |
File Split Factor (in MB) | This is an optional parameter with the default value set to 20. |
XML File Name | This is an optional parameter, which is blank by default. |
To roll back the RTI - Full Payment Submission Process
If you need to re-run the RTI - Full Payment Submission Process, first run the GB Rollback program to reset the existing values. This process ensures that newly-added values are included when the full payment submission is rerun. For more information, see Running the GB Rollback Program.
The RTI - Full Payment Submission (FPS) Amendments process, enables you to use the RTI Full Payment Submission to report revised year-to-date (YTD) payment data after 19 April, following the end of the tax year.
Important: Full Payment Submission Process (FPS) - Amendments 2024/25 is supported till 6-April-2025.
Use the Submit Request window to run the RTI - Full Payment Submission Process (FPS) - Amendments process.
To run the RTI - Full Payment Submission Process (FPS) - Amendments 2024/25
Navigate to the Submit Request window.
In the Name field, select the RTI - Full Payment Submission Process (FPS) - Amendments 2024/25.
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the PAYE references available in the application. This is a mandatory field. |
Gateway Test Indicator | This is a mandatory field, containing a list of values with the default set to Live. The other values in the list of values are Test (Software Developer only), Test In Live , and Test In Live (Software Developer only). The options Live and Test in Live are available only to end users, whereas the options Test (Software Developer only), and Test in Live (Software Developer only) are available only to software vendors. |
XML Storage Type | This field is optional and contains a list of values with the default set to File System and Database. The other value in the list is Secure Database. |
Assignment Set | Optionally, select an Assignment Set. |
Debug Mode | Select whether to set the debug mode for troubleshooting. The default value is No. The other value is Yes. The Debug Mode is enabled if the Gateway Test Indicator is set to Test (Software Developer only), Test in Live, or Test in Live (Software Developer only). |
Person Name | Enables you to select all the person names that are processed in the selected PAYE Reference. This field is enabled only if the Debug Mode parameter is set to Yes. |
Compress File | This is an optional parameter containing a list of values with the default set to Yes. The other value is No. |
File Split Factor (in MB) | This is an optional parameter with the default value set to 20. |
XML File Name | This is an optional parameter, which is blank by default. |
After you submit the RTI Full Payment Submission (FPS) Amendments 2024/25 concurrent program, the application runs the RTI - Full Payment Submission Process (FPS) 2024/25 - XML Output program. This program, in turn, automatically runs the following concurrent programs:
GB IRMark Generator
Payroll File Reporter
The application performs the required business validations during XML generation. To view the generated XML report in the browser, click View Output corresponding to the Payroll File Reporter run.
RTI FPS Amendments Run Reconciliation Report
After you submit the RTI Full Payment Submission (FPS) - Amendments 2024/25 concurrent program, the application runs the RTI FPS Amendments Run Reconciliation report. The reconciliation report displays all of the employee and assignment information that was extracted into the XML file.
Use the RTI- Full Payment Submission (FPS) - Additional Reporting request for the following scenarios:
To report late leavers, having no payments after termination.
Moving employees from one PAYE Reference to another; for example, for mergers and demergers where PAYE schemes are restructured. HMRC recommends that each assignment/person requires a leaver and starter update sent using FPS through RTI because HMRC considers this a change of employment.
To report starter and leaver records when the Employer PAYE Reference is changed at the end of the tax year at the Payroll Definition level. The leaver record would be generated against the old Employer PAYE Reference and the starter record would be generated against the new Employer PAYE Reference.
To run the RTI- Full Payment Submission (FPS) - Additional Reporting Request
Use this process to report all the employees who are transferred from one employer PAYE Reference to another, to report late leavers who have no payments after Termination and to report change in aggregation effective beginning of tax year.
Navigate to the Submit Request window.
In the Name field, select RTI - Full Payment Submission (FPS) Additional Reporting 2025/26.
Enter the following parameters:
Parameter | Description |
---|---|
Submission Mode | Select a Submission Mode from the list. You can choose from:
Note: In the new tax year, you must submit the FPS with submission mode FPS with Starter Details before submitting any normal FPS program.
This is a mandatory parameter. |
PAYE Reference | Select from the list of PAYE references in the organization. This is a mandatory parameter. |
Payroll | Optionally, specify the applicable payroll. The application disables this field if the submission mode is either FPS with Leaver Details or FPS with Starter Details. |
Reporting Date | The application defaults the date to 05-APR-YYYY when the submission mode is set to FPS with Leaver Details. It defaults the date to 06-APR-YYYY when the submission mode is set to FPS with Starter Details. This is an optional parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with a default value of Live. The other values in the list of values are Test (Software Developer only), Test In Live, and Test In Live (Software Developer only). Note that software vendors can only use the Test and Test in Live (Test Submission) values, whereas end-users can use only the Live and Test in Live (Live Submission) values. |
Debug Mode | This is an optional parameter, and you can choose between Yes and No. No is the default parameter. This parameter is enabled if the Gateway Test Indicator parameter is set to Test (Software Developer only), Test in Live , or Test in Live (Software Developer only). |
Person Name | This is an optional parameter containing a list of values with names of all persons processed in the selected prepayment. The Person Name parameter is enabled if the Debug Mode parameter is set to Yes. |
Compress File | This is an optional parameter containing a list of values, with a default value of Yes. The other value in the list of values is No. |
XML Storage Type | This is an optional parameter containing a list of values, with the default set to File System and Database. The other value in the list of values is Secure Database. |
Late PAYE Reporting Reason | Optionally, select one of the following reasons for late reporting:
|
File Split Factor (in MB) | File Split Factor (in MB) is an optional parameter, with the default value 20. This parameter is applicable only when the Submission Mode is XML. |
XML File Name | XML File Name is an optional parameter, which is blank by default. |
Run the GB Rollback program to roll back (reset) a process. For example, if you want to rerun the Full Payment Submission, first run the GB Rollback program to reset the values. This enables the new values to be included when the update process is rerun.
You can roll back the following processes:
Full Payment Submission
Full Payment Submission - Amendments
Additional Full Payment Submission
P11D
P46(Car) Archive Process
To run the GB Rollback program
In the Name field, select GB Rollback.
Enter the following parameters:
Year - enter the year for which you want to roll back the process. This is a mandatory parameter.
Process Type - select the process type to be rolled back, such as a balance adjustment or estimate costing. This is a mandatory parameter.
Payroll Process - select the required payroll process ID to roll back. This is a mandatory parameter.
Assignment Set - optionally, select an assignment set.
XML File Name - optionally, select the XML File Name.
Click OK, and click Submit.
On receiving the FPS, HMRC calculates the employer liability (PAYE and NI) which is the amount they expect the employer to make for that period for the PAYE scheme. However, when there are any adjustments or reimbursements, for example, statutory payments recovery and the NIC compensation on the recovery amounts that reduce the expected liability, then you need to submit the Employer Payment Summary (EPS) for each period as necessary. The EPS contains the statutory payment recovery values (92% of SMP, ASPP,SAP,) and the NIC compensation on these recovery amounts. It also allows declarations to be made and if there are any amounts claimed for NIC holiday, CIS deductions suffered, or if there was an advance from HMRC to be reported. You send this record after processing all payrolls within the PAYE scheme and after submitting their FPS because this is relevant to the whole PAYE scheme. Oracle HRMS enables you to submit multiple EPS on the same effective date. Submit multiple EPS to report changes to a previous tax year that affect statutory payments such as SSP, SMP, and ASPP.
Complete the following steps before you run the EPS process.
Enter the information on Statutory Payments Recovery rates in the Tax Details Reference organization EIT.
Call the GB_EPS_GET_REC_AND_NIC predefined formula function (FF) from the SMP/SAP/ASPP and OSPP element formula. Pass Amount input value as a parameter. The seeded fast formula passes the Recovery and NIC Compensation computed values to the out parameters specified on the user formulae. Return these values to the appropriate predefined indirect elements for Recovery and NIC Compensation using the Formula Results functionality. For example, you must return the computed SMP Recovery amount to SMP Recovery element's Pay Value and return the computed SMP NIC Compensation to SMP NIC Compensation element's Pay Value. These indirect elements in turn feed the seeded balances which are reported after you run the RTI Create EPS Payment Values for the current year.
If you are doing internet submission and if you select the Database option for the XML Storage Type parameter, then create the following for usage by the EPS process:
Create the PAY_GB_RTI_SUBMISSION_ENCR table in the encrypted tablespace using the following script:
CREATE TABLE (schema_name)."PAY_GB_RTI_SUBMISSION_ENCR" ("SUBMISSION_ID" NUMBER NOT NULL ENABLE, "BUSINESS_GROUP_ID" NUMBER(22,0), "SUBMISSION_STATUS" VARCHAR2(1), "CONC_REQUEST_ID" NUMBER(22,0), "PAYROLL_ACTION_ID" NUMBER(22,0), "REPORT_TYPE" VARCHAR2(100), "XML_DATA" CLOB, "EFFECTIVE_DATE" DATE, "MESSAGE_TYPE" VARCHAR2(1), "GENERATION_DATE" DATE, "CREATED_BY" NUMBER(22,0), "CREATION_DATE" DATE, "LAST_UPDATED_BY" NUMBER(22,0), "LAST_UPDATE_DATE" DATE, "LAST_UPDATE_LOGIN" NUMBER(22,0), "OBJECT_VERSION_NUMBER" NUMBER ) ;
Create the synonym using the following script:
CREATE OR REPLACE SYNONYM (schema_name)."PAY_GB_RTI_SUBMISSION_ENCR" FOR (schema_name)."PAY_GB_RTI_SUBMISSION_ENCR"
Create the sequence using the following script:
CREATE SEQUENCE (schema_name)."PAY_GB_RTI_SUBMISSION_ENCR_S" MINVALUE 1 MAXVALUE 9999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ;
Create the trigger to ensure that the who columns are populated in the table PAY_GB_RTI_SUBMISSION_ENCR appropriately.
Grant the required privileges to APPS user.
Note: If you have specified the value as 'Database' for the XML Storage Type parameter, but have not created the required table, then the application displays an error message. You do not require the above mentioned steps if you are running the Electronic Data Interchange submissions.
Run the Create EPS Payment Values process.
Upon successful completion of the creation process, log into self service, to open the EPS Self Service page.
Make any changes and additions to the amounts displayed on the page for the PAYE reference and save the record.
Submit the EPS for approval (internal workflow task to be created).
Note: If you do not want the Approval process to occur for the Employer Payment Summary submission, then set the RTI - Employer Payment Summary Approval process required profile option to No. When the value is No, the EPS process bypasses the process of setting the EPS record status to completed and no approver interaction is required. When you submit the record, the application sets it to verified directly. See: User Profiles, Oracle HRMS Configuring, Reporting, and System Administration Guide.
Approver then needs to submit the page which is picked up by the EPS XML process.
Once the information to be sent for the period has been submitted, you can submit the EPS XML process which creates the file for submission to HMRC.
Use the EPS Self Service page to view, update, and submit the Employer Payment Summary record created by the Create EPS Payment Values process. You can grant applicable personnel in your organization to access this page and complete the required tasks.
Navigate to the EPS page using Other Definitions > Real Time Information > Employer Payment Summary. You can perform the following actions:
Search EPS records
In this page you can search and retrieve the relevant PAYE Employer Payment Summary records. In the Search results section, you can select View icon to view the employer payment submission record. The record displays all the values that have been recorded on it by the Create EPS Payment Values process and any user inputs. This is a read-only page that displays information on all the values for the EPS record chosen. The Summary of Payments shown are the calculated values from the process (first column of figures) as well as the values that are editable by the user (second column of figures) that you can use to override the calculated values. The XML file for EPS takes the values shown on the second column.
Update EPS records
To update the values in the second column in the EPS record page, click Update for the applicable record in the Search Results section. The Update - Employer Payment Summary Record page has the following three sections:
Employer PAYE Reference Details: Where the RTI information of the PAYE reference is displayed. All the information on RTI for the entered on the Tax Reference Details organization EIT is displayed here. The statutory reimbursement information shown is that used by the Create EPS Payment Values process. The items displayed are read-only and you cannot update here. The only field that you can update is the Approver Name.
Employer Checklist Declaration: You can enter or update all the declaration information for submitting to HMRC (as necessary). This is similar to the P35 declaration information that is currently required by HMRC at the end of the year.
Summary of Payments: Here you can make all the necessary amendments to the fields shown prior to submitting the EPS record for approval and subsequent submission to HMRC. The summary of payments section displays the actual value calculated from the EPS process. You can overwrite these figures as required by entering the replacement value in the enterable area for each item.
You can choose to either:
Save - This saves the record with a confirmation notification. The status does not change for the record but fields that have been changed are updated.
Submit - This sends the record for approval with a confirmation notification. This action changes the status of the EPS record to 'Completed'. After this status change, you cannot update the record if you have created it. Only the approver can update the record once the status has been set to 'completed'. The application sends a notification to the user set up as the approver so that the record can be checked by them and verified that the record is ready to be picked up by the EPS process.
Cancel - takes you back to the Search page.
Update by approver
When the Approver gets a notification, they can go through the same functional flow to 'Update' or 'Approve' the record. This is same as Update Page for the creator of the EPS, except it is only available to the designated approver. In the Update - Employer Payment Summary Record (for approver) page, click the Verify button to change the EPS record status to 'Verified'. The EPS XML process picks up all verified EPS records for the PAYE scheme and creates the file for submission to HMRC.
Delete EPS records
Click the Delete icon in the Search Results section for the applicable EPS record. Use the Delete button on the Delete - Employer Payment Summary Record page to delete the EPS record. The application displays a confirmation message.
This process extracts all balances for a period for the required PAYE scheme and makes the balances available on the EPS record page. For the given PAYE reference, this process calculates the sum of all statutory balances for all the assignments in the PAYE reference. It uses the parameters set in the Tax Reference Details organization EIT to calculate the statutory recovery values together with the NIC compensation values.
Note: Due to changing legislative requirements, the parameters may vary depending on the tax year of the report selected.
To run the RTI - Create EPS Payment Values 2025/26 process
Use this process for the tax year 2025/26.
Navigate to the Submit Request window.
In Name field, select RTI - Create EPS Payment Values 2025/26.
Enter the parameters.
Enter the following data:
Field | Description |
---|---|
PAYE Reference | Select from the list of all the PAYE references within the organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. This is a mandatory parameter. |
Final Submission | This is an optional parameter, containing a list of values, with default value set to No. Other values areYes - Final for Ceased PAYE Ref, and Yes - Final for the Year. |
No of Threads | Specify the number of threads that this process must take into account. This is a mandatory parameter and the default value is 3. |
Submit Bank Details for Refund | Optionally, select whether to submit bank details for refund. The default is No. |
Select Bank Details for Refund | If you selected Yes in the Submit Bank Details for Refund field, then the application enables this parameter, and enables you to select a payment method from the list of all the organization payment methods defined in the business group. This is an optional parameter. |
Claim Employment Allowance | Select Yes if you are claiming an employment allowance. The field is blank by default. |
This report generates the following output:
SMP/SAP/SPP/ShPP/SPBP Recovery Type
Recovery Percentage Used
SMP Amount Recovered
SAP Amount Recovered
SPP Amount Recovered
ShPP Amount Recovered
SPBP Amount Recovered YTD
SNCP Amount Recovered YTD
NIC Compensation on SMP
NIC Compensation on SAP
NIC Compensation on SPP
NIC Compensation on ShPP
NIC Compensation on SPBP YTD
NIC Compensation on SNCP YTD
Apprenticeship Levy YTD
Annual Apprenticeship Levy allowance
Click OK and then submit the request.
To run the RTI - Create EPS Payment Values 2024/25 process:
Use this process for the tax year 2024/25.
Navigate to the Submit Request window.
In Name field, select RTI - Create EPS Payment Values 2024/25.
Enter the parameters.
Enter the following data:
Field | Description |
---|---|
PAYE Reference | Select from the list of all the PAYE references within the organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. This is a mandatory parameter. |
Final Submission | This is an optional parameter, containing a list of values, with default value set to No. Other values areYes - Final for Ceased PAYE Ref, and Yes - Final for the Year. |
No of Threads | Specify the number of threads that this process must take into account. This is a mandatory parameter and the default value is 3. |
Submit Bank Details for Refund | Optionally, select whether to submit bank details for refund. The default is No. |
Select Bank Details for Refund | If you selected Yes in the Submit Bank Details for Refund field, then the application enables this parameter, and enables you to select a payment method from the list of all the organization payment methods defined in the business group. This is an optional parameter. |
Claim Employment Allowance | Select whether you are claiming an employment allowance (Yes or No). The field is blank by default. |
This report generates the following output:
SMP/SAP/SPP/ShPP/SPBP Recovery Type
Recovery Percentage Used
SMP Amount Recovered
SAP Amount Recovered
SPP Amount Recovered
ShPP Amount Recovered
SPBP Amount Recovered YTD
NIC Compensation on SMP
NIC Compensation on SAP
NIC Compensation on SPP
NIC Compensation on ShPP
NIC Compensation on SPBP YTD
Apprenticeship Levy YTD
Annual Apprenticeship Levy allowance
Click OK and then submit the request.
To run the RTI - Create EPS Payment Values 2023/24 process
Navigate to the Submit Request window.
In the Name field, select RTI - Create EPS Payment Values 2023/24.
Enter the following data:
Field | Description |
---|---|
PAYE Reference | Select from the list of all the PAYE references within the organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. This is a mandatory parameter. |
Final Submission | This is an optional parameter, containing a list of values, with default value set to No. Other values areYes - Final for Ceased PAYE Ref, and Yes - Final for the Year. |
No of Threads | Specify the number of threads that this process must take into account. This is a mandatory parameter and the default value is 3. |
Submit Bank Details for Refund | Optionally, select whether to submit bank details for refund. The default is No. |
Select Bank Details for Refund | If you selected Yes in the Submit Bank Details for Refund field, then the application enables this parameter, and enables you to select a payment method from the list of all the organization payment methods defined in the business group. This is an optional parameter. |
Claim Employment Allowance | Select whether you are claiming an employment allowance (Yes or No). The field is blank by default. |
This report generates the following output:
SMP/SAP/SPP/ShPP/SPBP Recovery Type
Recovery Percentage Used
SMP Amount Recovered
SAP Amount Recovered
SPP Amount Recovered
ShPP Amount Recovered
SPBP Amount Recovered YTD
NIC Compensation on SMP
NIC Compensation on SAP
NIC Compensation on SPP
NIC Compensation on ShPP
NIC Compensation on SPBP YTD
Apprenticeship Levy YTD
Annual Apprenticeship Levy allowance
To run the RTI - Create EPS Payment Values 2022/23 process
Navigate to the Submit Request window.
In the Name field, select RTI - Create EPS Payment Values 2022/23.
Enter the following data:
Field | Description |
---|---|
PAYE Reference | Select from the list of all the PAYE references within the organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. This is a mandatory parameter. |
Final Submission | This is an optional parameter, containing a list of values, with default value set to No. Other values are Yes - Final for Ceased PAYE Ref, and Yes - Final for the Year. |
No of Threads | Specify the number of threads that this process must take into account. This is a mandatory parameter and the default value is 3. |
Submit Bank Details for Refund | Optionally, select whether to submit bank details for refund. The default is No. |
Select Bank Details for Refund | If you selected Yes in the Submit Bank Details for Refund field, then the application enables this parameter, and enables you to select a payment method from the list of all the organization payment methods defined in the business group. This is an optional parameter. |
Claim Employment Allowance | Select whether you are claiming an employment allowance (Yes or No). The field is blank by default. |
This report generates the following output:
SMP/SAP/SPP/ShPP/SPBP Recovery Type
Recovery Percentage Used
SMP Amount Recovered
SAP Amount Recovered
SPP Amount Recovered
ShPP Amount Recovered
SPBP Amount Recovered YTD
NIC Compensation on SMP
NIC Compensation on SAP
NIC Compensation on SPP
NIC Compensation on ShPP
NIC Compensation on SPBP YTD
Apprenticeship Levy YTD
Annual Apprenticeship Levy allowance
To run the RTI - Create EPS Payment Values 2021/22 process
Navigate to the Submit Request window.
In the Name field, select RTI - Create EPS Payment Values 2021/22.
Enter the following data:
Field | Description |
---|---|
PAYE Reference | Select from the list of all the PAYE references within the organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. This is a mandatory parameter. |
Final Submission | This is an optional parameter, containing a list of values, with default value set to No. Other values are Yes - Final for Ceased PAYE Ref, and Yes - Final for the Year. |
No of Threads | Specify the number of threads that this process must take into account. This is a mandatory parameter and the default value is 3. |
Submit Bank Details for Refund | Optionally, select whether to submit bank details for refund. The default is No. |
Select Bank Details for Refund | If you selected Yes in the Submit Bank Details for Refund field, then the application enables this parameter, and enables you to select a payment method from the list of all the organization payment methods defined in the business group. This is an optional parameter. |
Claim Employment Allowance | Select whether you are claiming an employment allowance (Yes or No). The field is blank by default. |
This report generates the following output:
SMP/SAP/SPP/ShPP/SPBP Recovery Type
Recovery Percentage Used
SMP Amount Recovered
SAP Amount Recovered
SPP Amount Recovered
ShPP Amount Recovered
NIC Compensation on SMP
NIC Compensation on SAP
NIC Compensation on SPP
NIC Compensation on ShPP
Apprenticeship Levy YTD
Annual Apprenticeship Levy allowance
To run the RTI - Create EPS Payment Values 2020/21 process
Navigate to the Submit Request window.
In the Name field, select RTI - Create EPS Payment Values 2020/21.
Enter the following data:
Field | Description |
---|---|
PAYE Reference | Select from the list of all the PAYE references within the organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. This is a mandatory parameter. |
Final Submission | This is an optional parameter, containing a list of values, with default value set to No. Other values are Yes - Final for Ceased PAYE Ref, and Yes - Final for the Year. |
No of Threads | Specify the number of threads that this process must take into account. This is a mandatory parameter and the default value is 3. |
Submit Bank Details for Refund | Optionally, select whether to submit bank details for refund. The default is No. |
Select Bank Details for Refund | If you selected Yes in the Submit Bank Details for Refund field, then the application enables this parameter, and enables you to select a payment method from the list of all the organization payment methods defined in the business group. This is an optional parameter. |
Claim Employment Allowance | Select whether you are claiming an employment allowance (Yes or No). The field is blank by default. |
To run the RTI - Create EPS Payment Values 2019/20 process:
Navigate to the Submit Request window.
In the Name field, select RTI - Create EPS Payment Values 2019/20.
Enter the following data:
Field | Description |
---|---|
PAYE Reference | Select from the list of all the PAYE references within the organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. This is a mandatory parameter. |
Final Submission | This is an optional parameter, containing a list of values, with default value set to No. Other values are Yes - Final for Ceased PAYE Ref, and Yes - Final for the Year. |
No of Threads | Specify the number of threads that this process must take into account. This is a mandatory parameter and the default value is 3. |
Submit Bank Details for Refund | Optionally, select whether to submit bank details for refund. The default is No. |
Select Bank Details for Refund | If you selected Yes in the Submit Bank Details for Refund field, then the application enables this parameter, and enables you to select a payment method from the list of all the organization payment methods defined in the business group. This is an optional parameter. |
Claim Employment Allowance | Select whether you are claiming an employment allowance (Yes or No). The field is blank by default. |
To run the RTI - Employer Payment Summary Process (EPS) 2025/26
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Process (EPS) 2025/26.
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the list of PAYE references in your organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. For example, if running a July monthly payroll EPS for payments at the end of the month (for example, 28 July), then the tax period is considered as period 05 running from 06-July to 05-Aug, and as such the date you enter is the end of the tax period in question (enter 05-Aug-YYYY). If running a weekly payroll and its dates span the tax period, then the EPS does not cover the values for this payroll as it falls into the next tax period. For example, a weekly payroll pay date of 07-Aug would be eligible for the next tax period from 06-Aug to 05-Sept. Therefore, the effective date entered of 05-Aug does not include the weekly pay run values. This is a mandatory parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with the default set to Live. Other options in the list of values are Test, Test in Live (Software Developer only), and Test in Live. Note that software vendors can only use the Test (Software Developer Only) and Test in Live (Software Developer Only) options, while end-users can use only the Live and Test in Live options. |
XML Storage Type | This field is enabled only if the Submission Mode is XML. Select an XML Storage Type from the list:
This is an optional parameter. |
Click OK, and then Submit the request.
To run the RTI - Employer Payment Summary Process (EPS) 2024/25
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Process (EPS) 2024/25.
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the list of PAYE references in your organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. For example, if running a July monthly payroll EPS for payments at the end of the month (for example, 28 July), then the tax period is considered as period 05 running from 06-July to 05-Aug, and as such the date you enter is the end of the tax period in question (enter 05-Aug-YYYY). If running a weekly payroll and its dates span the tax period, then the EPS does not cover the values for this payroll as it falls into the next tax period. For example, a weekly payroll pay date of 07-Aug would be eligible for the next tax period from 06-Aug to 05-Sept. Therefore, the effective date entered of 05-Aug does not include the weekly pay run values. This is a mandatory parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with the default set to Live. Other options in the list of values are Test, Test in Live (Software Developer only), and Test in Live. Note that software vendors can only use the Test (Software Developer Only) and Test in Live (Software Developer Only) options, while end-users can use only the Live and Test in Live options. |
XML Storage Type | This field is enabled only if the Submission Mode is XML. Select an XML Storage Type from the list:
This is an optional parameter. |
Click OK, and then Submit the request.
To run the RTI - Employer Payment Summary Process (EPS) 2023/24
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Process (EPS) 2023/24.
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the list of PAYE references in your organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. For example, if running a July monthly payroll EPS for payments at the end of the month (for example, 28 July), then the tax period is considered as period 05 running from 06-July to 05-Aug, and as such the date you enter is the end of the tax period in question (enter 05-Aug-YYYY). If running a weekly payroll and its dates span the tax period, then the EPS does not cover the values for this payroll as it falls into the next tax period. For example, a weekly payroll pay date of 07-Aug would be eligible for the next tax period from 06-Aug to 05-Sept. Therefore, the effective date entered of 05-Aug does not include the weekly pay run values. This is a mandatory parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with the default set to Live. Other options in the list of values are Test, Test in Live (Software Developer only), and Test in Live. Note that software vendors can only use the Test (Software Developer Only) and Test in Live (Software Developer Only) options, while end-users can use only the Live and Test in Live options. |
XML Storage Type | This field is enabled only if the Submission Mode is XML. Select an XML Storage Type from the list:
This is an optional parameter. |
Click OK, and then Submit the request.
To run the RTI - Employer Payment Summary Process (EPS) 2022/23
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Process (EPS) 2022/23 .
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the list of PAYE references in your organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. For example, if running a July monthly payroll EPS for payments at the end of the month (for example, 28 July), then the tax period is considered as period 05 running from 06-July to 05-Aug, and as such the date you enter is the end of the tax period in question (enter 05-Aug-YYYY). If running a weekly payroll and its dates span the tax period, then the EPS does not cover the values for this payroll as it falls into the next tax period. For example, a weekly payroll pay date of 07-Aug would be eligible for the next tax period from 06-Aug to 05-Sept. Therefore, the effective date entered of 05-Aug does not include the weekly pay run values. This is a mandatory parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with the default set to Live. Other options in the list of values are Test, Test in Live (Software Developer only), and Test in Live. Note that software vendors can only use the Test (Software Developer Only) and Test in Live (Software Developer Only) options, while end-users can use only the Live and Test in Live options. |
XML Storage Type | This field is enabled only if the Submission Mode is XML. Select an XML Storage Type from the list:
This is an optional parameter. |
Click OK, and then Submit the request.
To run the RTI - Employer Payment Summary Process (EPS) 2021/22
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Process (EPS) 2021/22.
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the list of PAYE references in your organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. For example, if running a July monthly payroll EPS for payments at the end of the month (for example, 28 July), then the tax period is considered as period 05 running from 06-July to 05-Aug, and as such the date you enter is the end of the tax period in question (enter 05-Aug-YYYY). If running a weekly payroll and its dates span the tax period, then the EPS does not cover the values for this payroll as it falls into the next tax period. For example, a weekly payroll pay date of 07-Aug would be eligible for the next tax period from 06-Aug to 05-Sept. Therefore, the effective date entered of 05-Aug does not include the weekly pay run values. This is a mandatory parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with the default set to Live. Other options in the list of values are Test, Test in Live (Software Developer Only), and Test in Live . Note that software vendors can only use the Test and Test in Live (Software Developer Only) options, while end-users can use only the Live and Test in Live options. |
XML Storage Type | This field is enabled only if the Submission Mode is XML. Select an XML Storage Type from the list:
This is an optional parameter. |
Click OK, and then Submit the request.
To run the RTI - Employer Payment Summary Process (EPS) 2020/21
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Process (EPS) 2020/21 .
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the list of PAYE references in your organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. For example, if running a July monthly payroll EPS for payments at the end of the month (for example, 28 July), then the tax period is considered as period 05 running from 06-July to 05-Aug, and as such the date you enter is the end of the tax period in question (enter 05-Aug-YYYY). If running a weekly payroll and its dates span the tax period, then the EPS does not cover the values for this payroll as it falls into the next tax period. For example, a weekly payroll pay date of 07-Aug would be eligible for the next tax period from 06-Aug to 05-Sept. Therefore, the effective date entered of 05-Aug does not include the weekly pay run values. This is a mandatory parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with the default set to Live. Other options in the list of values are Test, Test in Live (Software Developer Only), and Test in Live. Note that software vendors can only use the Test and Test in Live (Software Developer Only) options, while end-users can use only the Live and Test in Live options. |
XML Storage Type | This field is enabled only if the Submission Mode is XML. Select an XML Storage Type from the list:
This is an optional parameter. |
Click OK, and then Submit the request.
To run the RTI - Employer Payment Summary Process (EPS) 2019/20
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Process (EPS) 2019/20 .
Enter the following data:
Parameter | Description |
---|---|
PAYE Reference | Select from the list of PAYE references in your organization. This is a mandatory parameter. |
Effective Date | Enter the tax period end date in the format DD-MON-YYYY for the relevant tax period. For example, if running a July monthly payroll EPS for payments at the end of the month (for example, 28 July), then the tax period is considered as period 05 running from 06-July to 05-Aug, and as such the date you enter is the end of the tax period in question (enter 05-Aug-YYYY). If running a weekly payroll and its dates span the tax period, then the EPS does not cover the values for this payroll as it falls into the next tax period. For example, a weekly payroll pay date of 07-Aug would be eligible for the next tax period from 06-Aug to 05-Sept. Therefore, the effective date entered of 05-Aug does not include the weekly pay run values. This is a mandatory parameter. |
Gateway Test Indicator | This is a mandatory parameter containing a list of values, with the default set to Live. Other options in the list of values are Test, Test in Live (Software Developer Only), and Test in Live ). Note that software vendors can only use the Test and Test in Live (Software Developer Only)options, while end-users can use only the Live and Test in Live options. |
XML Storage Type | This field is enabled only if the submission mode is XML. Select an XML storage type:
This is an optional parameter. |
Click OK, and then Submit the request.
If you need to resubmit the EPS for a particular tax period, then you must reset the status of the EPS record. This is required because after the system updates the EPS to Sent status, no updates can be made to the EPS record on the system. Using the EPS Reset Status process, you can update the EPS record and resubmit. This process resets the EPS record to its original state (before it was approved and sent). The Status flag reverts to Saved and the EPS can be updated and resubmitted as normal.
To run the RTI - Employer Payment Summary Reset Status process:
Navigate to the Submit Request window.
In the Name field, select RTI - Employer Payment Summary Reset Status.
Enter the following parameters:
PAYE Reference: Select from the list of all the PAYE references within the organization. This is a mandatory field.
Effective Date: Enter the tax period end date using the format DD-MON-YYYY (for example, 12-DEC-2020) for the tax period that you wish to roll back. This is a mandatory field.
Click OK and Submit the request.
Use this process to request National Insurance Numbers for new or existing employees through an XML message file submission. Using the same method, you can for verification of existing National Insurance Numbers. This process archives the data required for reporting on the XML file.
Use the Submit Request window.
To run the NVREQ process
Select RTI - NINO Verification Request Process (NVREQ) in the Name field.
Enter the following parameters:
PAYE Reference - Select from the list of all the PAYE references within the organization.
Payroll - Optionally, select from the list of all the payrolls within PAYE reference chosen. If no payroll is entered, the process selects all payrolls within the PAYE reference and scans for all records where the NI Verification data is missing.
Test Submission - Select Yes if you are sending a test EAS message file. For live files, default is always No.
Process Type - Optionally, you can run this process for an assignment set or an individual employee. If you set this parameter to Assignment Set, then the Assignment Set field becomes mandatory. If the parameter is set to Employee, then the Employee ID field becomes mandatory. Enter applicable values.
Upon sending this file, you receive an acknowledgement that contains a correlation ID. This correlation ID is present in the reply message (NVREP) that HMRC sends.
The National Insurance Number Verification Reply (NVREP) is a message that HMRC sends for the following reasons:
A reply to the National Insurance Number Verification request (NVREQ) sent by the employer.
A result of an incorrect or missing National Insurance Number on the Employer Alignment Submission (EAS) or a Full Payment Summary (FPS) sent.
In either case, you must act on the information supplied and upload the correct NI number for the employee where necessary. Use the NVREP process to upload the NVREP file received from HMRC through the Submit Request window.
To run the NVREP process
Select RTI - NINO Verification Reply Upload Process (NVREP) in the Name field.
Enter the following parameters:
File Name - select the name of the incoming file to be uploaded through the process.
Validate mode - select the validate mode. Depending on the following modes, the process does the following:
Validate only - no updates made to the Earlier Year Update Processson's record. Only validation is carried out.
Validate and Commit- Live - you can use this mode for a live or test file being sent by HMRC.
For a test file (test indicator on the header = 1, a warning appears to that effect and the person record is not updated with the NINO number on the file. The process reports missing employees. It checks whether all employees processed (under Validate mode) are on the report as described in the Output Report.
For a live file (test indicator on the header = blank), the process checks whether the NINO Verified flag on the person EIT is set (box is selected). There is no update to the person record as the NINO is already verified and correct for the person and a message to that effect is provided. If the NINO Verified flag on the person EIT is NOT set (box is not selected), then the process updates the record with the NINO supplied on the incoming file.
Validate and Commit Always - use this is a parameter during pilot testing runs with HMRC, Depending on the NINO Verified flag on the person EIT, the result is different. If the NINO Verified flag on the person EIT is set (box is selected), then there is no update to the person record as the NINO is already verified and correct for the person and a message to that effect is provided. If the NINO Verified flag on the person EIT is NOT set (box is not selected), then the process updates the record with the NINO supplied on the incoming file.
Note: The difference between the Validate Always and Validate Live mode is that the test indicator on the incoming file header is not checked for Validate Always mode. Use this option with care. All employees processed (under Validate and Commit mode) are reported on the Output Report from the process. Once the record is found using the Validate and Commit options, the process updates the employee record in the Real Time Information NINO Verification Details EIT with the NINO to Use number provided in the file sent by HMRC as a reply to NVREQ.
Use the Standalone IRMark generation program to modify the XML file generated by system manually on account of a bug in the software or for some specific business reasons.
You use the Submit Request window to run the IR Mark Generation Program.
To run the IR Mark Generation Program:
Navigate to the Submit Request window.
Enter GB Generate IR Mark in the Name field.
Enter the following details in the Parameters window:
File Path: This is a mandatory parameter. Use this to specify the directory path of the file in the middle tier. The directory path you specify should have read write privileges.
Write to Database: This is a mandatory parameter, with options Yes and No. When you set this parameter to Yes, the updated file with new IRMark overrides the old file in the database which is already created when the archiver is processed
When the Write To Database option is set to Yes, the application does one of the following:
If the File Name (File System) is entered, then the application selects the file with the corresponding name for processing from the middle tier.
If the File Name (File System) is not entered, then the application selects the file from the middle tier is selected based on the name in File Name (Database).
XML Request ID:This parameter is enabled when Write to Database is set to Yes. The XML Request ID along with the File Name(Database) enables you to uniquely find the file record in the database that needs to be updated with the new file.
File Name (Database): This parameter is enabled when the Write to Database option is set to Yes.
File Name (File System): When the Write To Database option is set to No, this becomes a mandatory parameter. The application selects the file with the corresponding name for processing from the middle tier.