SQL Query to get Supervisor Change HDL for Assignment
Do you know how to create the supervisor update HDL file using SQL Query? Within a few minutes you will be able to update supervisor for a bunch of employees. Read on to know more details.
All posts on Sample SQL Queries
SQL Query to get User last login information
Most of the customers want to know the list of users who logged in to Fusion Applications and want to encourage other employees too to use the Fusion system. For this, the customer needs to generate a report with the list of users who have logged in within a period of time like last 30days or on specific date or…
SQL Query to get the HDL file from staging tables
Normally when we load the data using HCM Data Loader aka HDL, the File Delete Option would be defaulted to 'Y' and the input zip file would be deleted post processing of that file. However out of my enthusiasm, I searched for options to get that HDL file from staging tables and finally figured out a way to get it…
Basics of Valuesets in Fusion HCM
Do you know about valuesets, types of valuesets and their usage in fusion? Have a look at this article to know about valuesets.
SQL Query to fetch Flattened Organization Hierarchy Tree
If you have a requirement to fetch the flattened organization hierarchy tree you can use the SQL in this article to get the information.
Table Naming Convention in Fusion Applications
We have many tables in Fusion and we need to understand their naming conventions in order to find out the right table that we need to refer to. _B these are the BASE tables. They are very important and the data is stored in the table with all validations.Ex:HR_DOCUMENT_TYPES_B _F these are date tracked tables, which occur in HR and Payroll. For these…
Using Session Variables in BI Reports to get logged in user info
Session variables are used frequently in BI Publisher when the reports are being exposed to employees to add data security on top of the existing query. We need to write query to pull only the logged in user information and for this we will use the session variable. Apart from this user, there are many other session variables and we…
Execute Reports from Navigator without exposing the BI Catalog
In most of the cases, Employees will not have access to Reports and Analytics to access the reports. However if there is a requirement to create a report and provide access to employees, giving access to Reports and Analytics might expose other reports or seeded reports too, hence it is not a wise decision to provide access to BI Catalog.We…
SQL to fetch 200+ rows – Direct Database Query – Obsolete
This article is obsolete now as Oracle removed Direct Database Query option. Please check out the alternative to run adhoc queries. https://fusionhcmknowledgebase.com/2020/09/sql-developer-like-tool-for-oracle-cloud-for-free/ When we create a Data Model using SQL Query, the max number of rows that we can fetch using the Data Model is only 200 rows unless we create a layout, tag it to data model and run…
Security Matrix Users and their Roles
For every implementation, there would be functional consultant who looks into the security and their job is to create a security matrix with all users list and their roles mapped on to a sheet. It would be tough to create this sheet manually when there are 1000's of employees and it doesn't make any sense to do it manually.In order…