Results for “oke_k_deliverables_tlh”

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

Overview

OKE_K_DELIVERABLES_TLH is a table in the OKE schema (Project Contracts) within Oracle E-Business Suite, present in releases 12.1.1 and 12.2.2. It stores contract deliverable multi-lingual historical information, functioning as the language- and version-aware companion store for deliverable descriptive text in the Oracle Project Contracts module. Where the base deliverable records capture the operational definition of a contractual deliverable (for example, a deliverable item associated with a contract header or line), this table retains the translated and historically versioned textual content — descriptions and comments — keyed by language and major version so that multilingual and prior-version text remains independently retrievable.

The ETRM metadata classifies this object, heuristically mined from its foreign key structure, as a standalone Data Vault classification. In Data Vault terms this suggests treating the table as a descriptive satellite-like store rather than a central hub or link: its business identity is inherited from the parent deliverable and contract entities it references, and its content is predominantly descriptive and version-scoped rather than relationship-bearing.

Key Information Stored

The table documents 14 columns. The most consequential are the following.

• DELIVERABLE_ID — identifies the parent contract deliverable. It participates in the composite primary key and is the principal point of join back to the base deliverable entity.
• LANGUAGE — the language of the stored text, enabling multi-lingual content for the same deliverable.
• MAJOR_VERSION — the major version of the deliverable content, supporting historical retention of superseded text.
• DESCRIPTION — the translated/historical descriptive text of the deliverable.
• COMMENTS — free-form translated or historical commentary attached to the deliverable.
• SOURCE_LANG — the source language from which the row's text was derived, relevant to translation workflows.
• SFWT_FLAG — the standard "seed from which" style flag used by Oracle's translation infrastructure to identify seeded versus translated rows.
• K_HEADER_ID — foreign key to OKE_K_HEADERS, tying the row to the owning contract header.
• K_LINE_ID — foreign key to OKE_K_LINES, tying the row to the contract line.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle WHO audit columns.

The surrogate primary key is OKE_K_DELIVERABLES_TLH_PK, defined on (DELIVERABLE_ID, LANGUAGE, MAJOR_VERSION). A unique index, OKE_K_DELIVERABLES_TLH_U1, exists on the same three columns, making this composite the business-key candidate: a deliverable may have at most one row per language per major version.

Common Use Cases and Queries

Typical usage centers on retrieving the correct language/version of deliverable text for reporting, contract printing, and translation reconciliation.

• Fetch current-language descriptive text for a deliverable: SELECT description, comments FROM oke.oke_k_deliverables_tlh WHERE deliverable_id = :p_id AND language = USERENV('LANG') ORDER BY major_version DESC;
• Reconstruct version history: query all MAJOR_VERSION values for a given DELIVERABLE_ID and LANGUAGE ordered descending.
• Translation gap analysis: compare rows where SFWT_FLAG / SOURCE_LANG indicate untranslated seeded content against expected target languages.
• Header/line rollups: join to OKE_K_HEADERS and OKE_K_LINES via K_HEADER_ID and K_LINE_ID to report deliverable text at contract header or line granularity.

Because joins against the base entities often pass through DELIVERABLE_ID and the K_HEADER_ID/K_LINE_ID foreign keys, reporting queries should filter on LANGUAGE and select the maximum MAJOR_VERSION to avoid returning superseded historical rows.

Related Objects

• OKE_K_HEADERS — referenced via K_HEADER_ID; the owning contract header.
• OKE_K_LINES — referenced via K_LINE_ID; the owning contract line.
• OKE_K_DELIVERABLES_TL — the current (non-historical) translated deliverable text table, sharing the same language keying convention.
• OKE_K_DELIVERABLES_B / base deliverable entity — the primary deliverable definition keyed by DELIVERABLE_ID.
• Oracle Project Contracts concurrent programs and deliverable inquiry/print forms that render translated and versioned deliverable text.
• Translation/MLS seed utilities that populate SOURCE_LANG and SFWT_FLAG.