Do customers and partners need to supply their data in a specific format for HCM Data Loader (HDL)?

The data loader currently has support for a file format that uses pipe delimiters. In this format, all the data related to a particular business object can be included in a single file. For example, if you're migrating employee data, you can include the person information, work relationship details, and assignment data in the same file.


How to control the access for a particular business object in HCM Data Load

In this blog, we will understand how to restrict access to a particular business object for a particular role. So if the particular role will try to upload the data using a restricted business object, and then the system will the error message that "You don't have permission to load data for the Worker business object.


How will you migrate the reports in the production instance?

If you need to move your reports from one instance to another, you can use the Archive and Unarchive features. Here are the steps to follow: - In the instance where your report is located, select it and click on the Archive button. This will save your report as a file in your local storage.


How to delete the records in HDL Loader?

If you want to remove some data from your HDL Loader, you can use the delete option in your dat file. This will erase the records that match the criteria you specify. Here is how you can do it: 1. Open your dat file in a text editor.2. Find the...


What is date tracking in the fusion application and which tables it will affect?

Date tracking means maintaining a history of changes to personal records. Date tracking is based on two columns they are effective_start_date and effective_end_date


How to develop a report?

-> Login into the fusion applications -> Click on Navigator -> Click on Reports& Analytics


How to provide security for the report?

1. After developing the report, we can go to click on the permission button. 2. Click on add button and select for the type of user or application role 3. Set the parameter is custom and click on the ok button.


What is the Bursting and how to create bursting?

Bursting means sending a notification to clients. 1. Go to navigator click on reports and analysis 2. Click on the catalog button to open another window click on the new button and select the data module to create one report.


What are the columns mentioned in your worker file?

Based on Clint’s requirement it is mentioned in the worker file that the mandatory columns are the Effective start date, Effective end date, Source System id, source system owner, action code, person number, etc.


What are the keys in the fusion application and why do we use these keys?

1. Source system owner & source system id: The data migrate from one instance to another instance suppose the data migrate to the people soft into the fusion application and the data is not existing in this application. 2. User keys: In the fusion application, the record will be already existing ex. update, correction


Who can load HDL? What are roles required?

Human Capital Management Application Administrator and Human Capital Management Integration Specialist roles to the user that persons only load the data using HDL.


Navigation of HDL loader?

1. First we need to develop the data file based on the client's requirement 2. Then saves it as dat file 3. After that Dat file is convert to a Zip file 4.Goto navigator data exchange & click on import & load data


How to restrict the report for particular user

There are some steps that show how to restrict the report for a particular user


Workforce Management - Areas of Responsibility subject area does not provide any output

We need to check whether or not the user has both duty roles added to the data role. Areas of Responsibility Transaction Analysis Areas of Responsibility Transaction Analysis Duty Additionally, ensure you have added the following DSP to your custom role


What are the roles required to access the BI Publisher

Below are the duty roles and these are already part of the human resource specialist and human resource analyst job role - BI Consumer Role - BI Author Role - it will give you the access to create the report and its already part of the human resource analyst and compensation analyst


OTBI report is not pulling a specific field value using document record (DOR) subject area

We have checked and found that the user has created more than 20 dors and there is a common field in all the 20 dors that is the date of joining. So when we are running the report then the report is not giving any data and the column is coming as blank. Then we have identified the below workaround.


Not able to access the OTBI Recruiting Subject Area

You need to assign Recruiting Administrator role.


List of HCM SQL Query Tables

PERSON DOCUMENTATION HR_DOCUMENTS_OF_RECORD PAY_PAY_RELATIONSHIPS_F PAY_PAY_RELATIONSHIPS_DN PER_LDAP_REQUESTS


How to control the access for a specific report

You have the BI administrator duty role which gives full access (admin level access) to all reports. If you want to delete the option to be removed even from this role then you have to go to the specific folder or specific report from which you want to remove the...


List of Supported Business Object for HDL or .dat file names

Business Object - File Name Absence Case - AbsenceCase.dat Action - Actions.dat Action Reason - ActionReasons.dat Action Reason Translation - ActionReasonsTranslation.dat Action Translation - ActionsTranslation.dat