Example of Importing Generated Payslips

Use HCM Data Loader to load a payslip that was generated in compressed format, from a third-party application into Oracle HCM Cloud.

The application uses the PayrollInterfaceInboundRecord discriminator to load already generated payslips with the same attributes that are supplied when loading employee's payroll data.

The application uses the PayrollInterfaceInboundRecord discriminator to load the already generated payslips with the same attributes that are supplied when loading employee's payroll data.

The application uses the PayrollInterfaceInboundRecord discriminator to load the already generated payslips with the same attributes that are supplied when loading employee's payroll data.

Note: The application uses the PayrollInterfaceInboundRecord discriminator to load already generated payslips with the same attributes that are supplied when loading employee's payroll data.

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

The HCM Data Loader application uploads the payslips that are generated by a third-party application into the Document of Record business object.

The payslip data has two sections.

1. The first part is a data file that contains a list of employees for that require payslips and their respective payslip file names. You must name the payslip data file as DocumentsOfRecord.dat.

2. The second part is the collection of actual payslip files. You must provide this dat file in the form of a compressed file and group these files into a BlobFiles subfolder. This file must contain the DocumentsOfRecord.dat file and the subfolder BlobFiles containing the payslip files. You use this compressed file for loading the data.

In this DocumentsOfRecord.dat file, the DocumentsOfRecord discriminator is used for the header record and the DocumentAttachment record provides the attachment details. You must reference the compressed file placed in the BlobFiles folder by name against the File attribute in the DocumentAttachment record.

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