Search Results stylesheet_code




Overview
Explore in AI Chat

Overview

BNE_STYLESHEETS_TL is the translation (language-dependent) table for the Oracle Web Applications Desktop Integrator (BNE) stylesheet repository. In Oracle E-Business Suite 12.1.1 and 12.2.2, it stores the translatable text attributes of a stylesheet definition — principally the DESCRIPTION field — in each installed language, while the language-independent attributes reside in the base table BNE_STYLESHEETS_B. This separation follows the standard Oracle EBS MLS (Multi-Language Support) pattern, in which the "_B" table holds non-translatable columns and the "_TL" table holds the translated columns, with each row keyed by language.

The table is owned by the BNE schema and is classified VALID in the ETRM repository. Under the heuristic Data Vault classification supplied in the metadata, the object is marked standalone, indicating that no foreign-key relationships were mined from its constraint structure. As a modeling suggestion, however, its shape is characteristic of a satellite: it carries the descriptive, language-dependent attributes of the stylesheet business key together with the standard EBS audit columns, and it is functionally dependent on the parent stylesheet entity rather than acting as an independent hub.

Key Information Stored

The documented physical schema for 12.2.2 contains twelve columns. The primary key, BNE_STYLESHEETS_TL_PK, is a composite surrogate covering APPLICATION_ID, STYLESHEET_CODE, and LANGUAGE. A second unique index, BNE_STYLESHEETS_TL_UK1, extends this to include ZD_EDITION_NAME, making it the broader business-key candidate for edition-aware lookups.

  • APPLICATION_ID — identifies the owning application, distinguishing stylesheet definitions that share a code across products.
  • STYLESHEET_CODE — the developer-facing identifier of the stylesheet; with APPLICATION_ID it links to the base row in BNE_STYLESHEETS_B.
  • LANGUAGE — the NLS language of the translated row; part of both the primary key and the unique business key.
  • SOURCE_LANG — the language from which the row was derived, used by the MLS infrastructure to track translation lineage.
  • DESCRIPTION — the translated, user-visible description of the stylesheet, the principal payload of the table.
  • ZD_EDITION_NAME — the editioning column introduced in 12.2 online patching, allowing edition-specific copies of the same logical row.
  • USER_NAME — the database user context associated with the row.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — the standard EBS audit trail columns recording who created and last modified the translation and when.

Common Use Cases and Queries

The table is queried whenever a user-facing stylesheet description is required in a specific language, typically joining to the base table to resolve the stylesheet identity. A common pattern restricts rows to the session language:

  • Retrieve descriptions for a language: SELECT b.application_id, b.stylesheet_code, t.description FROM bne_stylesheets_b b, bne_stylesheets_tl t WHERE b.application_id = t.application_id AND b.stylesheet_code = t.stylesheet_code AND t.language = USERENV('LANG');
  • Detect incomplete translations: compare the count of TL rows per STYLESHEET_CODE against the number of installed languages to find missing DESCRIPTION entries.
  • Audit translation currency: inspect SOURCE_LANG and LAST_UPDATE_DATE to identify translations older than the base row.
  • Edition-aware querying: filter or exclude ZD_EDITION_NAME depending on whether the query runs against the run edition or a patch edition file system in 12.2.

Reporting against this table is generally confined to repository administration, localization audits, and seeded-data verification rather than transactional reporting.

Related Objects

  • BNE_STYLESHEETS_B — the base table; joined on APPLICATION_ID and STYLESHEET_CODE.
  • BNE_STYLESHEETS_TL_PK — composite primary key index over APPLICATION_ID, STYLESHEET_CODE, LANGUAGE.
  • BNE_STYLESHEETS_TL_UK1 — unique business-key index adding ZD_EDITION_NAME.
  • BNE_STYLESHEETS_VL — the conventional MLS view unioning base and translation rows for application queries.
  • FND_LANGUAGES — reference table validating the LANGUAGE and SOURCE_LANG values.
  • FND_APPLICATION — resolves APPLICATION_ID to an application name.
  • FND_USER — resolves CREATED_BY and LAST_UPDATED_BY to user identities.