All posts on Fast Formula

Using Table based Valueset when DBI is unavailable

  • Post category:HCM Extract
  • Post comments:0 Comments
  • Post last modified:June 18, 2020
  • Reading time:10 mins read

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 ReadingUsing Table based Valueset when DBI is unavailable

Using Flow Schedule Fast Formula to Schedule Extracts

  • Post category:Fast Formula
  • Post comments:3 Comments
  • Post last modified:June 12, 2020
  • Reading time:5 mins read

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 ReadingUsing Flow Schedule Fast Formula to Schedule Extracts

SQL Query to get Fast Formula and related info

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 26, 2020
  • Reading time:5 mins read

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 ReadingSQL Query to get Fast Formula and related info

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