My Oracle Support Banner

Fusion Global Payroll: Elements and Fast Formulas Frequently Asked Questions (FAQ) (Doc ID 1420170.1)

Last updated on JULY 02, 2019

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Global Payroll - 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 Elements and 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
 Fast Formulas
 1) Why are the seeded formulas failing after an install or applying a patch?
 2) How do I view Fast Formula database items, globals and functions?
 3) How can I get details of errors encountered whilst either compiling or executing formulas?
 4) How do you create Fast Formula functions?
 5) How do you compile multiple formulas?
 6) How do I see a database item for a changed element, element input or balance, if it does not display?
 7) Why can’t I use a formula function or database item with my formula?
 8)  Why can’t I call this formula?
 Appendix 1 – Creating a Formula Function (Not applicable in Cloud environment)
 Step 1 - Create private synonyms for the referenced FUSION tables in the CUSTOM schema
 Step 2 - Grant SELECT privilege on these FUSION tables to the CUSTOM user
 Step 3 - Create the custom PLSQL package in the CUSTOM schema
 Step 4 - create a private synonym for the custom package in the FUSION_DYNAMIC schema
 Step 5 - grant execute privilege on zz_cmp_pfg_functions to FUSION_DYNAMIC
 Step 6 - add the function definition to the FF tables
 Payroll Element Template and Element Entries
 1) Why can’t I create an element at Payroll Relationship level?
 2) What happens if the Closed for Entry option is selected on an element?
 3) How can I create an element for retroactive processing?
 4)  How can I define Multiple Rules of Element Eligibility?
 5) How will calculation rule Unit X Rate for element work, while running the Payroll?
 6) What aspects of element eligibility rules can I change after starting to use an element?
 7) What happens if I override an element entry that has a runtime default set at the element's definition?
 8) Why can’t I update or end date an Element Entry?
 9) How to update the Input Value on an existing Element?
 10) Why can’t I update or end date entries on a desired date?
 11) Why can’t I delete an element entry?
 12) Why can’t I select the element from an element list of values on the Element Entries page?
 12) Why can’t I create entries for all elements on Element Entries page?
 13) Are there any naming convention guidelines when creating elements?
 14) SQLs to identify element eligibility and employee element entries for an element

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