New Deadline for Payroll Batch Loader 20D Nov 2020
New Deadline for Payroll Batch Loader 20D Nov 2020

 2,118 total views

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.

Want to learn Fusion Technical tools? Checkout this article

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.

PBL decommissioned by 20D. PBL Transformation formulas need to be moved to HDL Transformation formulas in fusion hcm

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 (HDLhttps://cloudcustomerconnect.oracle.com/posts/0e99071068 

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
 
 
Create
 
 
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.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply