Search Results oke_k_deliverables_tl_pk

Overview

The OKE_K_DELIVERABLES_TL table is a core data object within the Oracle E-Business Suite (EBS) Project Contracts (OKE) module. It functions as a translation or multi-lingual table, specifically designed to store language-specific textual descriptions for contract deliverables. Its primary role is to support the global deployment of Oracle EBS by enabling the storage of deliverable names and descriptions in multiple languages, a critical requirement for multinational organizations. The table operates in conjunction with its base table, OKE_K_DELIVERABLES_B, which holds the language-independent transactional data. This separation of language-sensitive and language-insensitive data is a standard architectural pattern in Oracle Applications, facilitating efficient internationalization.

Key Information Stored

The table's structure is defined by its primary key, which consists of the DELIVERABLE_ID and LANGUAGE columns. This ensures a unique record for each combination of a deliverable and a language. The DELIVERABLE_ID is a foreign key that links each translated record back to its corresponding master record in the OKE_K_DELIVERABLES_B table. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'F' for French). The most significant data columns are typically the translatable attributes, such as DELIVERABLE_NAME and DESCRIPTION, which hold the user-facing text in the specified language. Standard Oracle Application columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are also present for auditing purposes.

Common Use Cases and Queries

The primary use case is retrieving deliverable information in a user's session language for display in forms, reports, and self-service pages. A common reporting requirement is to list all deliverables for a contract with their descriptions in a specific language. For technical customizations or data extracts, developers often join this table with its base table and other contract headers to create multi-lingual datasets. A typical query pattern is:

• SELECT tl.deliverable_name, tl.description, b.* FROM oke_k_deliverables_b b, oke_k_deliverables_tl tl WHERE b.deliverable_id = tl.deliverable_id AND tl.language = USERENV('LANG');

This ensures the translated text is pulled based on the current user's language setting. Data migration scripts for setting up multi-lingual seed data also directly interact with this table.

Related Objects

The OKE_K_DELIVERABLES_TL table has a direct and singular foreign key relationship with its corresponding base table, as documented in the provided metadata. This relationship is fundamental to its operation.

• Primary Key (OKE_K_DELIVERABLES_TL_PK): DELIVERABLE_ID, LANGUAGE.
• Foreign Key to OKE_K_DELIVERABLES_B: The table OKE_K_DELIVERABLES_TL references the table OKE_K_DELIVERABLES_B via the column DELIVERABLE_ID. This is a one-to-many relationship from the base table (B) to the translation table (TL).

In application logic, this table is accessed via standard Oracle APIs or views that abstract the underlying joins. It is a child object within the broader Project Contracts data model, which includes key tables like OKE_K_HEADERS_B for contract headers.