To run the RL1 Paper Report:Run the RL1 Paper Report, RL1 PDF and RL1 Electronic Interface from the Submit Request window.
Note: While the RL1 Paper Report is still an available option, Oracle Payroll has not supported changes to these forms since 2010. It is recommended that the RL1 PDF be used instead.
To run the RL1 Paper Report:When running this report as a secure user, you are only able to view the employee details that you have access to through your security profile.
Select RL1 Paper Report in the Name field.
Click in the Parameters field if the Parameters window does not automatically open.
Select the Reporting Year and PRE Archived by Year End Preprocess for the RL1 report
Select an option for the Selection Criteria, if desired.
The values are Employee Name, Social Insurance Number, and Assignment Set. Depending on the option entered, the applicable field becomes enabled.
Select the applicable Employee Name, Social Insurance Number, or Assignment Set from the List of Values.
Click in the Sort Option One field and choose a sort option from the List of Values.
The options are Location, Organization, and PRE. The Sort Option Two field is now available. If desired, enter options in the Sort Option Two and Sort Option Three fields.
Note: For all three sort options, only the PRE Name and Address will be displayed in the Employer Name box.
In the Submit Request window, select the printer and number of copies, in the Options region.
Submit the report.
To configure the RL1 PDF generation:The Employee RL1 PDF concurrent program generates employee RL1 slips in PDF format. This program uses XML Publisher to create the file. Set Action Parameters Print File and Run XML Publisher for Report Generation to N (No) and perform the following steps to configure the RL1 slip generation behavior:
Edit the $XDO_TOP/resource/xdo.cfg configuration file.
If this file doesn't exist, you can create it.
This file has the following format:
<config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/">
<properties>
<property name="system-temp-dir">temporary_directory</property>
<property name="printer_name.pdf-stream-divider-max-output-size">
file_size_in_bytes</property>
</properties>
</config>
Replace temporary_directory with the directory where the concurrent program creates temporary files.
You can set it to one of the utl_file_dir directories.
Replace the printer_name with the name of a printer that supports PDF printing.
Replace the file_size_in_bytes with the maximum size file that can be printed on the printer.
If you leave the file_size_in_bytes parameter empty, the default is 1MB.
To generate RL1 PDF files:Select RL1 PDF in the Name field.
Click in the Parameters field if the Parameters window does not automatically open.
Select the Reporting Year and the PRE Archived by Year End Preprocess for the RL1 slip.
Select an option for the Selection Criteria, if desired.
The values are Employee Name, Social Insurance Number, and Assignment Set. Depending on the option entered the applicable field becomes enabled.
Select the applicable Employee Name, Social Insurance Number, or Assignment Set from the List of Values.
Select the appropriate value in the Print Terminated Employees Only field. You can select any one of the following options:
Yes: Prints RL1 PDFs of only the terminated employees.
No: Prints RL1 PDFs of all the active and terminated employees. No is the default value.
Click in the Sort Option One field and choose a sort option from the List of Values.
The options are Location, Organization, and PRE. The Sort Option Two field is now available. If desired, enter options in the Sort Option Two and Sort Option Three fields.
In the Template Group field, select the template for the current run, for example, 2009 RL1.
Note: PDF templates are retained only from 2008 forward. The Print Instructions parameter is not applicable if you select a template for the year 2013.
In the Print Instructions field, select Yes to print instructions and No to not print instructions.
Click OK.
In the Submit Request window, select the printer and number of copies, in the Options region.
Click Submit.
This concurrent program starts two "Generate Payroll XDO Reports" requests, one for the PDF template and one for the Error Template.
The "Generate Payroll XDO Reports" request for the PDF template may spawn multiple sub-request(s), called "Sub Request: (PDF Document Stream Printing)." The number of sub-requests is based upon the value of the pdf-stream-divider-max-output-size variable in XDO configuration file (xdo.cfg). Oracle Payroll generates the PDF outputs against this sub request
The "Generate Payroll XDO Reports" request for the Error Template generates a comma separated file that lists all the employees that did not have a PDF produce for them due to a negative balance.
Click Output to view the PDF file.
To run the RL1 Electronic Interface:For the RL1 Electronic Interface:
For BI Publisher XML and Payroll Engine based architecture, set Action Parameters Print File and Run XML Publisher for Report Generation to Y (Yes).
For BI Publisher XML and Java based concurrent program architecture, set Action Parameters Print File and Run XML Publisher for Report Generation to N (No).
Note: To verify the action parameter settings, navigate to Other Definitions > Action Parameters. If users have Action Parameter Group defined it should be used. Users can check their action parameter group in system profile 'HR:Action Parameter Group Name'. If nothing is defined Default Group should be used.
Select RL1 Electronic Interface in the Name field.
Click in the Parameters field if the Parameters window does not automatically open.
Enter the Reporting Year and the appropriate Transmitter PRE.
Click OK, and then Submit.
When the process completes, select Payroll Process Results from the View menu.
Click Find.
Select the RL1 Electronic Interface and click Output.
When Action Parameters Print File and Run XML Publisher for Report Generation are Y (Yes), the following files are generated (where XXXX represents the Organization ID of the transmitter PRE and YEAR represents the reporting year):
Base Request points to Output file that is a Junk file
5 Sub Requests are generated with the name Payroll File Reporter:
RL1_XXXX_YEAR_1_P.eft (Employer Summary Detail)
RL1_XXXX_YEAR_2_P.eft (Employee Error Detail)
RL1_XXXX_YEAR_3_P.pdf (Transmitter and Employer Summary Records)
RL1_XXXX_YEAR_4_P_M.xml (XML file to be sent to RQ)
RL1_XXXX_YEAR.xml (Internal Process File - XML)
Note: These files may also be found in the $APPLCSF/out directory.
When Action Parameters Print File and Run XML Publisher for Report Generation are N (No), 4 child requests of 'Generate Payroll XDO Reports' will be spawned and the following files are generated as output:
o<request_id>.out (to be sent to government), where request_id is of template 'RL1XML'.
Note: You need to change the extension from .out to .xml prior to uploading/sending to the government.
o<request_id>.out (Employer Summary Report), where request_id is of template 'RL1A01'.
o<request_id>.out (Employee Detail Report), where request_id is of template 'RL1A03'.
o<request_id>.out (Employee Error Report), where request_id is of template 'RL1A02'.
RL1_XXXX_YEAR.xml (Master xml), where XXXX represents the organization_id of the transmitter PRE and YEAR represents the reporting year.
Note: These files may also be found in the $APPLCSF/out directory. In all the above cases the template can be identified in the parameters field of sub requests 'Generate Payroll XDO Reports'.
Download the file to be sent to government:
Using BI Publisher XML and Payroll Engine based architecture, download the RL1_XXXX_YEAR_4_P_M.xml file.
Using BI Publisher XML and Java based concurrent program architecture, download the o<request_id>.out file and change the extension to .xml.
Submit the appropriate file to government.
To record the beginning and ending RL1 slip numbers:Revenu Quebec provides a starting and ending slip number range for the submission of RL1 slips via an electronic interface. These numbers appear in the upper right corner, top row, of the RL1 PDF and are also referenced in the electronic record for that slip.
To record the beginning and ending slip numbers:
In the Organization window, query the Prov Reporting Establishment if it does not already appear there.
In the Organization Classifications region, select Prov Reporting Establishment and choose Others.
In the Additional Organization Information window, click Prov Reporting Est3 and then OK.
Click inside the Prov Reporting Est. field to open the parameters window.
Enter the Starting RL1 Slip Number provided by Revenu Quebec for electronic reporting. This must be an 8 digit number.
Enter the Ending RL1 Slip Number provided by Revenu Quebec for electronic reporting. This must be an 8 digit number.
Note: The Provincial Year End Preprocess will not error out if the starting or ending slip number is missing, nor if the generated slip number exceeds the range. However, a warning message is written to the log file when you enable logging using action parameters.