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:
- FORMULA_RESULT_RULE_ID — the surrogate primary key of the table, generated via PAY_SHADOW_FORMULA_RULES_PK. It uniquely identifies each result rule row.
- ELEMENT_TYPE_ID — foreign key to PAY_SHADOW_ELEMENT_TYPES identifying the element type (typically the shadow element) context for the rule.
- SHADOW_ELEMENT_TYPE_ID — a second foreign key to PAY_SHADOW_ELEMENT_TYPES, distinguishing the shadow element type associated with the rule.
- INPUT_VALUE_ID — foreign key to PAY_SHADOW_INPUT_VALUES indicating the input value that receives or relates to the formula result.
- EXCLUSION_RULE_ID — foreign key to PAY_TEMPLATE_EXCLUSION_RULES, linking the rule to template exclusion logic.
- RESULT_NAME — the name of the formula result being processed.
- RESULT_RULE_TYPE — defines the rule type applied to the result (for example, how the result is routed, defaulted, or treated).
- SEVERITY_LEVEL — controls the severity assigned when the rule condition is encountered, influencing error or warning behavior.
- ELEMENT_NAME — descriptive name of the element associated with the rule.
- OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Oracle EBS audit and concurrency columns.
- ZD_EDITION_NAME — the edition/partition discriminator, which participates with FORMULA_RESULT_RULE_ID in the unique index PAY_SHADOW_FORMULA_RULES_PK. This makes it the business-key candidate column alongside the surrogate key.
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.
-
Element Template Shadow Formula Result Rules
-
Element Template Shadow Formula Result Rules
-
PACKAGE: APPS.PAY_SFR_SHD 12.2.2
-
PACKAGE: APPS.PAY_SFR_DEL 12.2.2
-
PACKAGE: APPS.PAY_SFR_SHD 12.1.1
-
PACKAGE: APPS.PAY_SFR_DEL 12.1.1
-
PACKAGE: APPS.PAY_SFR_UPD 12.2.2
-
PACKAGE: APPS.PAY_SFR_UPD 12.1.1
-
PACKAGE: APPS.PAY_SFR_INS 12.1.1
-
PACKAGE: APPS.PAY_SFR_INS 12.2.2