Results for “directive_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BNE_CACHE_DIRECTIVES_TL is the translation table for BNE_CACHE_DIRECTIVES_B, the base table that stores cache directive definitions used by Oracle Web Applications Desktop Integrator (BNE) within Oracle E-Business Suite 12.1.1 and 12.2.2. Cache directives govern how the BNE integration framework caches metadata, spreadsheet templates, and related configuration artifacts during desktop integration sessions. The "_TL" suffix follows standard EBS multilingual convention: the base table holds language-independent attributes, while this table holds the language-specific, translatable text associated with each directive.

From a heuristic Data Vault modeling perspective, the metadata classifies this object as standalone. In Data Vault terms, this suggests treating BNE_CACHE_DIRECTIVES_TL as a satellite attached to the BNE_CACHE_DIRECTIVES_B hub, since it carries descriptive, time-stamped attributes rather than defining new business relationships or acting as a link between entities. The absence of mined foreign keys reinforces that the object is self-contained and keyed by its own composite business key.

Key Information Stored

The table contains 11 documented columns. The composite primary key, enforced by BNE_CACHE_DIRECTIVES_TL_PK, consists of APPLICATION_ID, DIRECTIVE_CODE, and LANGUAGE. A secondary unique index, BNE_CACHE_DIRECTIVES_TL_UK1, extends this combination with ZD_EDITION_NAME, reflecting the editioning framework introduced in EBS 12.2.

• APPLICATION_ID — Identifies the EBS application context owning the directive; part of the primary key.
• DIRECTIVE_CODE — The business identifier of the cache directive; the column targeted by the user's search and a primary key component joining to the base table.
• LANGUAGE — The NLS language code of the translated row; part of the primary key.
• SOURCE_LANG — The source language from which the translation was derived, used by the translation synchronization utilities.
• ZD_EDITION_NAME — The edition identifier supporting EBS 12.2 online patching; part of the UK1 unique index.
• USER_NAME — The application user or seeded identity associated with the directive definition.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the most recent modification and session context.

Common Use Cases and Queries

Typical usage centers on resolving translated directive descriptions for reporting and troubleshooting. A frequent pattern joins the translation table back to the base table on the shared key columns:

• Retrieving a specific directive by code: SELECT directive_code, language, user_name FROM bne.bne_cache_directives_tl WHERE directive_code = :code;
• Listing all translations for an application: SELECT directive_code, language FROM bne.bne_cache_directives_tl WHERE application_id = :app_id;
• Auditing recent translation changes: filter on LAST_UPDATE_DATE for rows modified within a given period.
• Detecting untranslated directives by comparing row counts against BNE_CACHE_DIRECTIVES_B per LANGUAGE.

Because the object is standalone with no mined foreign keys, joins to the base table are performed on the shared composite key (APPLICATION_ID, DIRECTIVE_CODE, LANGUAGE) rather than on a declared constraint.

Related Objects

The most significant related objects are:

• BNE_CACHE_DIRECTIVES_B — The base table; joined on APPLICATION_ID, DIRECTIVE_CODE, and LANGUAGE.
• BNE_CACHE_DIRECTIVES_TL_PK — The primary key constraint enforcing uniqueness.
• BNE_CACHE_DIRECTIVES_TL_UK1 — The unique index incorporating ZD_EDITION_NAME for edition-aware lookups.
• BNE integration APIs and concurrent programs — Internal BNE processes that read directive metadata when initializing desktop integration caches.
• FND_LANGUAGES — The language reference table validating LANGUAGE and SOURCE_LANG values.
• FND_APPLICATION — The application registry validating APPLICATION_ID.