Search Results bne_param_groups_tl




Overview
Explore in AI Chat

Overview

BNE_PARAM_GROUPS_TL is the translation (TL) table for the parameter group definitions used by Oracle Web Applications Desktop Integrator (BNE). It stores the language-specific display attributes that accompany the base, language-independent records held in BNE_PARAM_LISTS_B. In Oracle EBS 12.1.1 and 12.2.2, TL tables follow the standard multilingual architecture in which the _B table carries the operational data and the _TL table carries translated descriptive text, joined by the shared business key plus LANGUAGE. The object resides in the BNE schema and is valid in both release levels.

The documented ETRM metadata notes a heuristic Data Vault classification of standalone, meaning the mined foreign-key structure does not resolve the table into a conventional hub, link, or satellite. As a modeling suggestion, this classification reflects that the table is queried primarily through its own composite key rather than through enforced referential relationships, and that its rows are functionally dependent on the parent base record rather than on independent business entities.

Key Information Stored

The table is defined with 12 documented columns. The most significant are listed below.

  • APPLICATION_ID — Identifies the application context to which the parameter group belongs; part of the primary key and of the unique business key.
  • PARAM_LIST_CODE — The parameter list identifier that groups the parameters; together with APPLICATION_ID it anchors the record to the base definition in BNE_PARAM_LISTS_B.
  • SEQUENCE_NUM — Ordinal position of the parameter group within the list; participates in both the primary and unique keys.
  • LANGUAGE — The NLS language code for the translation row; distinguishes the multiple translated versions of the same base record.
  • SOURCE_LANG — Indicates the source language from which the row was derived, supporting the standard EBS translation workflow.
  • USER_NAME — The translated, user-facing name or label associated with the parameter group.
  • ZD_EDITION_NAME — Editioning column used by the EBS online patching (Edition-Based Redefinition) framework in 12.2.x; it is included in the unique index BNE_PARAM_GROUPS_TL_UK1.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording insert and update history, used for reconciliation and data-lineage reporting.

The surrogate primary key is BNE_PARAM_GROUPS_TL_PK, defined on (APPLICATION_ID, PARAM_LIST_CODE, SEQUENCE_NUM, LANGUAGE). The unique index BNE_PARAM_GROUPS_TL_UK1 extends this with ZD_EDITION_NAME and represents the business-key candidate, ensuring one translation row per language and edition per group.

Common Use Cases and Queries

Typical reporting scenarios include extracting all translations for a given parameter list, auditing which languages are maintained, and reconciling TL rows against the corresponding base rows. The following pattern retrieves translated labels for a specific parameter list:

  • SELECT LANGUAGE, USER_NAME, SEQUENCE_NUM FROM BNE.BNE_PARAM_GROUPS_TL WHERE APPLICATION_ID = :app_id AND PARAM_LIST_CODE = :list_code ORDER BY SEQUENCE_NUM, LANGUAGE;
  • Joining to the base table to detect missing or orphaned translations: SELECT b.PARAM_LIST_CODE, t.LANGUAGE FROM BNE_PARAM_LISTS_B b LEFT JOIN BNE_PARAM_GROUPS_TL t ON t.APPLICATION_ID = b.APPLICATION_ID AND t.PARAM_LIST_CODE = b.PARAM_LIST_CODE AND t.SEQUENCE_NUM = b.SEQUENCE_NUM WHERE t.LANGUAGE IS NULL;
  • Filtering by ZD_EDITION_NAME when running in an editioned 12.2.x environment, and querying via FND_LANGUAGES to resolve language names for display.

Related Objects

  • BNE_PARAM_LISTS_B — The base, language-independent table for which this object provides translations; joined on APPLICATION_ID and PARAM_LIST_CODE.
  • BNE_PARAM_LISTS_TL — The companion translation table for parameter list metadata, sharing the same language universe.
  • BNE_PARAM_GROUPS_B — Where present, the base counterpart holding the untranslated group definitions.
  • BNE_PARAMETERS — Parameter definitions that reference their governing list and group context.
  • FND_LANGUAGES — Reference table resolving the LANGUAGE code to a readable language name.
  • FND_APPLICATION — Reference table resolving APPLICATION_ID to an application short name and description.