-
-
BIP – HDL to update Grade Rate values
SQL to extract data in HDL Format: Sample HDL:
-
-
BIP – Extract Absence Entry data in HDL Format
The below query extracts the minimum required attributes for absence entry update. In the current example, the absence status is updated to Withdrawn. You can make the changes as per your need: Sample HDL File:
-
BIP – Extract Length of service
Use the below query to extract the length of service of a worker. In case of rehires this becomes little tricky. Below query makes use of earliest hire date for length of service calculation. If Seniority dates are implemented, then you can avoid using below query:
-
BIP – Query to extract department Tree
Use the following query to extract department tree and its child departments. Please pass correct department name before executing:
-
-
HDL – Sample file to delete element eligibility
HDL supports deletion of element eligibilities. You can make use of PayrollElementDefinition business object. Child object ElementEligibility supports create, update and delete operations. You can create a simple BIP query to extract the requisite data and create an HDL file out of it: Sample HDL file: Sometime you may get an error that You can’t delete…
-
-
-
BIP – Query to extract data from Pay Inbound Records
Third party payslip data can be loaded into Payroll Inbound Records in Fusion HCM. Use below query to extract the data:
-
-
BIP – Providing Link of BIP report on Self Service
There is one common requirement where Employees should access reports directly from self-service instead of navigating to analytics. In such cases, a report link can be created and added as a static link on Navigator. This will enable the employee to access report directly. The report can be then viewed in different views using different…
-
BIP – My Public Info Extract
Each person can publish public info in HCM Cloud by navigating to Me -> Quick Actions -> Public Info. There are various sections under Public Info like Public Message, Contact Info, About Me etc. You can use the below SQL queries to extract the data for relevant sections. Public Message: SQL Query: About Me: SQL…
-
BIP – Query to Extract Position FTE values
When position hierarchy is enabled in Cloud HCM, Manage Positions UI shows some dynamically populated fields along with Parent position. For example: Use the below query to extract above details:
-
BIP – Query to get Default Assignment Rules of the Course
Default Assignment Rules like Validity Period, Expiration, Renewal Options, Renewal Period etc are maintained at the course level in Oracle Learning Cloud. These details are stored in the backend table ‘WLF_ASSIGNMENT_RULES’. The query from below post can be joined with WLF_ASSIGNMENT_RULES using ASSIGNMENT_RULE_ID column: https://fusionhcmconsulting.com/2021/03/reports-bip-query-to-get-assignee-details-for-a-course/?amp and warf.ASSIGNMENT_RULE_ID = war.ASSIGNMENT_RULE_ID And you will get the required output.
-
-
Reports (BIP) – Query to extract Manage Person Name Styles
Manage Person Name Styles is a task that can be used to configure additional Name attributes for a country if required. Also, a name component can be made required as per requirement. In multi country implementations, it is required to know the setup for technical developers as it is hard to check the setup for…
-
Reports – Query to get business Unit details
Use below query to get business unit details:
-
Reports (BIP) – Query to extract Worker disability details
Below query can be used to extract disability details of a worker: