In this post we will look into the PBL to HDL mapping for business objects and things that we need to take care of before the PBL is decommissioned by 20D.
If you check the previous article Oracle has provided a deadline of 20C for decommissioning Payroll Batch Loader aka PBL. However they have now postponed it by a release to 20D.
Please check the below email from Oracle to its customers.
Oracle has also provided a help document for this transition on the DOC ID
Transitioning from Payroll Batch Loader to HCM Data Loader: Overview (Doc ID 2557156.1)
PBL was mainly used to load the payroll data into cloud. Now Oracle suggests these approaches post PBL withdrawal:
- Incoming files in an HDL format. You can present data in HDL format and load them using HDL. In this case, no transformation is required.
- Data loaded using HSDL. You can use user-defined spreadsheet templates to load data using HCM Spreadsheet Loader (HSDL).
- File in a PBL format is converted into HDL format. You can use the HDL transformation formula to convert the PBL file into an HDL format. For sample transformation Fast Formula, see the Cloud Customer Connect forum Payroll Batch Loader (PBL) Conversion to HCM Data Loader (HDL) https://cloudcustomerconnect.oracle.com/posts/0e99071068
Table of Contents
Some Excerpts from the DOC ID:
Why is PBL decommissioned?
HCM Data Loader (HDL) is the recommended mechanism for moving and synchronizing large volumes of data between systems. To avoid confusion and additional complexity in our data loading model, we have chosen to consolidate all our data loading tools.
When is the end of life for PBL?
For customers using environments provisioned on 19C and later, Payroll Batch Loader (PBL) is not available and HCM Data Loader (HDL) is the only method for loading payroll business objects into Oracle HCM Cloud. For existing customers, Oracle will now be decommissioning PBL in 20D. You will no longer be able to use PBL for data conversion or integration after 20C.
I am an existing customer whose environments had been provisioned in 19B and I then purchased a new environment.Will PBL be disabled on my new environment?
In environments provisioned on 19C and later, PBL is disabled. If you complete an environment refresh, the newly provisioned environment will take on the behaviour of the source environment i.e. if the source environment has PBL enabled on it, then the target environment will also have PBL enabled on it
Do we need to create new Fast Formula transformation for HDL?
Yes. You are able to use the same logic as the PBL Fast Formula, but you will need to change the output to be the correct attributes and in the structure HDL requires
Does HDL do validations similar to PBL?
For example, does HDL validate balance loads and their feeds? Yes. HDL performs the same validation as PBL.
Can HDL support CSV based input files?
Yes. In HDL, the default delimiter that separates values is a pipe character, because it is rare that a value would include a pipe. However, you can override the delimiter and use a comma instead by adding a SET command at the top of the HDL file.
Is there a limit on the number of rows we can upload?
Yes, there is a limit of 19,999 rows in any one upload. I am not too clear on this limit of 19999 rows.. Will have to test and see if it’s the number of lines on the input file or the HDL file.
Currently, PBL supports a wide range of entities, such as element entries, payroll balance conversion, and so on. Is PBL being deprecated only for element entries?
PBL will be depreciated for all objects.
Mapping of the PBL task Names to HDL Business Objects:
Legislation Code
|
PBL Task Name
|
PBL Action Name
|
Object Hierarchy
|
Localization White Paper MOS Doc ID
|
|
Balance
|
Adjust Multiple Balances
|
Balance Adjustment Line
|
|
|
Balance
|
Delete Balance Definition
|
Payroll Balance Definition
|
|
|
Balance
|
Delete Balance Feed
|
Payroll Balance Definition
|
|
|
Balance
|
Initialize Balance
|
Balance Initialization Batch
|
|
|
Balance
|
Merge Balance Definition
|
Payroll Balance Definition
|
|
|
Balance
|
Merge Balance Dimension
|
Payroll Balance Definition
|
|
|
Balance
|
Merge Balance Feed By Element
|
Payroll Balance Definition
|
|
|
Balance Group
|
Add a Defined Balance
|
Balance Group
|
|
|
Balance Group
|
Remove a Defined Balance
|
Balance Group
|
|
|
Bank
|
Create Bank
|
Bank
|
|
|
Bank and Branch
|
Create Bank
|
Bank
|
|
|
Bank and Branch
|
Create Bank Branch
|
Bank Branch
|
|
|
Bank and Branch
|
Inactivate Bank
|
Bank
|
|
|
Bank and Branch
|
Inactivate Bank Branch
|
Bank Branch
|
|
|
Bank Branch
|
Create Bank Branch
|
Bank Branch
|
|
|
Calculation Card
|
Create or Update Association
|
Calculation Card
|
|
|
Calculation Card
|
Create or Update Calculation Card
|
Calculation Card
|
|
|
Calculation Card
|
Create or Update Calculation Card Component
|
Calculation Card
|
|
|
Calculation Card
|
Create or Update Calculation Card Component Calculation Value
|
Calculation Card
|
|
|
Calculation Card
|
Create or Update Calculation Card Component Detail
|
Calculation Card
|
|
|
Calculation Card
|
Delete Calculation Card
|
Calculation Card
|
|
|
Calculation Card
|
Delete Calculation Card Component
|
Calculation Card
|
|
|
Calculation Card
|
Delete Calculation Card Component Detail
|
Calculation Card
|
|
|
Cost Allocation
|
Create Cost Allocation
|
Cost Allocation
|
|
|
Cost Allocation
|
Delete Cost Allocation
|
Cost Allocation
|
|
|
Element
|
Create Element Eligibility
|
Payroll Element Definition
|
|
|
Element
|
Create Input Value
|
Payroll Element Definition
|
|
|
Element
|
Create People Group Key Flexfield Segment Combination
|
Worker
|
|
|
Element
|
Delete Element
|
Payroll Element Definition
|
|
|
Element
|
Delete Element Eligibility
|
Payroll Element Definition
|
|
|
Element
|
Delete Input Value
|
Payroll Element Definition
|
|
|
Element
|
Delete People Group Key Flexfield Segment Combination
|
Worker
|
|
|
Element
|
Update Element
|
Payroll Element Definition
|
|
|
Element
|
Update Input Value
|
Payroll Element Definition
|
|
|
Element Entry
|
Create Element Entry
|
Element Entry
|
|
|
Element Entry
|
Delete Element Entry
|
Element Entry
|
|
|
Element Entry
|
Quick Create
|
Payroll Element Details
|
|
|
Element Entry
|
Update Element Entry
|
Element Entry
|
|
|
External Bank Account
|
Add Person to Existing Account
|
External Bank Account
|
|
|
External Bank Account
|
Create External Bank Account
|
External Bank Account
|
|
|
External Bank Account
|
Inactivate External Bank Account
|
External Bank Account
|
|
|
External Bank Account
|
Update Prenote Status
|
Payroll Bank Account Prenote Status Update
|
|
|
Create
|
| ||
|
Delete
|
| ||
|
Update
|
| ||
|
Fast Formula Global
|
Create
|
Fast Formula Global
|
|
|
HCM User-Defined Table
|
Create User-Defined Column
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Create User-Defined Column Instance
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Create User-Defined Row
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Create User-Defined Table
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Delete User-Defined Column
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Delete User-Defined Column Instance
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Delete User-Defined Row
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Delete User-Defined Table
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Update User-Defined Column
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Update User-Defined Column Instance
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Update User-Defined Row
|
User-Defined Table
|
|
|
HCM User-Defined Table
|
Update User-Defined Table
|
User-Defined Table
|
|
|
Object Group
|
Create
|
Object Group
|
|
|
Object Group
|
Delete
|
Object Group
|
|
|
Object Groups
|
Add Payroll Relationship Inclusions and Exclusions
|
Object Group
|
|
|
Object Groups
|
Create Payroll Relationship Group
|
Object Group
|
|
|
Object Groups
|
Create Payroll Relationship Inclusion and Exclusion
|
Object Group
|
|
|
Object Groups
|
Delete Payroll Relationship Group
|
Object Group
|
|
|
Object Groups
|
Delete Payroll Relationship Inclusion and Exclusion
|
Object Group
|
|
|
Object Groups
|
Remove Payroll Relationship Inclusions and Exclusions
|
Object Group
|
|
|
Payment Method
|
Create Personal Payment Method
|
Personal Payment Method
|
|
|
Payment Method
|
Create Third-Party Organization Payment Method
|
Third Party Organization Payment Method
|
|
|
Payment Method
|
Create Third-Party Personal Payment Method
|
Third Party Personal Payment Method
|
|
|
Payment Method
|
Delete Personal Payment Method
|
Personal Payment Method
|
|
|
Payment Method
|
Delete Third-Party Organization Payment Method
|
Third Party Organization Payment Method
|
|
|
Payment Method
|
Delete Third-Party Personal Payment Method
|
Third Party Personal Payment Method
|
|
|
Payment Method
|
End-Date Personal Payment Method
|
Personal Payment Method
|
|
|
Payment Method
|
Update Third-Party Organization Payment Method
|
Third Party Organization Payment Method
|
|
|
Payment Method
|
Update Third-Party Personal Payment Method
|
Third Party Personal Payment Method
|
|
|
Payroll Definition
|
Create Payroll Definition
|
Payroll Definition
|
|
|
Payroll Definition
|
Delete Payroll Definition
|
Payroll Definition
|
|
|
Payroll Definition
|
Update Payroll Definition
|
Payroll Definition
|
|
|
Payroll Relationship
|
Add Payroll
|
Assigned Payroll
|
|
|
Payroll Relationship
|
Delete Payroll
|
Assigned Payroll
|
|
|
Payroll Relationship
|
End Payroll
|
Assigned Payroll
|
|
|
Payroll Relationship
|
Update Assigned Payroll Details
|
Assigned Payroll
|
|
|
Payroll Relationship
|
Update Assignment Details
|
Payroll Relationship Details
|
|
|
Payroll Relationship
|
Update Payroll Element Duration Date
|
Element Duration Date
|
|
|
Person Delivery Method
|
Load Person Delivery Method
|
Worker
|
|
|
Person EFF
|
Load Person EFF
|
Worker
|
|
|
Person Legislative Data
|
Load Person Legislative Data
|
Worker
|
|
CA
|
CA Employee Withholding Federal Card
|
Upload Federal Card Details
|
Calculation Card
|
2562730.1
|
CA
|
CA Employee Withholding Regional Card
|
Upload Provincial Card Details
|
Calculation Card
|
2562730.1
|
CN
|
Chinese Personal Deduction Card Information
|
Create Foreigner Code
|
Calculation Card
|
|
CN
|
Chinese Personal Deduction Card Information
|
Create Individual Income Tax Component and Details
|
Calculation Card
|
|
CN
|
Chinese Personal Deduction Card Information
|
Create Social Security Component and Details with Possible Taxable Contributions
|
Calculation Card
|
|
CN
|
Chinese Personal Deduction Card Information
|
Create Social Security Component and Details without Taxable Contributions
|
Calculation Card
|
|
CN
|
Chinese Personal Deduction Card Information
|
Update Individual Income Tax Details and Associations
|
Calculation Card
|
|
CN
|
Chinese Personal Deduction Card Information
|
Update Social Security Details with Possible Taxable Contributions
|
Calculation Card
|
|
CN
|
Chinese Personal Deduction Card Information
|
Update Social Security Details without Taxable Contributions
|
Calculation Card
|
|
GB
|
Manage Pay As You Earn
|
NI Category Update
|
Calculation Card
|
2098480.1
|
GB
|
Manage Pay As You Earn
|
NINO Verification Reply
|
Calculation Card
|
|
GB
|
Manage Pay As You Earn
|
P6 P6B P9 EDI Upload
|
Calculation Card
|
|
GB
|
Manage Pay As You Earn
|
Start Of Year
|
Calculation Card
|
|
GB
|
Manage Pay As You Earn
|
Student Loan EDI Upload
|
Calculation Card
|
|
GB
|
Manage Pay As You Earn
|
Tax Code Uplift
|
Calculation Card
|
|
GB
|
UK Payroll Personal Deduction
|
Create Statutory Deductions Card
|
Calculation Card
|
2098480.1
|
US
|
Period Of Service US Legislative Data
|
Update PPS US Legislative Data
|
Worker
|
|
US
|
Upload Calculation Rules for Tax Reporting and Payroll Statutory Unit
|
Update City Calculation Rules
|
Calculation Card
|
|
US
|
Upload Calculation Rules for Tax Reporting and Payroll Statutory Unit
|
Update County Calculation Rules
|
Calculation Card
|
|
US
|
Upload Calculation Rules for Tax Reporting and Payroll Statutory Unit
|
Update Federal Calculation Rules
|
Calculation Card
|
|
US
|
Upload Calculation Rules for Tax Reporting and Payroll Statutory Unit
|
Update State Calculation Rules
|
Calculation Card
|
|
US
|
US Employee Earnings Distribution Overrides
|
Upload Employee Earnings Distribution Overrides
|
Calculation Card
|
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Alimony Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Bankruptcy Order Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Child Support Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Creditor Debt Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload DCIA Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Educational Loan Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Employee Requested Involuntary Deduction Data
|
Calculation Card
|
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Garnishment Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Regional Tax Levy Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Spousal Support Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Involuntary Deduction Card Details Upload
|
Upload Tax Levy Involuntary Deduction Data
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Federal Card
|
Upload Federal Association Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Federal Card
|
Upload Federal Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload Common City Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload Common County Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload Common State Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State AL Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State AR Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State DC Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State GA Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State IA Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State IN Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State KY Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State LA Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State MA Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State MD Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State ME Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State MO Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State MS Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State NC Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State NJ Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State NY Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State OH Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State PA Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State VA Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State WI Component Details
|
Calculation Card
|
2558276.1
|
US
|
US Employee Withholding Regional Card
|
Upload State WV Component Details
|
Calculation Card
|
2558276.1
|
|
External Bank Account
|
Configure Bank Account Details
|
| |
|
Third Party
|
Create Third-Party Organization
|
|
2639267.1
|
|
Third Party
|
Merge Address
|
|
2639267.1
|
|
Third Party
|
Update Third-Party Organization
|
|
2639267.1
|
Tip: DO NOT WAIT till the end of 20D to move your PBL integrations into HDL. If you are using PBL to load any payroll objects, then try to load those objects using HDL from now on. You will face some issues with HDL at the beginning however by the PBL is decommissioned, you will be in better shape.