Search Results per_bf_balance_types




Overview
Explore in AI Chat

Overview

The PER_BF_BALANCE_TYPES table is a core repository within Oracle E-Business Suite (EBS) Human Resources (HR) that defines the distinct categories of balance information that can be tracked for an employee. In the context of Oracle EBS 12.1.1 and 12.2.2, it serves as the master definition table for all balance types, such as vacation accruals, sick leave, or other custom-defined entitlements. Its primary role is to establish a standardized, business-group-specific catalog of balances, ensuring data integrity and consistency for downstream payroll and absence management processes. This table is fundamental to the Balance Feeds (BF) architecture, where balance amounts are calculated and stored based on transactional inputs against these defined types.

Key Information Stored

The table's structure is designed to enforce uniqueness and business context for each balance type definition. The critical columns include BALANCE_TYPE_ID, the system-generated primary key identifier. The DISPLAYED_NAME column holds the user-facing label for the balance type, while the INTERNAL_NAME provides a unique, non-translatable code used for programmatic references. The BUSINESS_GROUP_ID is a mandatory foreign key linking the balance type definition to a specific operating unit or business group within the HRMS module, enabling multi-org support. The existence of unique constraints on the combinations of (DISPLAYED_NAME, BUSINESS_GROUP_ID) and (INTERNAL_NAME, BUSINESS_GROUP_ID) ensures that no duplicate balance type names exist within a single business group.

Common Use Cases and Queries

This table is central to reporting on available balance definitions and troubleshooting balance-related issues. A common administrative query involves listing all balance types for a specific business group to verify setup. For example: SELECT balance_type_id, internal_name, displayed_name FROM per_bf_balance_types WHERE business_group_id = &business_group_id ORDER BY displayed_name;. During data migration or integration, developers reference this table to map external balance codes to the internal EBS balance type identifiers. Support personnel often join this table with PER_BF_BALANCE_AMOUNTS to diagnose why a specific balance is not appearing for an employee, verifying that the balance type is correctly defined and active.

Related Objects

PER_BF_BALANCE_TYPES has defined relationships with several key HR objects, as documented in the ETRM. It is the parent table for PER_BF_BALANCE_AMOUNTS via a foreign key relationship where PER_BF_BALANCE_AMOUNTS.BALANCE_TYPE_ID references PER_BF_BALANCE_TYPES.BALANCE_TYPE_ID. This is the primary relationship where the defined balance types are populated with actual values for employees. Furthermore, the table references HR_ALL_ORGANIZATION_UNITS through its BUSINESS_GROUP_ID column, tethering each balance type definition to a specific organizational context. These relationships underscore its role as a master definition table that feeds into transactional balance storage and is governed by the enterprise's organizational model.