Display Person Image on BI Report
Do you know how to display Employee's image on the BI Report? Images are stored as BLOB files, then how can we display them? Read on to knore more details.
All posts on Sample SQL Queries
Introduction to User Defined Table (UDT) in Fusion HCM
Do you know User-Defined Table (UDT) in Fusion? What's the usage of them and how do you load data into them and how do you migrate them? Read on to know more details
Using Aggregate functions in Table based Valueset
Do you know that there is a workaround to achieve the aggregate functions in Table based Valueset? Read on to know more details
Resolving Assignment Name and Job Name not in sync issue
Do you know how to fix the Job Name and Assignment Name are not in sync issue on Employment page? What could be the reasons for this corruption of data and how to correct it? Read on to know more details
SQL Query to fetch employee person and assignment info
Do you know what all tables are involved in creating an employee master report with personal and assignment data? Read on to know more details
SQL Query to fetch Supervisor Direct and Indirect reportees
In this article we will look into getting in the Direct and Indirect reportees of a Supervisor using SQL Query. We assign the Supervisor on the Employment screen and they get stored in the PER_ASSIGNMENT_SUPERVISORS_F table. We will have to join the PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M and PER_ASSIGNMENT_SUPERVISORS_F tables to get the manager information of an employee. However Fusion has a scheduled…
Using Role Mappings and Auto-provisioning Rules
Do you know what are Role Mappings, How they are configured and how the auto provisioning process works? have a look at this article to find out.
SQL Query to get Source System IDs for all Business Objects
In one of our previous articles, we have seen how to configure Source System Owner in Fusion.Defining Source System Owner for HDL in Fusion Source System Owner and Source System ID are the Source Keys which we use to load/update data using HCM Data Loader (HDL). HRC_INTEGRATION_KEY_MAP is the underlying base table which stores the Source Keys for all business…
Using Table based Valueset when DBI is unavailable
When we develop integrations using HCM Extracts, we normally come across many scenarios where in we are unable to get all the attributes required using the Database Items (DBIs) for the integration using a single/multiple User Entities (UEs). If you are new to HCM Extracts, I would suggest you to read through the below articles on HCM Extracts Basics of…
How to get Position Hierarchy in SQL Query?
We can use the below query to get the Position Hierarchy of a Position traversing up to the top level. SQL Query: SELECT hap.POSITION_CODE ,hap.position_id ,hap.name ,(SELECT name FROM HR_ALL_POSITIONS WHERE POSITION_ID = pphf.PARENT_POSITION_ID ) Parent_Position_NAME ,decode(hap.ACTIVE_STATUS, 'A', 'Active', 'I', 'Inactive') ACTIVE_Status ,pj.manager_level ,pj.name FROM HR_ALL_POSITIONS hap ,PER_JOBS_F_VL PJ ,PER_POSITION_HIERARCHY_F pphf WHERE hap.POSITION_ID = pphf.POSITION_ID AND hap.job_id = pj.job_id AND…