Search Results okr_classifications

Overview

OKR_CLASSIFICATIONS is a reference (lookup) table within the Oracle E-Business Suite OKR module, historically known as Contracts for Rights. The module provided functionality for managing intellectual property contracts, royalties, and rights agreements, primarily for media, publishing, and entertainment organizations. OKR_CLASSIFICATIONS defines a method of classifying an Intellectual Property based on the nature of its content. In practical terms, it stores the valid classification values that can be assigned to an intellectual property record, segmented by IP type and classification type.

The ETRM metadata explicitly identifies this object as obsolete, and its Implementation/DBA Data note confirms it is "Not implemented in this database." This indicates the table may exist in some legacy Oracle EBS 12.1.1 or 12.2.2 environments only if the OKR module was installed and configured, and even then, it may not be populated or actively used. Readers should confirm physical existence via ALL_TABLES or DBA_TABLES before writing dependent SQL. From a modeling perspective, the heuristic Data Vault classification is satellite-leaning, meaning the table functions primarily as a descriptive attribute set keyed to one or more parent entities rather than as an independent hub or an associative link between multiple hubs.

Key Information Stored

The primary key, OKR_CLASSIFICATIONS_PK, is a composite key comprising IP_TYPE, CLSF_TYPE, and CLSF_CODE. These three columns are the only business-significant columns documented in the ETRM metadata excerpt, and together they define the grain of each row.

• IP_TYPE — The intellectual property type. This column is part of the composite primary key and is also the foreign key column referencing OKR_CLSF_TYPES. It segments classification values by the category of intellectual property to which they apply.
• CLSF_TYPE — The classification type. Part of the composite primary key, it groups classification codes into named categories so that multiple classification schemes can coexist for the same IP type.
• CLSF_CODE — The classification code. Part of the composite primary key, this is the actual value assigned to an intellectual property to describe the nature of its content.

No surrogate system-generated identifier is documented for this table; the primary key is entirely composed of business-key columns. Additional descriptive columns, such as a description or enabled flag, are commonly present in EBS reference tables of this pattern but are not confirmed by the documented metadata and should be verified against the actual data dictionary.

Common Use Cases and Queries

Typical reporting scenarios involve listing all valid classifications for a given IP type, validating that a code exists before assignment, and joining classification values to intellectual property records for descriptive reporting. A straightforward validation query against the composite key is shown below.

• List all classifications for a specific IP and classification type: SELECT clsf_code FROM okr_classifications WHERE ip_type = :ip_type AND clsf_type = :clsf_type ORDER BY clsf_code;
• Verify a specific code exists: SELECT COUNT(*) FROM okr_classifications WHERE ip_type = :ip_type AND clsf_type = :clsf_type AND clsf_code = :clsf_code;
• Join to the parent classification types table to retrieve the grouping context: SELECT c.ip_type, c.clsf_type, c.clsf_code FROM okr_classifications c, okr_clsf_types t WHERE c.ip_type = t.ip_type;

Because the table is marked obsolete and unimplemented, these patterns serve primarily as documentation of legacy behavior. Migration or historical-data projects that encounter OKR_CLASSIFICATIONS should extract the classification values into the target system's own reference data structures rather than relying on live lookups.

Related Objects

The documented foreign-key relationship is limited to a single parent table, but downstream consumers of classification values are numerous in a fully installed OKR environment.

• OKR_CLSF_TYPES — The parent reference table. OKR_CLASSIFICATIONS.IP_TYPE references this table, establishing the IP type context for each classification value.
• Intellectual property master tables — Records describing intellectual properties typically store a classification code that resolves to OKR_CLASSIFICATIONS.CLSF_CODE, making this table a dependent lookup.
• Contract and rights tables — Contract records that reference an intellectual property inherit its classification for reporting and royalty calculations.
• OKR module concurrent programs and forms — The Contracts for Rights forms and validation routines consume this table as a list-of-values source during data entry.
• Reporting views and BI extracts — Customized or seeded views that denormalize intellectual property attributes may join OKR_CLASSIFICATIONS to present human-readable classification descriptions.

Given the obsolete status, administrators should treat references to OKR_CLASSIFICATIONS as candidates for decommissioning and confirm object existence before building any dependency on it.