Running the CFDI Payroll Payslip XML Extract

The ISR tax legislation establishes the employer obligation to generate the employee payroll payslips in XML format to be able to get the CFDI (Certificado Fiscal Digital por Internet - Internet Digital Fiscal Certificate) from the government agency SAT.

Before you run this process, ensure that you have completed the setup steps: Setting up Information for CFDI Payroll Payslip XML Interface

Oracle Payroll for Mexico enables you to generate the payslips in an XML format using the CFDI Payroll Payslip XML Extract process.

You can run the process from the Submit Request window.

arrow icon   To run the CFDI Payroll Payslip XML Extract process:

  1. Select CFDI Payroll Payslip XML Extract as the name.

  2. The concurrent program CFDI Payroll Payslip XML Interface has the following parameters:

    Parameter Name Description
    Payroll Select the payroll for which this process needs to be run.
    Consolidation Set Select the consolidation set for which this process needs to be run.
    Start Date
    End Date     		Enter the start and end dates the process will use to determine the payroll actions to be picked. The payroll actions processed within the given period will only be picked.
    Assignment Set Select the assignment set to select the set of employees.
    CFDI Payslip Style Select the template to be used to generate the XML output. You can use the default template: 'Mexico Payslip XML Template' or create your own. Use XML Publisher (XDO) to create a new template.
    For information on how to create your own XML template to generate the XML output for the CFDI payslip, refer to the My Oracle Support Document: Doc ID 1675858.1
    CFDI Payroll Type Select the payroll type that you want this process to use when generating the CFDI payslip. The default value is Regular Payroll.
    SNCF Source of the resource Specify the SNCF source of the resource that you want to be reported in the CFDI payslip.
    SNCF Own resource amount Enter the amount corresponding to own resource, when the source of income is of type Mixed Income. This parameter gets enabled and is mandatory only if the parameter SNCF Source of the resource chosen is Mixed Income (IM).

arrow icon   Concurrent Programs:

The CFDI Payroll Payslip XML Interface program internally triggers two separate concurrent programs: XML Report Publisher and Generate MX XML Payslip File.

Note: The Generate MX XML Payslip Files concurrent program which gets triggered by the CFDI Payroll Payslip XML Extract process gets completed in error, if the action parameter Run XML Publisher for Report Generation (RUN_XDO) is set to N. In the Action Parameters window, set the action parameter RUN_XDO to Y for the Generate MX XML Payslip Files process to get completed successfully.

Program Description
XML Report Publisher The program XML Report Publisher displays the CFDI XML Payslip with all the employees.
The root tag of the XML file is <PAYSLIP_REPORT> and each employee payslip is divided into sub root tag <cfdi:Comprobante>. Note that the name of this request changes to CFDI Payroll Payslip XML Extract (XML Report Publisher) upon completion.
Generate MX XML Payslip File The program Generate MX XML Payslip Files generates the individual XML Payslip files in utl_file directory in the file system. The name of the file written to file system is in the following format:
R<Request_id>A<assignment_id>E<Employee_number>D<Payroll_End_Date_ in_MMDDYYYY>_<Payroll_Name_10_characters>.xml
Example: If Request id=12100, Assignment_action_id=91000, Employee number = 71, Payroll period end date = 15-JAN-2014 and payroll name = Quince_Payroll then the file name will be:
R12100A91000E71D01152014_Quince_Pay.xml
To know the details about the files and the directory in which the files are generated (utl_file) by this process, click the View Output button of this concurrent program. The output shows the utl_file directory where the payslips are generated along with the name of each payslip file and corresponding employee details.
Note: The utl_file directory where individual XML payslip ouputs are stored is the first directory path of utl_file_dir parameter value of the table v$parameters. 
SELECT value 
FROM v$parameter 
WHERE name = utl_file_dir;

arrow icon   Viewing Output Files:

You can view the various output files generated by the CFDI Payroll Payslip XML Extract program and its related requests: XML Report Publisher and Generate MX XML Payslip Files.

To view the assignment's CFDI payslip navigate to the Employee Assignment Processes window and query for an employee. Select the CFDI Payslip Process and view the output.

The View Output shows two XML files: one the internal XML file (base XML) and other the CFDI payslip for the assignment.

arrow icon   Individual Payslip Generation:

The CFDI Payroll Payslip XML Extract generates XML payslips for each employee. You can view an employee's payslip in the View Assignment Process Results window.

arrow icon   Consolidated Payslip Generation:

To view the consolidated CFDI payslip for all the assignments, navigate to the Requests window and view the output for CFDI Payroll Payslip XML Extract.

arrow icon   Rerun the process:

The program uses the interlock mechanism and does not allow administrators to rerun the process for the same set of employees.

To rerun the process, you must rollback the process for the same set of employees:

  1. Navigate to the Submit Request window.

  2. Select Rollback MX Payroll Process.

  3. Select the Magnetic Report process type.

  4. Select MX_XML_PAYSLIP as the payroll process.

  5. Submit the process.