Overview of Payroll Interface Inbound Records

Use the HCM Data Loader to import processed payroll data and payslips from third-party payroll providers.

Each import record is associated with a master record that specifies a payroll name and payroll period. The Inbound table stores the imported payroll information, while the document of record stores payslips.

You can create your own reports using Oracle Fusion Transactional Business Intelligence (OTBI). Use the mentioned Subject area and Fact data Data to create reports:

• Subject area: Payroll Interface Inbound Record - Real Time

• Fact Data: Payroll Interface Inbound Records and Payroll Interface Inbound Record Information

You can obtain these details from a typical data import:

• Absence entries of employees

• Employee specific messages

• Details of earnings and elements processed for employees

• Final payments made to employees

• Details of bank accounts to which payments are made

Extensible Flexfields

Oracle provides an extensible flexfield called Payroll Interface Inbound Record EFF (ORA_HRY_PI_INBD_RECORDS_INFO_EFF) to capture inbound payroll data from your third-party payroll processor.

These are the delivered contexts:

• Absence Information

• Message Information

• Payment Information

• Payroll Information

Predefined segments are associated with these contexts. In addition to this extensible flexfield, you can also use extensible and user-defined lookups to configure your inbound payroll interface with the third-party payroll provider.

Use the Manage Payroll Interface Extensible Flexfields task in Setup and Maintenance area to edit the Payroll Interface Inbound Record EFF flexfield. Contexts with predefined segments capture specific processed payroll values.

Payroll Interface Inbound Record

After your third-party payroll provider processes a payroll, the application extracts the results and configures them into a data file. Convert this data file to the HCM Data Loader required format.

This table shows the list of files to import your payroll data:

File Name	Content
PayrollInterfaceInboundRecord.dat You must use this file name as the HCM Data Loader recognizes only this file name.	Includes processed payroll information for employees included in the payroll run
PayrollInterfaceInboundRecord.zip After you create the data file, compress the file with the .zip file extension. In this scenario, you can create your own file name.	Compressed file that contains the data file

On the Home page, click the Payroll Interface Inbound Records quick action under the My Client Groups tab to perform these actions:

• Use one or more of these criteria to filter imported data:

  • Payroll Name

  • Batch Name

  • Name

  • Record Type

  • Person Number

  • Record Owner Type

• Select Payroll Data in the Record Type field to view, add, edit, and delete these details:

  • Payroll

  • Payment

  • Leave

  • Messages received from third-party payroll providers

Payslip Files

Use the HCM Data Loader to import payslips as PDF files into your Oracle Fusion HCM application.

This table shows the list of files to import payslips:

File Name	Content
DocumentsOfRecord.dat You must use this file name. The HCM Data Loader utility recognizes only this file name.	Data file listing employees for whom payslips are being provided. PDF file names
BlobFiles You must use this folder name. The HCM Data Loader utility recognizes only this file name.	Folder that contains all the PDF payslip files.
DocumentsOfRecord.zip In this scenario, you can create your own file name.	Compressed file that contains both the data file and PDF payslip files.

The import process looks for the PDF files based on the information contained in the data file. After you complete the import process, employees can view their payslips. Use the Payroll Interface Inbound Records task in My Client Groups, and select Payslip Data in the Record Type field to view payslip data.