Search Results set_code




Overview
Explore in AI Chat

Overview

The BNE_PERF_SET_ITEMS table is a core data object within the Web Applications Desktop Integrator (BNE) product of Oracle E-Business Suite. Its primary function is to define the membership of individual performance statistics within a named performance set. A performance set is a logical grouping of statistics used for monitoring and reporting on the performance and usage of Desktop Integrator components. This table acts as the intersection entity, linking performance sets to their constituent statistics, thereby enabling structured performance analysis and audit reporting for the BNE module.

Key Information Stored

The table stores a straightforward mapping between a performance set and its items. Its structure is defined by a composite primary key, ensuring a unique relationship between each set and statistic. The critical columns are:

  • SET_CODE: A foreign key column that stores the unique identifier for a performance set. This code references the BNE_PERF_SETS_B table, which holds the definition of the set itself (e.g., its name, description).
  • STATISTIC_CODE: A foreign key column that stores the unique identifier for a specific performance metric or statistic. This code references the BNE_PERF_STATISTICS_B table, which contains the definitions of all available statistics (e.g., statistic name, type, category).

Common Use Cases and Queries

This table is central to performance reporting for Desktop Integrator. Administrators and developers query it to understand what metrics are being tracked within a specific set, to generate audit reports, or to validate configuration. A common use case is retrieving a complete list of statistics for a given performance set for review or documentation purposes. A typical query would join to the related definition tables to provide meaningful names.

Sample Query:
SELECT ps.SET_CODE, ps.NAME SET_NAME,
psi.STATISTIC_CODE, st.NAME STATISTIC_NAME
FROM BNE_PERF_SET_ITEMS psi,
BNE_PERF_SETS_B ps,
BNE_PERF_STATISTICS_B st
WHERE psi.SET_CODE = ps.SET_CODE
AND psi.STATISTIC_CODE = st.STATISTIC_CODE
AND ps.SET_CODE = '&YOUR_SET_CODE';
This pattern is foundational for any custom performance dashboards or extracts related to BNE activity.

Related Objects

The BNE_PERF_SET_ITEMS table maintains strict referential integrity with two key definition tables via foreign key constraints, as documented in the ETRM metadata.

  • BNE_PERF_SETS_B: The table is referenced via the foreign key on BNE_PERF_SET_ITEMS.SET_CODE. This relationship ensures that every item in the intersection table belongs to a valid, defined performance set.
  • BNE_PERF_STATISTICS_B: The table is referenced via the foreign key on BNE_PERF_SET_ITEMS.STATISTIC_CODE. This relationship ensures that every item mapped to a set corresponds to a valid, defined performance statistic within the system.

The table's primary key, BNE_PERF_SET_ITEMS_PK (SET_CODE, STATISTIC_CODE), enforces the uniqueness of the set-item combination and is the anchor point for these relationships.