-
-
-
-
-
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:
-
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 – How to check Termination version on your environment?
You can use per_empl_configurations table to verify the versions of Seniority dates/ Termination dates. Below is an example to check the version for Termination dates: If the version code value is NULL that means you are still on version V2. Same table can be used to query Seniority Dates version.
-
HDL – Assignment Working Hour Pattern
Oracle has provided a new feature where working hours for each day can be stored against assignment working hours. The data is stored in PER_WORKING_HOUR_PATTERNS_F table. Use below query to extract the data: Query to extract data in HDL format:
-
Purge Worker/Person Records from Test Environment
Oracle provides a process Purge Person Data in Test Environments to remove Person/Contact/Worker records from a test environment of Oracle HCM. Please note that HDL for core worker object doesn’t support DELETE, so there is no other option to purge the Person/Contact/Worker information from Oracle HCM once a record is created. In this case, Purge…
-
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 Disability Org Details
Use below query to extract disability org details from Fusion HCM:
-
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:
-
Configuration – Value Set to show numbers from 1 to 60
There is a common requirement to use value sets in various DFF attributes across Fusion HCM application. Oracle HCM supports different kind of value sets – Independent, Table validated etc. There is a use case where a user wants to see a list of values containing numbers from 1 to n. There are two approaches…
-
HDL – Source values for Candidate HDL
When loading Candidate data using HDL, the values of Source attributes (Source and Source Medium) are required. These values are configured in UI using task ‘Manage Candidate Dimension Source Names’. Use below SQL to get the values:
-