There are few update for HCM Data loader in Rel 20D update. Let's see the updates: 1) PrimaryFlag attribute is removed from Assignment Metadata of Worker file. 2) PersonId attribute is removed from WorkTerms and Assignment Metadata of Worker file. 3) AssignmentId and AssignmentNumber is being added in Absence Entry business Object. 4) Business Object task enhancements: i) There is symbol which represents which objects are mandatory for example in below screenshot Work Relationship , Employment Terms and Assignments are required for new records. ii) Conditionally required objects. iii) Objects which are getting decommissioned. Above are few of the updates regarding HCM data loader in Rel 20D. Hope you have liked this post.
Posts
There are general requirements for loading the External Bank Account for employees during the project implementation which will be used either for expenses or Payroll. Let's go through the pre-requisite and steps for loading the External bank account using HDL Pre-Requisite: There is pre-requisite to generate party id before loading the External Bank Account. 1) We need to run the " Synchronize Person Records " scheduled process by entering the details: This process should generate the Party Id for employee which have been migrated using HDL. 2) If Party Id is still not generated even after running the above process then run the " Maintain Party and Location Current Record Information " This process should generate the Party Id for employee which have been migrated using HDL. Once the Party Id is generated run Load the External Bank Account HDL file. Below is sample ExternalBankAccount.dat file: METADATA|ExternalBankAccount|BankNumber|BankName|BankBranchNumbe
There are some changes for HCM Extract in Rel 20D update. Let's see the changes one by one: 1) Rename HCM Extract It was not possible to rename the HCM Extract earlier than Rel 20D. Now after 20D, users can update the name of HCM Extract. Please follow the below steps to rename the HCM Extract: 1) Navigation: Navigator> My Client Groups > Data Exchange> Extract Definitions 2) Search for HCM Extract and click on Copy Marked in Yellow : 3) Two Action will be there: Copy and Rename. Please select rename. 4) Provide the new name and click on "Ok". 2) Defaulting Rule for Effective Date: There is an option to default the Effective Date to SYSDATE. Please follow the below step to enable the defaulting to Effective date Parameter. 1) Search of HCM Extract where effective date parameter need to be updated and click on HCM Extract. 2) Go to Parameter Section > Select Effective Date parameter > Change from Basic View to Advan
Full-time equivalent (FTE) is an important component when we load worker data in Oracle fusion using HCM Data Loader(HDL). F ull-time equivalent (FTE) value gets calculated by diving the assignment normal working hours by standard working hours of employee. You can refer Loading Worker object using Fusion HCM Data Loader(HDL) article to see steps to load worker. During the migration, we can either migrate the FTE using the AssignmentWorkMeasure Metadata of Worker file from the legacy system or we can request FTE to be calculated automatically. We will see how can request FTE to be calculated automatically while doing the Data Migration. We need to include the following instruction in Worker.dat file to calculate FTE automatically while loading worker. SET CALCULATE_FTE Y; Worker file will look like as below: Once this file gets loaded the FTE of employee will be automatically calculated. Please see the screenshot of employee from UI We had not passed the AssignmentWorkMeasure Det
This post is going to be first part of loading different objects using HCM Data Loader (HDL). In this post we will Hire Worker using the HDL. Before starting with steps to load worker data using HDL , please go through the post Supported Keys in Fusion HCM Data Loader Now we will go through the steps to prepare Worker file and load data: 1) Generate the Template: Please follow the Navigation to generate the worker template Navigator > My Client Group > Data Exchange> View Business Objects > Search for Worker Select the business object and Click on " Refresh Business Object " 2) Download the template 3) Populate the worker file and worker file will look like as below. 4) zip the Worker.dat file. 5) Run HDL using the following Navigation: Navigator > My Client Group > Data Exchange> Import and Load > Import file 6) Browse file from you local machine and Submit as shown in below screenshot: 7) You can verif