Results for “pay_shadow_formula_rules”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PAY_SHADOW_FORMULA_RULES table is a core configuration object within the Oracle EBS Payroll (PAY) module, owned by the HR schema. It stores the result rules that govern how shadow formulas attached to element templates resolve their outputs during payroll processing. Shadow elements are the hidden, system-generated counterparts of user-defined elements, and their formulas produce intermediate results that feed input values on the actual element. This table defines the mapping between those computed formula results and the input values, exclusion rules, and severity behaviors they drive.

In the context of ETRM and enterprise data modeling, the heuristic Data Vault classification for this object is a link. This classification reflects its position as an associative entity that joins shadow element types, input values, and template exclusion rules. Analysts designing vault models should treat PAY_SHADOW_FORMULA_RULES as a relationship/link table rather than a pure hub, since its business identity emerges from the combination of referenced entities.

Key Information Stored

The table contains 16 documented columns in the 12.2.2 physical schema. The most significant attributes are:

Common Use Cases and Queries

Consultants and developers query this table when diagnosing why a shadow element formula result is not populating an expected input value, when auditing template exclusion behavior, or when migrating element template configurations between environments. A typical diagnostic query joins the table to its parent shadow element type and input value tables to reconstruct the full rule context:

  • Identify all rules for a given shadow element type: SELECT * FROM pay_shadow_formula_rules WHERE shadow_element_type_id = :id;
  • Trace result rules back to their input values: SELECT r.formula_result_rule_id, r.result_name, r.result_rule_type, i.input_value_id FROM pay_shadow_formula_rules r JOIN pay_shadow_input_values i ON r.input_value_id = i.input_value_id WHERE r.element_type_id = :type_id;
  • Find rules linked to exclusion behavior: SELECT * FROM pay_shadow_formula_rules WHERE exclusion_rule_id IS NOT NULL;
  • Audit changes over time using LAST_UPDATE_DATE and LAST_UPDATED_BY for compliance reporting.

Because the object is configuration rather than transactional data, reporting typically centers on setup validation, migration reconciliation, and root-cause analysis of payroll calculation discrepancies.

Related Objects

The most significant related objects, drawn from the documented foreign key and reference metadata, are:

  • PAY_SHADOW_ELEMENT_TYPES — referenced twice, via SHADOW_ELEMENT_TYPE_ID and ELEMENT_TYPE_ID; the primary parent defining shadow element context.
  • PAY_SHADOW_INPUT_VALUES — joined via INPUT_VALUE_ID; supplies the input value targets for formula results.
  • PAY_TEMPLATE_EXCLUSION_RULES — joined via EXCLUSION_RULE_ID; provides template exclusion logic tied to result rules.
  • HR_S_FORMULA_RESULT_RULES_F — a form/UI layer table that references this object via FORMULA_RESULT_RULE_ID, indicating the maintenance interface used by administrators.
  • PAY_SHADOW_FORMULA_RULES_PK — the unique index enforcing identity on FORMULA_RESULT_RULE_ID and ZD_EDITION_NAME.

Together these relationships position PAY_SHADOW_FORMULA_RULES as a connective configuration table at the intersection of shadow element definitions, input values, and template exclusion rules.