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
All posts on Fast Formula
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
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
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