BIP – Extract Job Details
Once Jobs data is loaded/created, you can use below SQL to extract the setup data for Jobs:
-
-
BIP – Extract Checklist configuration details
Below query can be used to extract checklist configuration details:
-
-
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…
-
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 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:
-
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:
-
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: