Results for “pay_balance_feeds_f”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_BALANCE_FEEDS_F is a payroll configuration table owned by the HR schema in Oracle E-Business Suite (validated against 12.1.1 and 12.2.2). Its documented purpose is to control which input values may feed a balance type. In practical terms, it is the mapping layer between the balance definition (PAY_BALANCE_TYPES) and the individual input values (PAY_INPUT_VALUES_F) that are permitted to accumulate into that balance. Without a corresponding feed row, an input value cannot contribute to the balance during payroll run processing, so this table is central to balance accumulation logic in Oracle Payroll.

The table is date-tracked (effective-dated) rather than purely transactional. Each row carries EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, and in 12.2.2 also ZD_EDITION_NAME, reflecting the multi-tenant/editioning arrangement introduced in that release. From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification: the table hangs off a parent (BALANCE_TYPE_ID → PAY_BALANCE_TYPES) and stores descriptive, time-variant attributes rather than acting as an independent hub or as a pure many-to-many link. This classification is heuristic and should be treated as a modeling suggestion rather than a documented fact.

Key Information Stored

The surrogate primary key PAY_BALANCE_FEEDS_F_PK is composed of BALANCE_FEED_ID together with EFFECTIVE_START_DATE and EFFECTIVE_END_DATE (and ZD_EDITION_NAME in 12.2.2). BALANCE_FEED_ID is the internal identifier for the feed definition and is the column most commonly used for direct lookups.

The principal business-key candidate is the unique index PAY_BALANCE_FEEDS_F_UK2, covering BALANCE_TYPE_ID, INPUT_VALUE_ID, BUSINESS_GROUP_ID, LEGISLATION_CODE, and the effective dates. This combination expresses the real-world rule: a given input value may feed a given balance type exactly once per business group, legislation, and effective period.

  • BALANCE_TYPE_ID — foreign key to PAY_BALANCE_TYPES; identifies the balance being fed.
  • INPUT_VALUE_ID — identifies the input value permitted to feed that balance.
  • BUSINESS_GROUP_ID — the legislative/business group context of the feed.
  • LEGISLATION_CODE — the legislation under which the feed is valid.
  • LEGISLATION_SUBGROUP — narrower legislative grouping where applicable.
  • SCALE — the multiplier or scaling factor applied when the input value feeds the balance.
  • ELEMENT_TYPE_ID and SOURCE_ID — element/source references associated with the feed definition.
  • OBJECT_VERSION_NUMBER — optimistic locking column for concurrent updates.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard Oracle EBS audit columns.

Common Use Cases and Queries

Typical uses include auditing balance configurations, diagnosing why an input value is not accumulating into a balance, and migrating balance setups between environments. A common pattern retrieves all feeds for a given balance type within a business group:

  • SELECT bf.BALANCE_FEED_ID, bf.INPUT_VALUE_ID, bf.SCALE FROM PAY_BALANCE_FEEDS_F bf WHERE bf.BALANCE_TYPE_ID = :p_balance_type_id AND bf.BUSINESS_GROUP_ID = :p_bg_id AND SYSDATE BETWEEN bf.EFFECTIVE_START_DATE AND bf.EFFECTIVE_END_DATE;
  • Joining to PAY_BALANCE_TYPES to resolve the balance name, and to the input value definition to resolve the input value name, supports configuration reports.
  • Comparing feeds against payroll run results helps explain unexpected balance values.

Related Objects

The most significant dependency is the parent balance definition. The following objects are commonly joined or referenced:

  • PAY_BALANCE_TYPES — joined on PAY_BALANCE_FEEDS_F.BALANCE_TYPE_ID = PAY_BALANCE_TYPES.BALANCE_TYPE_ID (documented FK).
  • PAY_INPUT_VALUES_F — resolves INPUT_VALUE_ID to the input value definition.
  • PAY_ELEMENT_TYPES_F — contextual link via ELEMENT_TYPE_ID.
  • PAY_BALANCES — runtime accumulated balance values affected by feed configuration.
  • PAY_BALANCE_FEEDS_VL / _TL — translated or view-level counterparts exposing feed definitions.
  • PAY_BALANCE_FEEDS API (pay_balance_feeds_api) — the supported programmatic interface for creating and maintaining feed rows.