Fast Formula Tables in Fusion HCM

Fast Formula Tables in Fusion HCM

Hi friends, we are going to discuss about Fast Formula Tables in Fusion HCM. We will share the detail steps to configure the fast formula in oracle fusion HCM. In HCM , oracle has given the fast formula options to drive the calculations as per the business requirements. Fast formula provides soo much flexibility in Oracle Fusion payroll. Fast Formulas are provide more business centric solutions in oracle HCM. Oracle Fast Formula is a tool to write formulas using English words and basic mathematical functions. We can write generic expressions for any calculation or comparison you may want to repeat. In this post , we will be discuss about the backend tables which helps to store the information's about the fast formula in oracle fusion HCM. We will try to share some of the most important fast formula tables which you can refer to extract the details about fast formula in HCM.

Fast Formula Tables in Fusion HCM

11 Most Important Fast Formula Tables in Fusion HCM

Here below is the list of some important fast formula tables which helps to store the information's about the Fast Formula in HCM.

1.FF_FUNCTION_PARAMETERS

2.FF_FUNCTIONS_VL

3.FF_FORMULA_TYPES_TL

4.FF_FORMULAS_VL

5.FF_DATABASE_ITEMS_VL

6.FF_DBI_USAGES

7.FF_DBI_GROUPS_VL

8.FF_USER_ENTITIES_VL

9.FF_ROUTES_VL

10.FF_CONTEXTS_VL

11.FF_ROUTE_PARAMETERS

SQL Query to extract the Fast Formula Details in Oracle Fusion HCM

Select formula_name ,formula_text from ff_formulas_f where formula_name like '%PRORA%'

select FORMULA_TEXT from FF_FORMULAS_F WHERE FORMULA_NAME = <> and TRUNC(SYSDATE) between effective_start_date and effective_end_date

FF_FORMULAS_B_F and FF_FORMULAS_TL are actual tables for formula. FF_FORMULAS_F and FF_FORMULAS_VL are database views. These two views query data from FF_FORMULAS_B_F and FF_FORMULAS_TL tables only. If you looking to query formulas having certain text, you can query in following way

select

a2."FORMULA_NAME" as "NAME OF FORMULA",

a2."DESCRIPTION" as "FORMULA DESCRIPTION",

a2."EDIT_STATUS" as "FORMULA STATUS",

 TO_CHAR(a2."EFFECTIVE_START_DATE",'DD-MON-YYYY') as "FORMULA START_DATE",

TO_CHAR(a2."EFFECTIVE_END_DATE",'DD-MON-YYYY') as "FORMULA END_DATE",

a2."FORMULA_TEXT" as "FORMULA_TEXT",

a2."COMPILE_FLAG" as "COMPILE_FLAG",

a2."LEGISLATION_CODE" as "LEGISLATION_CODE",

TO_CHAR(a2."LAST_UPDATE_DATE",'DD-MON-YYYY') as "LAST_UPDATE_DATE",

a2."LAST_UPDATED_BY" as "LAST_UPDATED_BY",

a2."CREATED_BY" as "CREATED_BY"

from "FUSION"."FF_FORMULA_TYPES_TL" a1,

"FUSION"."FF_FORMULAS_VL" a2

where a2."FORMULA_TYPE_ID"=a2."FORMULA_TYPE_ID"

select formula_name from FF_FORMULAS_VL

where formula_text like '%GET_VALUE_SET%';

Fast Formula Tables in Fusion HCM

Fast Formula Tables in Fusion HCM