Search Results bne_param_lists_tl




Overview
Explore in AI Chat

Overview

BNE_PARAM_LISTS_TL is the translation (language) table that accompanies BNE_PARAM_LISTS_B in the BNE schema. BNE is the database account for Oracle Web Applications Desktop Integrator (Web ADI), the framework that lets users create, upload, and download desktop-integrated spreadsheets and integrator layouts directly from E-Business Suite. Parameter lists in this framework define the ordered collection of parameters, prompts, and layout hints that an integrator presents to the user; the _TL table stores the language-specific, user-facing text for each of those parameter lists.

In Oracle EBS 12.1.1 and 12.2.2, the pattern of a base table (_B) paired with a translation table (_TL) is the standard MLS (Multi-Language Support) design. The base table holds language-independent data, while the _TL table holds the translatable columns keyed by LANGUAGE. The documented primary key of BNE_PARAM_LISTS_TL is BNE_PARAM_LISTS_TL_PK over (APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE), which mirrors the same key structure in the base table and enables one row per parameter list per installed language.

The metadata classifies this object heuristically as standalone within a Data Vault–style model. In Data Vault terms, it is best understood as a satellite attached to the parameter-list business key: it holds descriptive, language-dependent attributes (the prompts and tips) that change independently of the parent entity and carry their own load timestamps. It should not be modeled as a hub or link, since it carries no independent business key and no relationship cardinality of its own beyond the translation of the base entity.

Key Information Stored

The table contains 14 documented columns. The most significant are:

  • APPLICATION_ID – Identifies the owning application/product within EBS. Part of the primary key and of the unique index, it scopes each parameter list to a specific application.
  • PARAM_LIST_CODE – The developer-defined code that uniquely names a parameter list within an application. Combined with APPLICATION_ID, it forms the business identifier of the parent entity.
  • LANGUAGE – The NLS language code (for example, US for American English). Together with the two columns above, it forms BNE_PARAM_LISTS_TL_PK.
  • SOURCE_LANG – Indicates the language in which the row was originally authored, used by the translation framework to track the source of a translated string.
  • USER_NAME – The translatable display name of the parameter list shown to end users.
  • USER_TIP – The translatable tooltip or help text presented alongside the parameter list.
  • PROMPT_LEFT and PROMPT_ABOVE – Translatable prompt text rendered to the left of, or above, the associated field, allowing layouts to adapt to different languages and formatting conventions.
  • ZD_EDITION_NAME – The editioning column introduced with EBS 12.2 Online Patching. It identifies the edition in which the row is valid and participates in the unique index BNE_PARAM_LISTS_TL_UK1 (APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE, ZD_EDITION_NAME). In 12.1.1 this column is absent; in 12.2.2 it is a standard part of the physical schema.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS WHO columns recording the audit trail of row creation and modification. These support concurrent-program diagnostics and data lineage reporting.

The surrogate key of the table is BNE_PARAM_LISTS_TL_PK; the business-key candidate exposed through the unique index includes ZD_EDITION_NAME, reflecting the edition-aware uniqueness rule in 12.2.x. Translatable columns are the name, tip, and prompt fields; all remaining columns are non-translatable and are copied from or maintained in the base table.

Common Use Cases and Queries

Typical scenarios include:

  • Investigating missing or stale translations for a Web ADI integrator, where users see an untranslated prompt. A common query joins the base and translation tables and filters by language:
SELECT b.param_list_code, t.language, t.user_name, t.user_tip,
       t.prompt_left, t.prompt_above
  FROM bne.bne_param_lists_b b,
       bne.bne_param_lists_tl t
 WHERE b.application_id   = t.application_id
   AND b.param_list_code  = t.param_list_code
   AND t.language         = USERENV('LANG');
  • Checking language coverage for a parameter list by listing the distinct languages present in the translation table and comparing them against the installed languages:
SELECT t.language, COUNT(*)
  FROM bne.bne_param_lists_tl t
 WHERE t.param_list_code = :code
 GROUP BY t.language;
  • Audit and change tracking using LAST_UPDATED_BY and LAST_UPDATE_DATE to identify rows modified by a specific concurrent program or user, which is useful when diagnosing unexpected prompt changes after a patch.
  • Reporting on which applications have translated parameter lists, joining APPLICATION_ID to FND_APPLICATION for readable application names.
  • Patching verification in 12.2.2, where ZD_EDITION_NAME must be considered so that only rows for the current edition are returned.

Because Web ADI layouts and parameters drive what users see in generated spreadsheets, these queries are frequently used during implementation and post-upgrade validation to confirm that integrator prompts appear correctly in each supported language.

Related Objects

  • BNE_PARAM_LISTS_B – The base (non-translated) table. Joined on APPLICATION_ID and PARAM_LIST_CODE; it holds the language-independent definition of each parameter list.
  • BNE_PARAM_LIST_ITEMS_TL / BNE_PARAM_LIST_ITEMS_B – The translation and base tables for the individual items belonging to a parameter list. The list is the parent of the items via PARAM_LIST_CODE.
  • BNE_PARAM_LIST_VALUES – Stores the allowed values for parameter list items; joined through PARAM_LIST_CODE and the item code.
  • BNE_INTEGRATORS_B / BNE_INTEGRATORS_TL – The integrator base and translation tables; integrators reference parameter lists and are the primary consumers of the translated name and prompt text.
  • BNE_LAYOUTS_B / BNE_LAYOUTS_TL – Layout definitions that render parameter prompts in generated spreadsheets.
  • FND_APPLICATION – Provides the application name for APPLICATION_ID and validates the ownership scope of a parameter list.
  • FND_LANGUAGES – Supplies the language name and installed-language information corresponding to the LANGUAGE column.
  • FND_TERRITORIES – Occasionally joined when reporting on locale-specific behavior of parameter lists.

The consistent key pattern (APPLICATION_ID, PARAM_LIST_CODE, LANGUAGE) across the _B and _TL tables, plus the ZD_EDITION_NAME column in 12.2.2, means most reporting queries will join the two tables on those columns and filter on language and edition to obtain accurate, user-facing text.