Configuration | HDL | Reports
BIP – Extract Document Record File Link from Content Server
Below query can be used to extract the document record from content server.
-
-
BIP – Suppress special characters
Oracle HCM allows special characters to be used in fields like Person Names/ Department Names/ Jobs etc. But in reporting, there may be a requirement to change the special characters (like ý, ě, ž, ů etc) to normal English characters. CONVERT function can be used for such requirements. Output:
-
Configuration – Hiding Print Me under Settings and Actions
Settings and Actions under user name provides a lot of options. Sometimes, the users request to remove unwanted options from this list: These options can be removed from this list by activating a sandbox and adding tool – “Page Template Composer”: Once you activate the Sandbox, click on Edit Global Page Template option under “Settings…
-
HDL – Sample file to create Pending Worker Record
Below is a sample file to create Pending Worker record using HDL: ReadyToConvert Flag on Work relationship is used to convert the Pending worker record to Employee record. If this flag is set to Y, it will appear in NewPerson Dashboard with Automatic conversion marked as Yes. Run Convert Pending Workers Automatically Process will pick the…
-
REST API Error – The specified operation is not supported for the invoked HTTP method
Many a times while trying to use Post method using REST API, we encounter – ” The specified operation is not supported for the invoked HTTP method. Please check the URL and the headers.” Cause of this error is incorrect header parameters/ missing header parameters while making a call to REST API. To fix the issue:…
-
HDL – Sample HDL file to create Role Provisioning Rules
The rules can be verified from UI, once the HDL load is successful:
-
Configuration – Pull configured actions/action reasons
Below query can be used to pull actions and configured actions for these reasons along with action type:
-
-
Fusion Diagnostics – Important MOS notes related to diagnostics
Below are some important my oracle support notes related to diagnostic framework: Self-Service Data Integrity Framework for Employment Flows – Part 2 (Doc ID 2597759.1)Self-Service Data Integrity Framework for Employment Flows – Part 1 (Doc ID 2548287.1)Self-Service Data Integrity Framework for Person Flows (Doc ID 2548789.1)Self-Service Data Integrity Framework for Workforce Structure Flows (Doc ID…
-
HDL – Loading Delivery Preferences for a Worker
PersonDeliveryMethod child business object of Worker can be used to upload delivery preferences for a worker. Below is sample HDL file:
-
-
Environment – Error Accessing HCM Environment
Sometimes accessing an HCM environment causes in “Max HTTP Headers, Blocked by WAF” error as shown below: Resolution: This issue occurs due to browser cache issue. Clearing the cache or trying to access the environment in incognito mode or another browser should resolve the issue.
-
BIP – Extract Job Details
Once Jobs data is loaded/created, you can use below SQL to extract the setup data for Jobs:
-
Configuration – Update Legal Entity Name
There are requirements when the existing legal entity name should be updated to a new name. One should note that the LE name in UI is displayed for a view – HR_ALL_ORGANIZATION_UNITS_F_VL. Sometimes, even after updating the name in UI, correct name is not reflected on some pages like Manage Employment or Manage Legal Entity…
-
BIP – Extract Checklist configuration details
Below query can be used to extract checklist configuration details:
-
HDL – Sample file to load Life events
HDL provides an option to upload Potential life events for a person in benefits. Please note that ‘Open Enrolment’ life event can’t be loaded using the potential life events file. Provide the data in below format and save it as PotentialLifeEvents.dat
-
-
Diagnostics – Run Diagnostics is missing
With latest HCM release in 2022, “Run Diagnostics” option was removed from user profile. A new role is now required in order to give access to this function. Role Name – Application Diagnostics Advanced User Role Code – ORA_FND_DIAG_ADVANCED_USER_JOB
-
HDL – Inactivate secondary Org classification
Oracle HCM allows an Organization to be classified as multiple Orgs. However, sometime there is a need to inactivate one org classification while keeping the primary classification as Active. Below is a sample HDL file which can be used for this purpose:
-
BIP – Query to find list of jobs without job profiles
There is no easy way in OTBI to find list of jobs which don’t have a model profile associated with them. This can be achieved easily using BIP query. Sample Query: