Record of Employment Exception Report

The Record of Employment (ROE) Exception report helps identify missing data that’s required for the ROE interface. This report is automatically generated when you run the ROE Archive process.

If the required data is missing, the upload of the ROE interface file to Service Canada fails. Correct the exceptions before running the ROE interface process. If there are no exceptions to report, then the report displays only the flow name and effective date, but no exception data.

Here’s the list of required fields for the ROE interface.. These attributes are checked by the archive process and if missing, causes an exception to be written to the report. The report only provides exception messages for these user-enterable data:

  • Block 8: Employee Social Insurance Number

  • Block 9: Employee First Name, Address Line 1, City and Postal Code

  • Block 14: Expected Recall Code

  • Block 15A: Total Insurable Hours

  • Block 16: ROE Reason

  • Block 16: ROE Contact Name First Name, Last Name, Phone Area Code, and Phone Number

Note: Any data that’s derived by the Oracle Fusion Human Capital Management for Canada application isn’t mentioned in the report.

Parameters

Flow Name

Enter a name to identify the process being run.

Effective Date

Enter the effective date of the ROE Archive process.

Report Results

Here’s the list of exception messages the report produces, if any of the required attributes are missing:

  • Employee First Name is missing

  • Social Insurance Number is missing

  • Employee Address is missing

  • ROE Reason is missing

  • Expected Recall Code is missing

  • ROE Contact First Name is missing

  • ROE Contact Last Name is missing

  • ROE Contact Phone Area Code is missing

  • ROE Contact Phone Number is missing

  • No insurable earnings are there for this employee

The report is sorted by the tax reporting unit and the last and first name of the employee. These are the attributes that are displayed to help isolate the errors:

  • Person Name

  • Person Number

  • Payroll Name

  • Error Messages