Search Results okc_report_xsl_tl




Overview
Explore in AI Chat

Overview

OKC_REPORT_XSL_TL is a translation (TL) table in the OKC – Contracts Core product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the language-specific stylesheets used for Oracle Contracts printing. The XSLT text held in this table drives the sql-xml-xsl-html report pipeline that transforms contract XML output into formatted HTML documents. Each row represents a stylesheet record for a given language, and the table also carries help text describing the tokens defined in the stylesheet, which is oriented toward the Articles writer role.

The table has 14 documented columns, an owner of OKC, and a primary key OKC_REPORT_XSL_TL_PK defined on (ID, LANGUAGE). A unique index, OKC_REPORT_XSL_TL_U1, also covers (ID, LANGUAGE), reinforcing that pair as the business key. The table references FND_SECURITY_GROUPS through SECURITY_GROUP_ID. From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone, which suggests treating it as an independent hub or reference satellite rather than a dependent child within a larger contract model.

Key Information Stored

  • ID – Surrogate/business identifier for the stylesheet record; part of the primary key OKC_REPORT_XSL_TL_PK.
  • LANGUAGE – Language code of the translated stylesheet; the second component of the primary key and of OKC_REPORT_XSL_TL_U1.
  • NAME – Name of the stylesheet, used to identify the report or template.
  • XSL_TEXT – The XSLT stylesheet body that performs the XML-to-HTML transformation during contract printing.
  • HELP_TEXT – Descriptive help content about the tokens defined in the stylesheet, intended for Articles writers.
  • PROTECTED_YN – Flag indicating whether the stylesheet is protected from modification.
  • SOURCE_LANG – The source language from which the translation originates.
  • SFWT_FLAG – Standard "seed data / translation" flag used in Oracle translation tables.
  • SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, controlling row-level access.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard audit columns recording who created and last modified the row and when.

Common Use Cases and Queries

Typical scenarios include verifying that a stylesheet exists for a specific language, retrieving the XSLT body for debugging contract print output, and auditing protected stylesheets. A common query retrieves the translation row for a given ID and language:

SELECT id, language, name, xsl_text FROM okc_report_xsl_tl WHERE id = :p_id AND language = :p_lang;

Reporting use cases include listing all languages in which a stylesheet is available, comparing XSL_TEXT differences across translations, and joining to FND_SECURITY_GROUPS to enforce data security. Administrators may also query HELP_TEXT to review token documentation before authoring articles. Access should generally be restricted to read-only reporting, since direct modification of XSL_TEXT affects contract printing behavior.

Related Objects

  • FND_SECURITY_GROUPS – Referenced by OKC_REPORT_XSL_TL.SECURITY_GROUP_ID for row-level security.
  • OKC_REPORT_XSL_B – The base (non-translated) counterpart table, joined on ID to obtain language-independent stylesheet attributes.
  • OKC_REPORT_GROUPS / OKC_REPORT_GROUP_ITEMS – Contract report grouping objects that can reference stylesheet definitions.
  • OKC_CONTRACT_TEMPLATES / OKC_TEMPLATES_B – Contract template definitions that drive which print stylesheet is applied.
  • OKC_REPORT_XSL_TL_PK / OKC_REPORT_XSL_TL_U1 – Primary key and unique index enforcing (ID, LANGUAGE) integrity.
  • OKC Articles / Contract Terms APIs – Consume the stylesheet tokens documented in HELP_TEXT during contract document generation.