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.
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…
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.
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…
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:
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…
You can pass multiple comma separated values in an HCM Extract parameter and then use below logic to separate the comma separated values into multiple values:
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:
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…
Criticality at position model profile can be loaded using TalentProfile.dat file. Use the below HDL file: ItemText3015 – “Requires Succession Plan” radio box on UI Screen shot from UI of uploaded data: Useful queries: Uploaded data will be stored in HRT_PROFILE_ITEMS. Content Type – select * from HRT_CONTENT_TYPES_TLwhere content_type_id=127 Section ID –
Use below sample HDL file to create talent pool and add members to it:
Sample HDL for succession plan bulk upload:
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…
Person External Identifier information can be deleted easily using HDL. Under Worker use ExternalIdentifier to delete this data. Run the below query to extract required data in HDL format: Sample HDL File:
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
In case, you need to delete assigned payroll data for masking purpose in lower environment or for some other reason like correction etc, use below query to pull the data in HDL format: Sample HDL File:
