How HDL Transformation Formula works with ElementEntry Sample
Do you know the HDL Transformation Formula and how it works? What are the building blocks of it? Read on to know more details.
Do you know the HDL Transformation Formula and how it works? What are the building blocks of it? Read on to know more details.
Do you know the HDL Transformation Formula in Fusion HCM? What are the use cases of it? How to use it? FAQs on it? Read on to know more details.
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.
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…
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…
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…
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…