Search Results exclusion_rule_id

Overview

The HR.PAY_TEMPLATE_EXCLUSION_RULES table is a core data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Payroll module. It functions as the master control point for defining exclusions within an Element Template. An Element Template is a configuration object used to rapidly create and maintain payroll elements, and this table governs which specific components are omitted from a template's application. The exclusions managed by this table are comprehensive, allowing administrators to exclude formula result rules, element input values, balance feeds, balance types, or entire elements. When a high-level object like a balance type or element is excluded, the exclusion cascades to all its dependent components within the same template, ensuring configuration integrity and preventing unintended data propagation.

Key Information Stored

While the provided ETRM excerpt does not list all columns, the primary and foreign keys define its critical relationships. The EXCLUSION_RULE_ID column is the table's primary key, uniquely identifying each exclusion rule. The TEMPLATE_ID column is a foreign key that links the exclusion rule to its parent Element Template in the PAY_ELEMENT_TEMPLATES table. This establishes the fundamental relationship: an exclusion rule belongs to one specific template. The table's purpose, as documented, is to store the metadata that defines what is excluded—whether it be a formula rule, input value, balance feed, balance type, or element. The specific target of the exclusion is logically determined by its relationship to various "shadow" tables that reference the EXCLUSION_RULE_ID.

Common Use Cases and Queries

This table is central to the Element Template maintenance process. A common use case is auditing the exclusions applied to a template before it is used to create or update payroll elements, ensuring the final element configuration is correct. Troubleshooting unexpected missing components in a generated element often involves querying this table. For reporting, one might join to PAY_ELEMENT_TEMPLATES to list all exclusions by template name. A fundamental query to identify all exclusion rules for a specific template would be:

• SELECT exclusion_rule_id FROM hr.pay_template_exclusion_rules WHERE template_id = <template_id_value>;

To understand the full impact, this is typically joined to the relevant shadow tables (e.g., PAY_SHADOW_ELEMENT_TYPES) via the EXCLUSION_RULE_ID to see the specific objects being excluded.

Related Objects

The PAY_TEMPLATE_EXCLUSION_RULES table has a tightly integrated relationship with numerous shadow tables, as defined by the foreign key constraints. It references the PAY_ELEMENT_TEMPLATES table via the TEMPLATE_ID column. Crucially, its primary key (EXCLUSION_RULE_ID) is referenced by a wide array of tables that store the details of the excluded objects, including:

• PAY_SHADOW_BALANCE_CLASSI (Balance Classifications)
• PAY_SHADOW_BALANCE_FEEDS
• PAY_SHADOW_BALANCE_TYPES
• PAY_SHADOW_BAL_ATTRIBUTES (Balance Attributes)
• PAY_SHADOW_DEFINED_BALANCES
• PAY_SHADOW_ELEMENT_TYPES
• PAY_SHADOW_ELE_TYPE_USAGES
• PAY_SHADOW_FORMULA_RULES
• PAY_SHADOW_INPUT_VALUES
• PAY_SHADOW_ITERATIVE_RULES
• PAY_SHADOW_SUB_CLASSI_RULES (Sub-classification Rules)
• PAY_SHADOW_GU_BAL_EXCLUSIONS (Global User Balance Exclusions)
• PAY_TEMPLATE_FF_USAGES (FastFormula Usages)

This extensive network of foreign keys confirms the table's role as the central hub for managing exclusions across all configurable aspects of a payroll element within a template.