Search Results bne_perf_statistics_tl




Overview
Explore in AI Chat

Overview

The BNE_PERF_STATISTICS_TL table is a core data dictionary object within the Web Applications Desktop Integrator (BNE) product family of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the primary repository for the descriptive, translatable definitions of performance statistics tracked by the system. These statistics are instrumental for monitoring and analyzing the operational efficiency and performance of BNE-related processes, such as data integration and batch operations. As a translatable table (indicated by the '_TL' suffix), it supports the storage of statistic descriptions in multiple languages, enabling a global deployment to adhere to multilingual requirements. Its role is to provide the human-readable labels and definitions that contextualize the raw performance metric data captured elsewhere in the application.

Key Information Stored

The table's structure is designed to uniquely identify a statistic's description per language. The primary key, BNE_PERF_STATISTICS_TL_PK, is a composite key consisting of the STATISTIC_CODE and LANGUAGE columns. The STATISTIC_CODE is the unique identifier for a specific performance metric (e.g., a code for 'Rows Processed per Second' or 'Integration Job Duration'). The LANGUAGE column holds the language code (such as 'US' for American English) for the corresponding translation. While the specific descriptive column names are not detailed in the provided metadata, typical '_TL' tables in Oracle EBS contain columns like DESCRIPTION, SOURCE_LANG, and LAST_UPDATE_DATE. These would store the textual definition of the statistic, the original language of the record, and audit information, respectively.

Common Use Cases and Queries

The primary use case is to retrieve the user-friendly name and description of a performance statistic for display in reports, performance dashboards, or administrative interfaces within the BNE module. A common reporting query would join this table with a related base table (e.g., BNE_PERF_STATISTICS_B) to present a comprehensive view of both the technical statistic code and its translated description. A typical SQL pattern for fetching all statistic descriptions for a specific language would be:

  • SELECT STATISTIC_CODE, DESCRIPTION FROM BNE.BNE_PERF_STATISTICS_TL WHERE LANGUAGE = 'US';

Another critical use case is during the setup or upgrade of EBS for a new language, where translated data for these statistic definitions must be loaded into this table to ensure proper localization of performance monitoring tools.

Related Objects

Based on the provided relationship data, the BNE_PERF_STATISTICS_TL table has a defined relationship with its corresponding base table, which is logically BNE_PERF_STATISTICS_B. The relationship is enforced through the primary key (STATISTIC_CODE, LANGUAGE). The STATISTIC_CODE in the '_TL' table is a foreign key referencing the STATISTIC_CODE in the '_B' table. This is a standard Oracle EBS architecture pattern where '_B' tables hold non-translatable information and '_TL' tables hold the language-specific descriptions. Therefore, any API or user interface displaying performance statistic details will typically join these two tables. Other objects, such as performance summary views or reporting repositories, are likely to depend on this table to resolve statistic codes to their descriptive text.