My Oracle Support Banner

Fusion Payroll: Fast Formulas Troubleshooting Guide (Doc ID 1560556.1)

Last updated on AUGUST 18, 2020

Applies to:

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

Purpose

This document is designed to provide answers to some of the most frequently asked questions regarding Fast Formulas within Oracle Fusion Applications.  

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
 What are Fast Formulas?
 What is the scope of the support of custom fast formulas?
 Which HCM products use fast formulas?
 What are the seeded fast formulas and how to determine seeded ones?
 Why are the seeded formulas failing after an install or applying a patch?
 Database Items related issues
 No DBIs are created for elements with input values of "Char"
 No DBIs are created for Cost Allocation Flexfield
 Generate Database Item process errors: 'A record with this combination of values already exists'
 Tips for resolving Fast Formulas performance issues
 Variable Names and Aliases
 Inputs Statements
 Database Items
 Balance Dimensions
 Formula Errors
 Types of Fast Formula compilation errors
 Error: “Local value used before initialized”
 Types of Fast Formula Execution Errors
 Error: Formula XYZ_HR_TO_PAY, line 45, database item or local variable HR_RELATIONSHIP_ID used as a context
 Error: Formula TD US SECOND SHIFT HOLIDAY_EARN, line 432, no data returned.(3=GET_TABLE_VALUE) 
 Error: ‘Context Payroll_Assignment_ID was not set’
 Error: 'Contexts HR_ASSIGNMENT_ID was not set' for Element Input Validation type Fast Formula
 Error: Context PAYROLL_TERM_ID was not set when used at line 65 of formula XYZ_CHG_DEDN_CALCULATOR
 Error: Array data value missing. (3=RUN_INCLUDED_PAYROLL_ASGS) (4=1)
 How does formula caching effect formula execution?
 Logging and Tracing Fast Formulas
References

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