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 ReadingConfiguring 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 ReadingAccessing 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 ReadingGenerate flexfield database items

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…

Continue ReadingSQL Query to get User last login information

SQL Query to get the HDL file from staging tables

  • Post category:BI Publisher
  • Post comments:1 Comment
  • Post last modified:June 12, 2020
  • Reading time:3 mins read

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 ReadingSQL Query to get the HDL file from staging tables