Search Results pay_shadow_formula_rules




Overview
Explore in AI Chat

Overview

The PAY_SHADOW_FORMULA_RULES table is a core technical repository within the Oracle E-Business Suite Payroll module (PAY). It functions as the storage mechanism for result rules defined for shadow formulas associated with element templates. In the context of Oracle Payroll, a shadow element is a transient, run-time representation of an element created from a template. This table is pivotal for defining how the output of a shadow formula—which calculates values for these shadow elements—is mapped to specific input values and under what conditions those results are applied or excluded. Its existence is fundamental to the flexible and rule-based processing of recurring and non-recurring earnings and deductions generated from templates.

Key Information Stored

The table's primary purpose is to link shadow formulas, their target input values, and governing rules. The primary key, FORMULA_RESULT_RULE_ID, uniquely identifies each mapping rule. The most critical foreign key columns define these relationships. The SHADOW_ELEMENT_TYPE_ID links the rule to the specific shadow element type (PAY_SHADOW_ELEMENT_TYPES) for which the formula runs. The ELEMENT_TYPE_ID references the base element type from the template. The INPUT_VALUE_ID column specifies the exact input value (PAY_SHADOW_INPUT_VALUES) that will receive the formula's result. Finally, the EXCLUSION_RULE_ID column provides a link to conditional logic in the PAY_TEMPLATE_EXCLUSION_RULES table, determining if this particular result rule should be applied for a given payroll run or assignment.

Common Use Cases and Queries

This table is primarily accessed for diagnostic, audit, and support purposes to understand the behavior of element templates. A common scenario involves troubleshooting why a calculated value from a template is not populating as expected. A developer or functional consultant might query the rules to verify the mapping between a formula and its target input value. Sample SQL to analyze rules for a specific shadow element type would join key related tables:

  • SELECT psfr.*, pset.element_name shadow_element_name, psiv.name input_value_name FROM pay_shadow_formula_rules psfr JOIN pay_shadow_element_types pset ON psfr.shadow_element_type_id = pset.shadow_element_type_id JOIN pay_shadow_input_values psiv ON psfr.input_value_id = psiv.input_value_id WHERE pset.element_name = '&ELEMENT_NAME';

Reporting use cases include documenting all formula result rules for a set of templates or validating configurations during a migration or upgrade by comparing rule sets across environments.

Related Objects

As indicated by its foreign keys, PAY_SHADOW_FORMULA_RULES has direct, integral dependencies on several other payroll shadow objects. PAY_SHADOW_ELEMENT_TYPES is referenced twice: once for the shadow element itself and once for the source template element type. PAY_SHADOW_INPUT_VALUES holds the definition of the input values that receive formula results. PAY_TEMPLATE_EXCLUSION_RULES stores the conditional logic that can disable a rule. This table is part of a larger shadow object schema that includes PAY_SHADOW_FORMULAS and PAY_SHADOW_ELEMENT_ENTRIES, which together manage the complete runtime instantiation and processing of element templates within a payroll run.