Results for “okc_report_prm_tl”

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

Overview

The OKC_REPORT_PRM_TL table is a core metadata object within the OKC (Contracts Core) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores translated attributes for SQL-XML parameters used during contract printing. Specifically, it holds the language-dependent prompt text associated with reporting parameters that drive the generation of contract documents through the Oracle Contracts SQL-XML printing framework. Each row represents a parameter prompt in a given language, enabling the contract printing engine to render user-facing labels consistently across multilingual deployments.

From a data modeling perspective, the ETRM metadata classifies this object as standalone under a heuristic Data Vault assessment. This suggests it functions independently rather than as a hub, link, or satellite, though a formal Data Vault design might alternatively treat it as a satellite on a parameter hub given its translation-oriented payload columns (PROMPT, SOURCE_LANG).

Key Information Stored

• ID — The surrogate identifier linking translated rows to the base parameter definition. Part of the composite primary key.
• LANGUAGE — The language code for the translated prompt. Combined with ID, forms the primary key OKC_REPORT_PRM_TL_PK and the unique index OKC_REPORT_PRM_TL_U1.
• PROMPT — The translated, user-facing label displayed for the SQL-XML parameter during contract printing.
• SOURCE_LANG — Indicates the source language from which the translation was derived, used by the translation (TL) framework to track origin.
• SFWT_FLAG — The "Seed/Force/Whatever/Translation" flag used by Oracle's multilingual seed data utilities to identify the row's translation status.
• CREATED_BY, CREATION_DATE — Standard audit columns recording who created the row and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns capturing the most recent modification.
• LAST_UPDATE_LOGIN — The login ID associated with the last update.
• SECURITY_GROUP_ID — Foreign key referencing FND_SECURITY_GROUPS, enforcing multi-tenant or organizational security segmentation.

The surrogate primary key is the composite (ID, LANGUAGE), while the business-key candidate identified by the unique index is also (ID, LANGUAGE), reflecting Oracle's standard TL table convention where ID references the base table and LANGUAGE provides the locale dimension.

Common Use Cases and Queries

Typical usage centers on contract printing configuration validation and multilanguage reporting. Administrators may query this table to verify that prompts exist for each supported language before running contract print jobs. A representative query:

• SELECT id, language, prompt FROM okc.okc_report_prm_tl WHERE id = :param_id ORDER BY language;
• Auditing translation coverage: SELECT id, COUNT(*) FROM okc.okc_report_prm_tl GROUP BY id HAVING COUNT(*) < :expected_lang_count;
• Joining to the base parameter table on ID to compare base versus translated attributes.
• Reporting on rows missing translations where SOURCE_LANG = LANGUAGE, indicating an untranslated prompt.

Related Objects

• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; governs row-level security segmentation.
• OKC_REPORT_PRM_B — The base (non-translated) parameter table, joined on ID to retrieve language-independent attributes.
• OKC_REPORT_PRM_VL — The translated view exposing both base and TL columns for convenience queries.
• OKC_REPORT_PARAMETERS / OKC_REPORT_GROUPS — Report configuration containers that reference parameter definitions via ID.
• FND_LANGUAGES — Referenced implicitly by LANGUAGE for locale validation.

Because the table is classified as standalone, direct foreign key traffic is limited, but joins through ID to the base parameter structures are essential for any reporting or administrative query.