All posts on Fast Formula

PBL to HDL Migration without custom HDL Fast Formula

  • Post published:July 30, 2020
  • Post category:Fast Formula
  • Post comments:0 Comments
  • Post last modified:July 30, 2020
PBL to HDL Migration without custom HDL Fast Formula
PBL to HDL Migration without custom HDL Fast Formula

Do you know that you can use the PBL formulas post 20D as well when the PBL will be decomissioned? You don't need to re-write HDL Fast Formulas. Read on to know more details.

Continue Reading PBL to HDL Migration without custom HDL Fast Formula

Bulk Compile Fast Formulas in Fusion

  • Post published:May 12, 2020
  • Post category:Fast Formula
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
Bulk Compile Fast Formulas in Fusion
Bulk Compile Fast Formulas in Fusion

How to Bulk Compile Fast formulas using a process in Fusion HCM. What are the inputs that needs to be passed to the process? Read on to know more details.

Continue Reading Bulk Compile Fast Formulas in Fusion

Using Table based Valueset when DBI is unavailable

  • Post published:April 21, 2020
  • Post category:HCM Extract
  • Post comments:0 Comments
  • Post last modified:June 18, 2020
Using Table based Valueset when DBI is unavailable
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…

Continue Reading Using Table based Valueset when DBI is unavailable

Using Flow Schedule Fast Formula to Schedule Extracts

  • Post published:April 16, 2020
  • Post category:Fast Formula
  • Post comments:3 Comments
  • Post last modified:June 12, 2020
Using Flow Schedule Fast Formula to Schedule Extracts
Using Flow Schedule Fast Formula to Schedule Extracts

In this article we will look into how to schedule the HCM Extracts at ad-hoc schedules or complex schedules which cannot be handled using a simple way. In our previous article we saw how to Schedule/Cancel Schedule for HCM Extracts. Click here if you have missed to look at it.The previous article covers scheduling Extract at Once/Daily/Weekly/Monthly frequency only. However if we…

Continue Reading Using Flow Schedule Fast Formula to Schedule Extracts

SQL Query to get Fast Formula and related info

  • Post published:March 4, 2019
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 26, 2020
SQL Query to get Fast Formula and related info
SQL Query to get Fast Formula and related info

Below are the SQL's to extract Fast Formula related data from underlying tables:Fast Formula Functions and their underlying Packages: SELECT f.BASE_FUNCTION_NAME ,f.description ,f.DEFINITION || '(' || listagg(fp.name || ' ' || decode(fp.class, 'I', 'IN', 'O', 'OUT') || ' ' || decode(fp.data_type, 'N', 'NUMBER', 'T', 'VARCHAR2', 'D', 'DATE'), ',') WITHIN GROUP (ORDER BY fp.sequence_number) || ') RETURN ' || decode(f.data_type,'N','NUMBER','T','VARCHAR2','D','DATE') AS…

Continue Reading SQL Query to get Fast Formula and related info

Generate flexfield database items

Generate flexfield database items
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