Search Results bne_perf_sets_b




Overview
Explore in AI Chat

Overview

The BNE_PERF_SETS_B table is a core data dictionary table within the Oracle E-Business Suite (EBS) Web Applications Desktop Integrator (BNE) product. It serves as the master definition table for performance statistic sets. In the context of BNE, which facilitates desktop integration for EBS, performance sets are logical groupings used to monitor, collect, and analyze runtime performance metrics for integration processes. This table provides the foundational metadata that defines each unique set, enabling administrators to organize and track specific performance criteria for operational reporting and tuning.

Key Information Stored

While the provided ETRM metadata does not list specific column names beyond the primary key, the table's purpose and structure can be inferred. The central column is SET_CODE, which acts as the unique identifier (primary key) for a performance statistic set. This code is likely a short, meaningful string used to reference the set throughout the system. Other columns in the table would typically store descriptive and control attributes for the set, such as a display name (e.g., SET_NAME), an enabled flag, creation dates, and descriptive text. The table's '_B' suffix indicates it is the base table for a translatable entity, suggesting a corresponding _TL (translation) table may exist for multilingual support of descriptive fields.

Common Use Cases and Queries

The primary use case for this table is the administration and reporting of BNE performance metrics. An administrator might query this table to audit all defined performance sets or to validate a set code before associating new performance items with it. A common reporting query would join BNE_PERF_SETS_B with its child table, BNE_PERF_SET_ITEMS, to list all statistics captured within a specific set. For example, a SQL pattern to retrieve all active performance sets and their items might resemble:

  • SELECT s.set_code, s.set_name, i.item_code FROM bne_perf_sets_b s, bne_perf_set_items i WHERE s.set_code = i.set_code ORDER BY s.set_code;

This data is foundational for performance dashboards or custom reports that analyze the efficiency of desktop integration flows over time.

Related Objects

The BNE_PERF_SETS_B table has a direct parent-child relationship with the BNE_PERF_SET_ITEMS table, as documented in the provided metadata. The relationship is enforced by a foreign key constraint where BNE_PERF_SET_ITEMS.SET_CODE references BNE_PERF_SETS_B.SET_CODE. This means that individual performance statistic items (stored in BNE_PERF_SET_ITEMS) must belong to a valid set defined in BNE_PERF_SETS_B. The table's primary key constraint is named BNE_PERF_SETS_B_PK on the SET_CODE column. As a base table, it is also likely referenced by associated views or public APIs provided by the BNE product for safer data access.