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 alongwith their 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.

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 alongwith their 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.

Note: When supplying Payslip data you must supply the Payroll Relationship.

The import process looks for the PDF files based on the information contained in the data file.

PayrollInterfaceInboundRecord.dat (Sample)

METADATA|PayrollInterfaceInboundRecord|InbdRecordId|SourceType|EntityIdentifier|FunctionalCategory|RecordType|PeriodName|StartDate|BatchCode|BatchDate|VendorCode|LegislativeDataGroupName|PayrollName|CategoryCode|DocumentCode|DocumentType
MERGE|PayrollInterfaceInboundRecord||Payroll Relationship|955160008173009|ADP Payforce|Payslip Data|11 2015 Monthly (Calendar)||Monthly Payroll Data Nov15|2015/11/01 00:00:00|ADP|Vision Corporation US LDG|ZHRX_US_PayrollOne|ORA_HRY_INBD_PAYSLIP|ThirdPartyPayslip_955160008173009_Nov2015|Third Party Payslip
METADATA|PayrollInterfaceInboundRecordInfo|FLEX:ORA_HRY_PI_INBD_RECORDS_INFO_EFF|EFF_CATEGORY_CODE|InbdRecordInfoId|InbdRecordId|SourceType|RecordType|BatchCode|FunctionalCategory|EntityIdentifier|LegislativeDataGroupName|PayrollName|PeriodName|IriInformationContext|SourceSystemOwner|SourceSystemId|GUID|NetPayment(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_THIRD_PARTY_PAYSLIP)|PayslipViewDate(ORA_HRY_PI_INBD_RECORDS_INFO_EFF=ORA_HRY_THIRD_PARTY_PAYSLIP)
MERGE|PayrollInterfaceInboundRecordInfo|ORA_HRY_THIRD_PARTY_PAYSLIP|ORA_HRY_INBD_PAYSLIP|||Payroll Relationship|Payslip Data|Monthly Payroll Data Nov15|ADP Payforce|955160008173009|Vision Corporation US LDG|ZHRX_US_PayrollOne|11 2015 Monthly (Calendar)|ORA_HRY_THIRD_PARTY_PAYSLIP|HRC_SQLLOADER|ADP_955160008173009_ORA_HRY_THIRD_PARTY_PAYSLIP_0101||5550|2015/11/20

DocumentsOfRecord.dat (Sample)

METADATA|DocumentsOfRecord|PersonNumber|DocumentType|Country|DocumentCode|DocumentName|DocumentNumber|DateFrom|DateTo|IssuingAuthority|IssuedDate|IssuingCountry|IssuingLocation|Comments|Publish|PublishDate|Status|VerifiedBy|VerifiedDate
MERGE|DocumentsOfRecord|955160008173009|Third Party Payslip||ThirdPartyPayslip_955160008173009_Nov2015|USThirdPartyPayslip||2015/11/01|2015/11/30||2015/11/30||||||||
METADATA|DocumentAttachment|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|Title|URLorTextorFileName|File
MERGE|DocumentAttachment|955160008173009|Third Party Payslip||ThirdPartyPayslip_955160008173009_Nov2015|FILE|November Payslip|USOnlinePayslip_November_2015.pdf|USOnlinePayslip_November_2015.pdf

After you complete the import process, employees can view their payslips in these ways:

On the Home page, click the My Payslips quick action under the Me tab.
On the Home page, click the My Payslips under Pay under the Me tab.
On the Home page, click the Person Management quick action under the Me tab.

Use the Payroll Interface Inbound Records task in My Client Groups, and select Payslip Data in the Record Type field to view payslip data.