Search Results pay_shadow_defined_balances




Overview
Explore in AI Chat

Overview

The PAY_SHADOW_DEFINED_BALANCES table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It functions as a staging or shadow repository for defined balance configurations that are associated with element templates. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is integral to the process of creating and managing compensation elements. Specifically, it stores the definitions for balances that will be generated and maintained when an element template is used to create a new element entry. The table ensures that the complex balance definitions required for payroll calculations are correctly propagated from the template design phase to the runtime payroll processing environment.

Key Information Stored

The table's primary function is to link a specific balance definition to its template context and associated rules. The most critical column is DEFINED_BALANCE_ID, which serves as the primary key and uniquely identifies each shadow balance record. This ID is the central reference point for the object. Two key foreign key columns establish critical relationships: BALANCE_TYPE_ID links to the PAY_SHADOW_BALANCE_TYPES table, defining the type of balance (e.g., a run result balance), and EXCLUSION_RULE_ID links to PAY_TEMPLATE_EXCLUSION_RULES, specifying any conditions under which this balance should not be applied. Together, these columns define what balance is created and the rules governing its application for elements generated from the template.

Common Use Cases and Queries

This table is primarily accessed during the design and troubleshooting of element templates and their associated payroll balances. A common use case is to audit all balance definitions linked to a specific element template to verify configuration before deployment. Developers or functional consultants may run queries to understand the balance architecture of a template. A typical analytical query would join PAY_SHADOW_DEFINED_BALANCES with PAY_SHADOW_BALANCE_TYPES to list all balance definitions for a template context. Another critical scenario involves investigating payroll calculation issues by tracing a runtime balance back to its template definition, which requires querying this shadow table using the defined balance identifier found in runtime tables like PAY_BALANCE_TYPES and PAY_DEFINED_BALANCES.

Related Objects

PAY_SHADOW_DEFINED_BALANCES sits at the center of a network of related shadow objects that support the element template framework. It has direct foreign key relationships with PAY_SHADOW_BALANCE_TYPES and PAY_TEMPLATE_EXCLUSION_RULES, as documented. Furthermore, it is referenced by the PAY_SHADOW_BAL_ATTRIBUTES table, which stores the specific input values and context rules for each defined shadow balance. For a complete picture, one must also consider its relationship to the main runtime balance tables (PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES), to which the shadow definitions are synchronized when an element is created from a template. This object is part of the HR schema and is exclusively used by the Payroll module.