-
-
HDL – Script to DELETE positions data
In your test environments, you may encounter issues where you want to DELETE positions data. You can use below script for that:
-
-
-
-
HDL – Mask Candidate email addresses
Post P2T, there is always a requirement to mask the candidate email addresses in lower environments. Below SQL can be used to generate data masked email data in HDL format: You can update the email address as per your requirement.
-
BIP – Query to extract assignment rules at course level in Oracle Learning Cloud
Use the below SQL to extract assignment rules defined at course level:
-
HDL – Sample HDL to delete schedule assignment data
Below HDL file can be used to DELETE the schedule assignment data in a Fusion environment: This data can be extracted from Fusion HCM using a simple BIP query:
-
HDL – Delete Person Email addresses
Use below SQL query to extract email addresses data in HDL format to DELETE the data: If you only want to update the email addresses not delete them, then use refer below post: HDL – Email Data Obfuscation in Test environment – Welcome to Fusion HCM Consulting
-
HDL – Delete Element Entries Data
Query to extract Element entry details data in HDL format:
-
OTBI – Areas of Responsibility Subject area
Oracle has released a new subject area for Areas of Responsibility. Subject Area Name – Workforce Management – Areas of Responsibility This has simplified the process of extracting AoR data using OTBI. To get any data in this subject area, you should run “Refresh Representative Data” ESS process. The process should be run post any…
-
BIP – Queries related to Bank, Bank Branches and External Bank accounts
Query for bank details: Query for bank branch details: Query to extract Internal bank accounts: select * from ce_bank_accounts Query to extract External bank accounts:
-
BIP – Query to extract absence reasons from Oracle HCM
Sometime for data migration, it is required to get a dump of all the absence reasons configured in Fusion HCM in order to validate the data being loaded. Below query can be used to extract the setup data for absence reasons:
-
-
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…