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:
-
BIP – Query to find Primary flags for a Worker
There are multiple primary flags for a worker in assignment table. Namely – Primary Assignment Flag, Primary Work Terms flag and Primary flag. Below query can be used to check these flags:
-
-
-
-
-
BIP – Check bypass Approval Rules status
While performing SIT/UAT, sometimes it becomes mandatory to disable (bypass) all configured approval rules except for a few. One has to go in manually in Transaction console and check the status for each task. An easy way to run the following SQL query and check the tasks for which approvals are yet not Bypassed:
-
-
HDL – Loading Local Person Names
By default, PersonName child object of Worker.dat loads GLOBAL name type. PersonName object can be used to load local name as well. Two most important attributes of PersonName object for local name upload are: Name Type – Legislation Code CharSetContext – Short code for language. Below is a sample HDL file to upload local names…
-
Approvals – Approval Delegation Category Diagnostic
Approval delegation category can be defined at an individual level in BPM. This enables users to group tasks together which can be used while performing delegation. For any issues related to custom delegation categories, you can run “Transaction Framework – Export Task Categories diagnostic” by navigating: From homepage -> User name icon -> run diagnostic…
-
HDL – Load Worker Images
HCM Data Loader can be used to mass upload worker images. The actual image file should be put in a BlobFiles folder and should be referenced in actual Worker.dat file. Post this, Worker.dat will be zipped together with BlobFiles folder and uploaded into HCM using Import and Load.
-
Configuration – Extract Table based value set information
Use below query to extract table based value set information from backend tables:
-
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: