Fusion Payroll: Fast Formulas Troubleshooting Guide
(Doc ID 1560556.1)
Last updated on JANUARY 03, 2024
Applies to:
Oracle Fusion Global Payroll - Version 11.1.1.5.1 and laterOracle 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 |