Search Results okr_prop_types_tl




Overview
Explore in AI Chat

Overview

OKR_PROP_TYPES_TL is the translation table for valid right types within the Oracle Contracts for Rights (OKR) module. In Oracle EBS, the OKR product family supported the licensing, acquisition, and administration of intellectual property rights, and OKR_PROP_TYPES_TL served as the multilingual repository for the descriptive text associated with each right (proposition) type defined in the corresponding base table. The "_TL" suffix follows the standard Oracle Applications convention for translation tables, which store language-dependent columns keyed by both the entity identifier and a LANGUAGE code, enabling seeded and user-defined values to be presented in multiple installed languages.

The metadata classifies this object within the OKR - Contracts for Rights module as obsolete and explicitly notes that it is not implemented in the referenced database. This status reflects the broader deprecation of the OKR product line, which is not part of the standard Oracle E-Business Suite 12.1.1 or 12.2.2 installation footprint unless a legacy OKR license was historically deployed. From a Data Vault modeling perspective, the heuristic classification supplied is standalone, meaning the table is not mined as a dependent of any hub or link through foreign key structure and can be treated as an independent reference or lookup entity.

Key Information Stored

The documented structure exposes a small, tightly constrained set of columns typical of an Oracle translation table:

  • IP_TYPE – The identifier of the right (intellectual property) type. This is the business-key component joining back to the base proposition type definition and forms part of the composite primary key.
  • LANGUAGE – The language code (for example, US for American English) that identifies the translation row. It completes the composite primary key.
  • Language-dependent descriptive columns (such as the translated name and description of the right type) that the metadata does not enumerate explicitly; in standard Oracle _TL design these carry the user-facing text per language.
  • Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) inherited from the Oracle Applications schema conventions.

The primary key OKR_PROP_TYPES_TL_PK is defined on the composite of (IP_TYPE, LANGUAGE), which is the documented unique index and the surrogate/business composite key for this object. No separate single-column surrogate key is documented. Because the key is composite and language-scoped, queries must always constrain or join on both columns to avoid returning multiple language rows for the same right type.

Common Use Cases and Queries

Because this table is obsolete and not implemented in the reference database, its practical use cases are primarily historical, migration-oriented, or analytical when working with legacy OKR data. Typical scenarios include extracting the translated display values for right types, auditing multilingual coverage of seeded types, and validating that every base record has a corresponding translation in each installed language.

A representative query for retrieving descriptive values in a specific language:

  • SELECT ip_type, language, name, description FROM okr_prop_types_tl WHERE language = USERENV('LANG') ORDER BY ip_type;

A completeness check comparing base and translation rows:

  • SELECT b.ip_type FROM okr_prop_types_b b LEFT JOIN okr_prop_types_tl t ON b.ip_type = t.ip_type AND t.language = 'US' WHERE t.ip_type IS NULL;

Reporting use cases include language coverage matrices, migration mapping between legacy OKR right-type codes and successor contract or licensing structures, and reference-data extracts for data warehouse dimension loads where the right type name is the desired label.

Related Objects

The most significant related objects are the base and dependent entities that share the IP_TYPE identifier and the language framework:

  • OKR_PROP_TYPES_B – The base (non-translated) table holding language-independent definition of right types; joined on IP_TYPE.
  • OKR_PROP_TYPES_VL – The standard Oracle view that joins _B and _TL to present translated values in the session language.
  • OKR_PROP_TYPES_TL_PK – The primary key constraint/index on (IP_TYPE, LANGUAGE) enforcing uniqueness of translations.
  • FND_LANGUAGES – The language reference table validating values in the LANGUAGE column.
  • Successor licensing or contract reference tables used during migration from the obsolete OKR data model.

Given the obsolete status and absence of documented foreign key relationships beyond the composite primary key, the object should be treated as a standalone reference satellite when modeling, joined to its base table solely through the shared IP_TYPE business key.