Results for “okr_ip_films_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKR_IP_FILMS_B is a table within the Oracle E-Business Suite module OKR — Contracts for Rights, a component historically associated with media, publishing, and intellectual property rights management. The table is documented as storing Film Intellectual Property records. Its description, "Film Intellectual Property," indicates that rows in this table represent the film-specific attribute set of an intellectual property asset managed within the rights contracts framework.

The ETRM metadata explicitly classifies this object as Obsolete and notes that it is not implemented in this database. This is a critical caveat: in Oracle EBS 12.1.1 and 12.2.2 environments where the OKR module was never licensed or deployed, the table will not exist at all. Even in environments where OKR was installed, the object may be absent or unsupported in the shipped schema. Consultants encountering references to OKR_IP_FILMS_B should first verify physical existence via ALL_TABLES or DBA_TABLES before writing any dependent logic.

From a data modeling perspective, the metadata's heuristic Data Vault classification is satellite-leaning. This suggests that OKR_IP_FILMS_B functions as a descriptive satellite attached to a parent hub: the film-specific attributes of an intellectual property record whose core identity is held elsewhere (in OKR_IP_COMMON_B). Analysts designing integration or warehouse models should treat it as an attribute-bearing child, not as an independent entity.

Key Information Stored

The documented metadata identifies a single explicit column plus its key structure:

• IP_ID — The sole documented column. It is both the primary key of OKR_IP_FILMS_B (constraint OKR_IP_FILMS_B_PK) and a foreign key referencing OKR_IP_COMMON_B.IP_ID. Semantically, IP_ID is the intellectual property identifier inherited from the parent common table.

Because the metadata lists only IP_ID, no business-key columns or secondary unique indexes are documented for this table. Available knowledge of the OKR schema suggests that a film satellite of this type would typically carry attributes such as film title, release date, runtime, format, territory, and language, but none of these are confirmed by the ETRM excerpt and therefore should not be assumed. The distinguishing structural fact is that IP_ID serves as both the surrogate primary key and the foreign key to the parent — a shared-primary-key pattern characteristic of a dependent satellite table.

Common Use Cases and Queries

The principal use case is joining film-level attributes back to the common IP record to build a consolidated intellectual property view. A representative pattern, assuming the table exists, would be:

• SELECT c.ip_id, f.* FROM okr_ip_common_b c, okr_ip_films_b f WHERE c.ip_id = f.ip_id;

Because IP_ID is the shared key, queries can enumerate films by selecting only from OKR_IP_FILMS_B and resolving descriptive detail through the parent. Reporting scenarios include rights-availability listings by film, catalog reconciliation between OKR_IP_COMMON_B and its film subtype, and data migration validation when extracting legacy OKR content into external rights or media asset management systems.

Given the obsolete status, a practical first step in any analysis is a metadata probe:

• SELECT table_name, num_rows FROM all_tables WHERE table_name = 'OKR_IP_FILMS_B';

If this returns no rows, the object is unavailable and any historical OKR film data must be sourced from archival extracts rather than the live EBS schema. Reporting teams should also check for corresponding _TL or _ALL variants, though none are documented here.

Related Objects

The documented foreign key relationship defines the primary dependency:

• OKR_IP_COMMON_B — The parent table holding the common intellectual property record. Join column: OKR_IP_FILMS_B.IP_ID = OKR_IP_COMMON_B.IP_ID. This is the definitive relationship supplied by the ETRM metadata.
• OKR_IP_FILMS_B_PK — The primary key constraint on IP_ID, relevant when validating or disabling constraints during data migration.

Additional OKR subtype tables (such as those for other IP categories within the same Contracts for Rights family) likely share the identical IP_ID-to-OKR_IP_COMMON_B pattern, following the standard EBS subtype/satellite convention. However, these are not enumerated in the supplied metadata and should be confirmed against the actual schema dictionary. In environments where OKR is obsolete or uninstalled, the practical set of related objects is limited to OKR_IP_COMMON_B and the constraint definitions documented above.