Search Results okr_ip_common_b_uk




Overview
Explore in AI Chat

Overview

OKR_IP_COMMON_B is the base table within the Oracle E-Business Suite Contracts for Rights (OKR) module responsible for storing intellectual property (IP) master records. In Oracle EBS 12.1.1 and 12.2.2, this table functions as the central repository from which all IP-related information is anchored, including the various IP subtypes, rights holdings, classifications, and party relationships that make up the contracts-for-rights data model.

The metadata indicates that this object is documented under OKR - Contracts for Rights, which is flagged as obsolete in the ETRM taxonomy. The implementation note states "Not implemented in this database," meaning the table may not exist in a given environment if the OKR module is not licensed or installed. This is a critical caveat for any developer or DBA querying the object.

From a data modeling perspective, the heuristic Data Vault classification applied to this table is hub-leaning. This classification reflects that OKR_IP_COMMON_B contains a single, stable surrogate key (IP_ID) that many dependent tables reference. That structure maps well to a Data Vault hub, with the surrounding tables functioning as satellites or links that carry descriptive and relational attributes.

Key Information Stored

The metadata documents only a small number of specific columns for this table, so the following reflects the documented attributes rather than an exhaustive listing:

  • IP_ID — The surrogate primary key, enforced by the constraint OKR_IP_COMMON_B_PK. This column uniquely identifies each intellectual property record and is the primary join point used by every dependent table.
  • IP_IDENTIFIER — The business-key candidate, enforced by the unique constraint OKR_IP_COMMON_B_UK. This is the human-recognizable identifier for the IP record, distinct from the internal surrogate key.
  • IP_TYPE — A foreign key referencing OKR_PROP_TYPES_B, which classifies each IP record by its proposition or property type. This column determines the nature and categorization of the intellectual property.

The distinction between the surrogate key (IP_ID) and the unique business key (IP_IDENTIFIER) is significant for integration work. External systems and interfaces typically exchange the IP_IDENTIFIER value, while internal referential integrity relies on IP_ID.

Common Use Cases and Queries

Because OKR_IP_COMMON_B acts as the hub for IP records, the most common query pattern is a lookup by IP_ID joined to one or more dependent tables. For example, retrieving the base IP record alongside its type description from OKR_PROP_TYPES_B and its associated rights in OKR_IP_RGTS_B is a typical reporting requirement.

A representative SQL pattern follows:

  • SELECT ip.IP_ID, ip.IP_IDENTIFIER, pt.PROP_TYPE, r.RGHT_ID FROM OKR_IP_COMMON_B ip, OKR_PROP_TYPES_B pt, OKR_IP_RGTS_B r WHERE ip.IP_TYPE = pt.PROP_TYPE AND ip.IP_ID = r.IP_ID;

Other common scenarios include traversing relationships between IP records via OKR_IP_RELATIONS_B (both FROM_IP_ID and TO_IP_ID join back to this table), enumerating media publications through OKR_IP_PUB_MEDIA, and analyzing classifications via OKR_IP_CLASSIFICATIONS. Data warehousing extracts frequently select IP_ID and IP_IDENTIFIER from this table as the core dimension for any IP-centric fact table.

Related Objects

The table participates in an extensive foreign-key web, with many child tables referencing IP_ID. The most significant related objects, based on the documented relationship data, include:

  • OKR_PROP_TYPES_B — Referenced by OKR_IP_COMMON_B.IP_TYPE; defines the IP type classification.
  • OKR_IP_RGTS_B — References OKR_IP_COMMON_B.IP_ID; stores rights associated with an IP record.
  • OKR_IP_RELATIONS_B — References OKR_IP_COMMON_B through both FROM_IP_ID and TO_IP_ID; models relationships between IP records.
  • OKR_IP_CLASSIFICATIONS — References OKR_IP_COMMON_B.IP_ID; holds classification assignments.
  • OKR_IP_PUB_MEDIA — References OKR_IP_COMMON_B.IP_ID; tracks publication and media links.
  • OKR_IP_PARTY_RELS_B — References OKR_IP_COMMON_B.IP_ID; stores party relationships tied to the IP.
  • OKR_IP_AWDS_WON_B — References OKR_IP_COMMON_B.IP_ID; records awards won by the IP.
  • OKR_TEMPLATE_RGTS_B — References OKR_IP_COMMON_B.IP_ID; links templates to rights for IP records.

Additional dependent tables such as OKR_IP_FILMS_B, OKR_IP_LITWORKS_B, OKR_IP_PHOTOS_B, and OKR_IP_SOFTWARE_B represent IP subtypes keyed to this hub, reinforcing its role as the central anchor for the Contracts for Rights IP data model.