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 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…
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…
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….
Rating models can be uploaded in bulk using HDL. Use RatingModel business object. Below is a sample file:
SQL Query to extract data for a particular value of a user table: Sample HDL:
SQL to extract data in HDL Format: Sample HDL:
Sample HDL File:
In case, you want to cancel work relationship of a Pending worker, below HDL can be used. Make sure to pass CancelWorkRelationshipFlag as Y. Sample HDL: You can extract the relevant Ids using below SQL:
The below query extracts the minimum required attributes for absence entry update. In the current example, the absence status is updated to Withdrawn. You can make the changes as per your need: Sample HDL File:
Below is the sample file (tested on an older version) to load rehire worker records but the structure should remain same. Few attributes may be deprecated now, so you may get an error. Please remove those and it should work fine.
Use any of the below formats of Organization HDL to update descriptive flexfield attribute: Using Surrogate IDs: Using User Keys: Version Validated :- 21D
HDL supports deletion of element eligibilities. You can make use of PayrollElementDefinition business object. Child object ElementEligibility supports create, update and delete operations. You can create a simple BIP query to extract the requisite data and create an HDL file out of it: Sample HDL file: Sometime you may get an error that You can’t delete…
Historical performance ratings can be loaded into Worker Talent Profile using TalentProfile.dat business object. Below is the sample HDL (enhanced profiles (v2)), to load performance rating data: In order to make the loaded performance rating visible in UI, Source Type and Qualifier ID should be passed. Values of source type and qualifier Id depend upon…
In rare cases, while uploading the HDL file from Data exchange results in HRC-1035375 – A connection to the WebCenter Content Server Couldn’t be established. Resolution to this error is to raise an SR with Oracle support and ask them for OID services bounce.
