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:
-
-
-
-
-
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: