-
-
-
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.
-
HDL – Sample HDL file to upload DoR for a specific country
Please note that under attribute country, you will need to pass the full country name. Passing country code like GB, will throw below error: The values GB aren’t valid for the attribute LegislationCode.
-
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: