Configuring HCM Data Loader Parameters

One of the first step to use HCM Data Loader is to Configure the HDL Parameters. In this article we will discuss available options and evaluate pros and cons for each. Want to learn Fusion Technical tools? Checkout this article Where to Configure the HCM Data Loader Parameters? Navigate to Setup and Maintenance and Search for "Configure HCM Data Loader" and open…

Continue Reading Configuring HCM Data Loader Parameters

Accessing flexfields in OTBI Analytics

When we configure the flex fields we check the BI Enabled flag for the flex field to be used in OTBI analysis. Setting Extensible Flexfields as BI-Enabled: Procedure Extensible flexfields are BI enabled if at least one segment in a context is BI enabled. Setting Extensible Flexfields as BI-Enabled To set extensible flexfields as BI-enabled: Navigate to Setup and Maintenance.Navigate to Manage…

Continue Reading Accessing flexfields in OTBI Analytics

Generate flexfield database items

After creating the Flex fields (DFF/EFF/KFF) and deploying them, if we need to use these as Database Items (DBIs) in Fast Formula or HCM Extracts then we need to run the process "Generate Flexfield Database Items" which creates the DBIs for the flexfields. Steps to Run the Process: Navigate to Navigator > Payroll > Checklist From the Right hand side…

Continue Reading Generate flexfield database items

SQL Query to get User last login information

  • Post published:January 29, 2019
  • Post Category:BI Publisher
  • Post Comments:6 Comments
  • Post last modified:May 12, 2020

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…

Continue Reading SQL Query to get User last login information

SQL Query to get the HDL file from staging tables

  • Post published:January 29, 2019
  • Post Category:BI Publisher
  • Post Comments:0 Comments
  • Post last modified:May 4, 2020

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…

Continue Reading SQL Query to get the HDL file from staging tables

Basics of HCM Data Loader in Fusion

In this article we will go through the basics of HCM Data Loader aka HDL which is one of the most familiar data loading tools in Fusion HCM. Here is the Agenda for this post: What is HCM Data Loader?Configure HCM Data Loader ParametersWho Can Load Data Using HCM Data Loader?Navigation of HDL in Fusion ApplicationsReviewing Supported Business ObjectsUnderstanding the…

Continue Reading Basics of HCM Data Loader in Fusion