All posts on Fast Formula

Using Table based Valueset when DBI is unavailable

  • Post published:April 21, 2020
  • Post Category:HCM Extract
  • Post Comments:0 Comments
  • Post last modified:May 15, 2020

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:0 Comments
  • Post last modified:May 15, 2020

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:May 13, 2020

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

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