Search Results pay_shadow_balance_types

Overview

The PAY_SHADOW_BALANCE_TYPES table is a core technical object within the Oracle E-Business Suite Payroll (PAY) module, specifically for releases 12.1.1 and 12.2.2. It functions as a metadata repository for defining shadow balance types associated with element templates. Shadow balances are temporary, calculation-specific balances used during the payroll run to store intermediate values before they are consolidated into a final, defined balance. This table is pivotal for the architecture of the FastFormula-based payroll calculation engine, enabling the system to dynamically create and manage these transient balances based on template definitions. Its primary role is to link a balance type's logical definition to a specific element template and its associated exclusion rules, forming the blueprint from which runtime shadow balances are instantiated.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships and primary key define its critical structure. The central column is BALANCE_TYPE_ID, which serves as the unique primary key (PAY_SHADOW_BALANCE_TYPES_PK) for each shadow balance type record. Two other key columns are identified by the foreign key constraints: TEMPLATE_ID links the balance type to its parent element template in the PAY_ELEMENT_TEMPLATES table, and EXCLUSION_RULE_ID references an optional exclusion rule defined in PAY_TEMPLATE_EXCLUSION_RULES that governs when this balance type is not applicable. The table essentially stores the association between a template, a rule, and a generated balance type identifier.

Common Use Cases and Queries

This table is primarily accessed for technical analysis, debugging, and impact assessment during payroll system modifications. Common scenarios include tracing the origin of a shadow balance error or identifying all shadow balance types generated by a specific element template. A typical query would join to PAY_ELEMENT_TEMPLATES to understand the context.

Sample Query:
SELECT psbt.balance_type_id, pet.template_name
FROM pay_shadow_balance_types psbt,
     pay_element_templates pet
WHERE psbt.template_id = pet.template_id
AND pet.template_name = 'Monthly Bonus Template';

Another critical use case is assessing dependencies before deleting a template or exclusion rule, as this table acts as a key child object. Developers may also query it to understand the volume and relationships of shadow objects in a complex payroll implementation.

Related Objects

As indicated by its foreign key relationships, PAY_SHADOW_BALANCE_TYPES is a central hub in the shadow balance sub-schema. Key related objects include:

• PAY_ELEMENT_TEMPLATES: The parent object defining the element's calculation rules.
• PAY_TEMPLATE_EXCLUSION_RULES: Provides conditional logic for balance applicability.
• PAY_SHADOW_BALANCE_FEEDS: Defines which input values (e.g., element entries, other balances) populate this shadow balance type.
• PAY_SHADOW_DEFINED_BALANCES: Links the shadow balance type to the final, defined balance it feeds.
• PAY_SHADOW_BALANCE_CLASSI: Likely stores classification information for the balance type.
• PAY_SHADOW_GU_BAL_EXCLUSIONS: Governs exclusions for global user (legislative) balance calculations.