Search Results okc_report_tag_tl




Overview
Explore in AI Chat

Overview

OKC_REPORT_TAG_TL is a translation (TL) table in the OKC schema, the Contracts Core module of Oracle E-Business Suite. It stores the published XML tag definitions used by Oracle Contracts Printing, otherwise known as Contract Terms and Conditions (T&C) document generation. Prior to release 11.5.9, these published tags were surfaced through the standard Oracle Help tab; from 11.5.9 onward they are held in this table, which acts as the authoritative catalog of the tag names that can be referenced when building contract print layouts and XML output templates.

Because it carries a LANGUAGE column and the standard _TL naming convention, the table stores language-specific (translated) descriptive text for each report tag, while language-independent attributes reside in the base OKC_REPORT_TAG table. In Data Vault terms, the metadata classifies this object heuristically as a standalone structure, meaning it is not currently mined as a dependent satellite or link in the documented FK graph. A practitioner may reasonably model it as a reference or satellite-style table keyed by the surrogate identifier and language, but the ETRM metadata does not assert a hub, link, or satellite role.

Key Information Stored

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

  • ID — The surrogate identifier of the report tag; part of the composite primary key OKC_REPORT_TAG_TL_PK (ID, LANGUAGE) and also part of the unique index OKC_REPORT_TAG_TL_U0.
  • LANGUAGE — The language code of the translated row; the second component of both the primary key and the unique business-key index.
  • MEANING — The translated display name or description of the published XML tag shown to users in the printing setup.
  • SOURCE_LANG — The language from which the translation was derived, used by the standard multi-language schema conventions.
  • SFWT_FLAG — The "seed from which translated" flag characteristic of Oracle's TL tables, indicating whether the row originated from a seed translation.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle WHO-column audit attributes capturing row creation and last modification.
  • SECURITY_GROUP_ID — The security group reference, forming a foreign key to FND_SECURITY_GROUPS and supporting multi-organization data partitioning.

The surrogate primary key is OKC_REPORT_TAG_TL_PK (ID, LANGUAGE); OKC_REPORT_TAG_TL_U0 (ID, LANGUAGE) is the documented business-key candidate whose column set coincides with the PK.

Common Use Cases and Queries

The primary use case is reporting on and validating the set of published XML tags available for Contracts Printing. Functional implementers query this table to confirm which tags are seeded and translated in a given language before designing print templates. A typical query joins the TL table to its base table and restricts by language:

  • SELECT t.id, t.meaning FROM okc.okc_report_tag_tl t WHERE t.language = USERENV('LANG');
  • SELECT b.id, t.meaning FROM okc.okc_report_tag b, okc.okc_report_tag_tl t WHERE b.id = t.id AND t.language = 'US';
  • SELECT id, language, meaning, last_updated_by, last_update_date FROM okc.okc_report_tag_tl ORDER BY id, language;

Common scenarios include checking for missing translations (tags present in the base table with no matching TL row), auditing tag maintenance through the WHO columns, and confirming that a custom tag needed for a bespoke print layout has been published.

Related Objects

  • OKC_REPORT_TAG — The base, language-independent table holding the same ID; the primary join partner on the ID column.
  • FND_SECURITY_GROUPS — Referenced by the SECURITY_GROUP_ID foreign key, providing the security group definitions used to partition the tag data.
  • OKC_REPORT_TAG_TL_PK / OKC_REPORT_TAG_TL_U0 — The primary key constraint and the unique index enforcing uniqueness of ID plus LANGUAGE.
  • OKC contract printing and T&C generation objects — The Contracts Printing process reads tag metadata from these tables when rendering contract documents.
  • FND_LANGUAGES — The reference source for the LANGUAGE and SOURCE_LANG values.