Search Results pay_shadow_balance_feeds




Overview
Explore in AI Chat

Overview

The PAY_SHADOW_BALANCE_FEEDS table is a core technical object within the Oracle E-Business Suite Payroll module (PAY). It functions as a staging repository for balance feed definitions during the creation or modification of element templates. When a user configures how an element's input values should feed into a balance within a template, these definitions are initially stored as "shadow" records. This mechanism allows for the validation and processing of complex balance feed rules before they are finalized and transferred to the live production tables, such as PAY_BALANCE_FEEDS_F. Its role is critical for maintaining data integrity and supporting the template-driven configuration of the payroll calculation engine in both releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to map input values from shadow elements to shadow balance types. Its structure, inferred from the provided metadata, centers on key foreign key relationships. The primary key column is BALANCE_FEED_ID. The most significant columns include BALANCE_TYPE_ID, which links to PAY_SHADOW_BALANCE_TYPES to identify the target balance, and INPUT_VALUE_ID, which links to PAY_SHADOW_INPUT_VALUES to identify the source of the monetary or numerical data. The EXCLUSION_RULE_ID column links to PAY_TEMPLATE_EXCLUSION_RULES, enabling the association of conditional rules that determine when a specific feed should or should not be applied during payroll processing.

Common Use Cases and Queries

This table is primarily accessed by the underlying payroll engine during template submission and validation processes. Common operational scenarios include troubleshooting errors in element template definitions and auditing pending balance feed configurations. A typical diagnostic query would join this table to its related shadow tables to review configured feeds before template activation.

  • Sample Query to Review Shadow Feeds:
    SELECT psbf.balance_feed_id, psbt.balance_name, psiv.name input_value_name
    FROM pay_shadow_balance_feeds psbf,
    pay_shadow_balance_types psbt,
    pay_shadow_input_values psiv
    WHERE psbf.balance_type_id = psbt.balance_type_id
    AND psbf.input_value_id = psiv.input_value_id
    AND psbt.template_id = :p_template_id;
    (Note: This is a simplified pattern; actual implementation may involve more complex joins and date-effective logic.)

Related Objects

As indicated by its foreign keys, PAY_SHADOW_BALANCE_FEEDS is intrinsically linked to other shadow tables that form a temporary configuration set. Key dependencies include:

  • PAY_SHADOW_BALANCE_TYPES: The target shadow balances for the feeds.
  • PAY_SHADOW_INPUT_VALUES: The source shadow input values providing the feed data.
  • PAY_TEMPLATE_EXCLUSION_RULES: Provides conditional logic for applying the feed.
  • PAY_BALANCE_FEEDS_F: The primary production table where finalized shadow feed data is ultimately merged.