ROE Troubleshooting Document

ROE Troubleshooting and Configuration Document

Necessary information

1. Employee ID
2. Pay Record screenshot/DAILY_EI_DATA 
   1. Outline the expected earnings
3. Screenshot of ROE Report
   1. Showing the Last Day Worked that was configured
   2. Outlining the value that does not meet expectation
4. Pay Number in question
5. Basic Group Data setup
   1. Pay STAT_HOL2 config

Payroll > Group Data > Basic Group Data

Note: Confirm the below is setup in the event that the reported issue is that ROE Earnings are missing STATHOL Amounts.

Employee Daily EI Data script

select * from EC_EMPLOYEE_DAILY_EI_DATA

where EMPLOYEE_ID = 'ID HERE'

and RUN_PAY_NUMBER = 'PAY #'

Note: This is used to confirm the values depicted are reflected under the DAILY_EI_DATA table, as this is the table the ROE is basically a reflection of

Note: Use the EI_DATE for each earning record to match against LAST DAY PAID configured when running ROE (The earning might have been outside of the defined scope)

Employee Pay Record script

select * from EC_EMPLOYEE_PAY_RECORD

where EMPLOYEE_ID = 'ID HERE'

and Pay_number = 'PAY #'

and ENTITY_CODE = 'STAT_HOL2'

Note: This is used to confirm the values that have been depicted in ticket details

How to determine the First Day Worked as shown on ROE Report

select * from EC_EMPLOYEE_DAILY_EI_DATA

where EMPLOYEE_ID = 'ID HERE'

order by EI_DATE asc

Earliest EI_DATE = First Day Paid

Earliest EI_DATE = 2022/12/29

Therefore, First Day Paid = 2022/12/19

Note: First Day Worked is not the Start Date of Compensation Record. ROE is a reflection of DAILY_EI_DATA table and not Salary and Allowance. 

ROE Not Issued – Troubleshooting Information Required

1. What group(s) are being run at once
   1. Screenshot of Batch ROE screenshot
   2. Shows us exact configuration
2. What exact group is being run
   1. What incorrect group, if any, is being generated
   2. What Incorrect amounts, if any, are being generated

ROE Rejected by Service Canada - how to troubleshoot

To find the exact error for an ROE rejected by Service Canada, you can check it using a free tool, Notepad ++

(1)  Get Notepad ++ and install the XML tools plug in. (can be found for free on the internet).

(2) Get the XML schema file from the Service Canada web site. Current URL is here: https://www.canada.ca/en/employment-social-development/programs/ei/ei-list/ei-roe/user-requirements/appendix-d.html  the file should end in .xsd. 

(3)  Open the ROE file in Notepad ++.  Choose Plugins from the top menu...XML tools... Validate now.  It will prompt you to locate the XSD file so locate that and click ok. 

(4)  Any invalid data in the file will be highlighted with an explanation.  From there you can either edit the file manually, or correct the issue in HRP and reissue your ROE.