-
-
BIP – Restricting succession plans access to logged in person in BIP reports
Succession Plans data is stored in HRM_PLANS table. A succession plan can a PUBLIC or PRIVATE plan. By default if any user accesses HRM_PLANS table, user will be able to see all plans data irrespective of plan type (public or private). The requirement here is that a person who is querying data should be able…
-
-
BIP – Query to extract Calendar Event details
Calendar events are used in HCM to capture public holidays available to employees based on their location or department. Below SQL queries can be used to extract the list of configured calendar events from backend table: List of all calendar events configured: List of calendar events by location:
-
HDL – Sample HDL to load HCM Group Members
Oracle provides HCMGroup.dat which can be used to assign members against HCM Group. However, the business object has a major limitation (till release version 22A) that it can be used only for below two seeded Oracle HCM Groups: Manually Maintained Excluded Members Manually Maintained Audit Members Below is the sample HDL file to add members…
-
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:
-
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…
-
-
-
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 – 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…
-
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 HDL to Update User Table value
SQL Query to extract data for a particular value of a user table: Sample HDL:
-
-
-
HDL – Query to generate worker email in HDL format
Sample HDL File:
-
BIP – Extract Absence Entry data in HDL Format
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:
-
BIP – Query to extract child positions for a logged in person’s position
Fusion HCM provides you the capability of using Position Trees as well as Position Hierarchies. In case you need to extract child position details based on position id of logged in person, you can make use of below query: