Search Results okr_ip_classifications_pk

Overview

OKR_IP_CLASSIFICATIONS is a table within the Oracle E-Business Suite Contracts for Rights (OKR) module, a component of the Oracle ETRM (Enterprise Trade and Risk Management) family. The module itself carries the designation "Obsolete," and the table is explicitly documented as "Not implemented in this database." This status indicates that OKR_IP_CLASSIFICATIONS is a legacy schema object retained for historical or upgrade compatibility purposes rather than an actively populated table in current EBS 12.1.1 or 12.2.2 installations.

Functionally, the table stores valid classification codes for a given IP (Intellectual Property) type and classification type combination. It acts as a validation and reference source, ensuring that classification values assigned to intellectual property records conform to the allowable set defined for each combination of IP type and classification type. This makes it a supporting lookup object within the broader Contracts for Rights data model, which governs licensing, royalties, and rights management scenarios.

Applying a heuristic Data Vault classification based on the mined foreign key structure, this table exhibits satellite-leaning characteristics. It carries a surrogate identifier as its primary key and references a parent entity through a foreign key, with descriptive classification attributes attached. Modelers should treat it as a descriptive satellite hanging off the OKR_IP_COMMON_B hub rather than as a hub or link in its own right.

Key Information Stored

The documented metadata identifies a deliberately narrow column set, reflecting the table's role as a validation reference rather than a transactional store. The most significant columns and their roles are as follows:

• ID — The surrogate primary key, enforced through the constraint OKR_IP_CLASSIFICATIONS_PK. This column uniquely identifies each classification row and is system-generated, carrying no business meaning on its own.
• IP_ID — A foreign key column referencing OKR_IP_COMMON_B. This column anchors each classification record to a specific intellectual property master record, establishing the parent-child relationship that gives the table its satellite character.
• Classification code and classification type columns — The table is documented as holding classification codes qualified by classification type, though the metadata excerpt does not name these columns individually. In practice, the code column holds the permitted value, while the type column distinguishes the category under which that code is valid.

No unique business-key indexes beyond the primary key are documented in the supplied metadata. The pairing of IP_ID with the classification attributes effectively constitutes the natural business key candidate, but this is not confirmed by a documented unique constraint.

Common Use Cases and Queries

Because the table is not implemented in the database, direct querying against a live EBS instance will typically fail or return no rows. Its principal use cases are therefore analytical and migration-oriented rather than operational.

• Upgrade and migration assessment — Consultants auditing legacy OKR customizations frequently inspect this table's definition to determine whether historical classification data must be migrated to a successor object.
• Data model documentation — The table appears in ER diagrams illustrating how IP classification validation was originally modeled against OKR_IP_COMMON_B.
• Impact analysis — Identifying custom reports or interfaces that once referenced OKR_IP_CLASSIFICATIONS prior to the module's obsolescence.

A representative query pattern, were the table populated, would join it to its parent to resolve classification values per IP record:

SELECT c.ID, c.IP_ID, c.CLASSIFICATION_CODE, c.CLASSIFICATION_TYPE
FROM OKR_IP_CLASSIFICATIONS c, OKR_IP_COMMON_B b
WHERE c.IP_ID = b.IP_ID;

Related Objects

The foreign key metadata identifies one confirmed relationship and implies a small surrounding object set:

• OKR_IP_COMMON_B — The parent table referenced by OKR_IP_CLASSIFICATIONS.IP_ID. This is the primary relationship and the only one explicitly documented. Within Data Vault terms, OKR_IP_COMMON_B functions as the hub against which this satellite attaches.
• OKR_IP_CLASSIFICATIONS_PK — The primary key constraint on ID, which governs uniqueness within the table itself.
• OKR module classification type and IP type reference objects — The table's documented purpose of qualifying codes by IP type and classification type implies dependencies on companion reference tables defining those types, though these are not named in the supplied metadata and should be confirmed against a full data dictionary extract.

Given the module's obsolete status and the table's non-implementation, related object dependencies should be verified against the target EBS version's actual dictionary rather than assumed from legacy documentation.