HDL – Sample file to upload Talent Pool
Use below sample HDL file to create talent pool and add members to it:
-
-
HDL – Talent Profile HDL related useful queries
Loading the profile data against a worker/job/position is little tricky one. One has to understand the templates thoroughly before uploading any data. Below are some of the most commonly used queries to extract some of the required information for loading Talent profiles data. Extract Person Profile Code: Extract Profile Type Id:
-
HDL – Sample HDL to load Succession Plans
Sample HDL for succession plan bulk upload:
-
BIP – Extract environment url dynamically
For many BIP reports, it is required to publish the environment url. One can easily hardcode it in SQL query, however, when P2T or T2T happens, the same url gets copied to target instance which is incorrect. The better way of doing it is to use below piece of code in custom SQL to extract…
-
HDL – DELETE Person External Identifier
Person External Identifier information can be deleted easily using HDL. Under Worker use ExternalIdentifier to delete this data. Run the below query to extract required data in HDL format: Sample HDL File:
-
-
-
BIP – Query to DELETE Salary data using HDL
There may be a requirement to delete salary data while doing HDL iterations for the first time. You can use below query for the same purpose
-
HDL – Query to DELETE Assigned Payroll data from Fusion
In case, you need to delete assigned payroll data for masking purpose in lower environment or for some other reason like correction etc, use below query to pull the data in HDL format: Sample HDL File:
-
HDL – Load Position Model Profile Extra Info
For Position Model profiles, there are additional attributes like Description, Qualification and Responsibilities. To load these, one should make use of ModelProfileExtraInfo child business object of TalentProfile.dat. Attributes values for Description, Qualification and Responsibilities should be stored in txt files. The txt file(s) should then be placed under the ClobFiles folder and should be zipped…
-
HDL – Loading Competencies against Worker
TalentProfile.dat can be used to create worker talent profiles and loading content items against the talent profiles. While some of the content items load is straight forward, loading competencies is little tricky one. This is because there are some additional fields like QualifierId1 and QualifierId2 which should be supplied to make the loaded data available…
-
HCM Extracts – Inbound HCM Extract “Assertion Failure” Error
HCM Extracts with inbound delivery are one of the most powerful technical features of the Fusion HCM cloud. HCM Extracts with inbound delivery enables the technical consultants to do customizations and automations by making use of tools like BIP, HCM Extracts and HCM Data Loader. You can follow the below post for more details on…
-
BIP – Query to extract Rating Model Levels in HDL Format
This is second post in a series to extract Rating Model data from Fusion environment in HDL format. The first post has a query to extract only the rating model data and second post describes the BIP query to extract rating model levels data. Query to extract Rating Model data: Query to extract Rating Model…
-
BIP – Query to extract Rating Model data in HDL Format
You can use below query to extract Rating Model data from fusion environment for updates. Save the data as RatingModel.dat before uploading to Fusion. You can make use of this query to extract data for reference or use it as a method to extract data from one instance and upload it to a different instance….
-
HDL – Sample file to Upload Rating Model
Rating models can be uploaded in bulk using HDL. Use RatingModel business object. Below is a sample file:
-
-
HDL – Sample HDL to Update User Table value
SQL Query to extract data for a particular value of a user table: Sample HDL:
-
BIP – HDL to update Grade Rate values
SQL to extract data in HDL Format: Sample HDL:
-
-