My Oracle Support Banner

Fusion HCM: Fast Formula Frequently Asked Questions (FAQ) (Doc ID 1579739.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Fusion Global Payroll - Version 11.1.5.0.0 and later
Oracle Fusion Benefits - Version 11.1.5.0.0 and later
Oracle Fusion Compensation - Version 11.1.10.0.0 and later
Oracle Fusion Absence Management - Version 11.1.10.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Purpose

 The purpose of this document is to answer frequently asked questions regarding Oracle Fusion Fast Formula (FF).

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 How Fast Formulas are used?
 Where can I get documentation on Fast Formula?
 Which tables hold information on fast formulas?
 Where can I find formula examples?
 Security: What roles allow to access Fast Formulas
 Variables
 Formula Contexts
 How to get the list of contexts for each formula type?
 Inputs and Outputs
 Database Items (DBIs)
 Where can I get a list of DBIs for all HCM products in various releases?
 How to Find the Formula Type where you can use the particular DBI and the CONTEXT which is required by the particular DBI
 What are some frequently used DBIs?
 How do I view Fast Formula database items, globals and functions?
 How do I see a database item for a changed element, element input or balance, if it does not display?
 Alias statements
 Defaults
 Global Values
 Variable Types
 Formula structure
 Additional functionality specific to Fusion: Arrays and Array Variables
 Formula Statements
 Statement: CHANGE_CONTEXTS
 Statement: DEFAULT_DATA_VALUE
 Statement: Formula Calling
 Statement: WHILE … LOOP / EXIT
 What kind of functions are supported in Fusion Fast Formulas?
 Text  Functions
 Numeric Formula Functions
 Date Formula Functions
 Data Conversion Formula Functions
 Miscellaneous Formula Functions
 GET_TABLE_VALUE
 How to create Fast Formula functions?
 Why can’t I use a formula function or database item with my formula?
 What is User Defined Table (UDT) and how to query its values?
 How to determine if the Fast Formula is compiled?
 When and how shall the Compile Formula process be run?
 How to migrate Fast Formulas between environments
 How to migrate Fast Formulas which have more than 4000 characters
 How to get a log from Fast Formula?
 How to create a custom message for Fast Formula?
 How to find out the element entry start date and element entry end date from a fast formula which is for a different element?
 Why special characters are not allowed in element name?
 Why element name can be only 50 characters?
 Sample Formula: Element Input Value Validation
 Design suggestions, troubleshooting tips and improving performance
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.