• Post category:Fast Formula
  • Post comments:0 Comments
  • Post last modified:April 11, 2021
  • Reading time:2 mins read
You are currently viewing PBL to HDL Transformation Formula running to Error from 20D or 21A
PBL to HDL Transformation Formula running to Error from 20D or 21A
- PBL to HDL Transformation Formula running to Error from 20D or 21A
Total Visits: 6

In this article, we will look into how to resolve issues with PBL to HDL Transformation formula running to error from 21A or If the process “Load data from file” errors with the message “No HDL files found in directory: UcmUploadFile, for zipping at oracle.apps.hcm.interfaces.batch.ess.program.LoadBatchFromFile.zipFile(LoadBatchFromFile.java:2828)” in 20D.

The issue is we cannot run the “load data from file” with the multi-threading option. Whenever we run the flow with multi-threading it runs to error without any valid error message. Oracle has to resolve that issue in future releases, but they have provided a workaround to solve the issue.

A new profile option PAY_BATCH_TRANSFORMATION has been introduced by Oracle which needs to be set up to resolve the issue.

We can verify the profile option value with the following SQL Query:

SELECT *
FROM fnd_profile_option_values
WHERE profile_option_id IN (
		SELECT profile_option_id
		FROM fnd_profile_options_b
		WHERE profile_option_name = 'PAY_BATCH_TRANSFORMATION'
		)

If this profile option doesn’t exist in the POD, we need to create one and enable it.

Steps to configure profile option

Navigate to Setup and Maintenance>Search> Search for task: Manage profile options.

image 33 1024x376 - PBL to HDL Transformation Formula running to Error from 20D or 21A


Click Add and create a profile option using below details:

Name: PAY_BATCH_TRANSFORMATION
Code: PAY_BATCH_TRANSFORMATION
Application: Global Payroll
Module: Payroll Flows                   
Start date: 01/01/1951

image 34 - PBL to HDL Transformation Formula running to Error from 20D or 21A

Save and close.

image 35 1024x448 - PBL to HDL Transformation Formula running to Error from 20D or 21A

Check “Enabled” and “Updatable” at Site level. Click Save and Close.

Now Navigate to “Manage Administrator Profile values

Search for Profile code: PAY_BATCH_TRANSFORMATION

image 36 1024x454 - PBL to HDL Transformation Formula running to Error from 20D or 21A

Under Profile values , click Add; select Site, and set the value to: Y.

Finally click Save and Close.

Now the error that you faced should disappear and the load should get successful even with multi-threading for the process “load data from file”/ “load data from PBL file”.

If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.