Search Results ip_id




Overview
Explore in AI Chat

Overview

OKR_IP_COMBINATIONS_V is a database view historically shipped with the Oracle Contracts for Rights (OKR) module, a component of the Oracle E-Business Suite verticalized intellectual property and rights management solution. The view is classified within the ETRM documentation under the OKR – Contracts for Rights (Obsolete) product family, indicating it belongs to a product line that Oracle has since desupported. Within Oracle EBS 12.1.1 and 12.2.2, the view presents intellectual property (IP) combination records — the association between an intellectual property identifier and its parent contract or rights collection (CBN) identifier — in a denormalized, query-friendly form. Its role in reporting and integration is to expose the combination assignments stored in the underlying OKR_IP_COMBINATIONS table so that concurrent programs, BI Publisher reports, OAF pages, and custom extracts can resolve the relationships between IP masters and the containers that group them without joining to additional associative structures.

Underlying Base Objects

According to the documented view text, OKR_IP_COMBINATIONS_V is defined entirely over a single base table, OKR_IP_COMBINATIONS, aliased as ICN in the SELECT statement. No joins, unions, or aggregations are present; every column in the view is a direct projection of a corresponding column in the base table. The ETRM metadata explicitly states "Referenced base objects: none documented," which reflects the fact that the view's dependency is limited to the OKR_IP_COMBINATIONS table, itself part of the OKR schema. Because the view adds no filtering or transformation logic, it behaves as a thin presentation layer, exposing the base table's rows verbatim. Notably, the same metadata records "Not implemented in this database" for the view, meaning that in many EBS instances — particularly those without the OKR product licensed or installed — the object does not exist at all, and any code referencing it will fail unless the OKR schema has been provisioned.

Key Columns

  • IP_ID — The primary intellectual property identifier. This is the column most frequently searched for (the user query "ip_id"), and it links the combination row to the IP master record.
  • CBN_ID — The container identifier representing the contract, bundle, or rights collection to which the IP is assigned within the combination.
  • OBJECT_VERSION_NUMBER — The standard EBS optimistic locking column used to detect concurrent updates.
  • CREATED_BY, CREATION_DATE — Standard WHO audit columns recording the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — WHO audit columns capturing the last modifying user, timestamp, and login session.

Common Use Cases and Queries

Typical usage centers on resolving which IP records belong to a given combination, or which combination contains a specific IP. A representative query is:

SELECT ip_id, cbn_id FROM okr_ip_combinations_v WHERE ip_id = :ip_id;

Integration scenarios frequently use the view to drive inbound or outbound interfaces that synchronize IP-to-contract mappings with external rights management systems. Reporting use cases include IP inventory reports grouped by CBN_ID, and audit extracts that leverage the WHO columns to track combination changes over time. Because the OKR module is obsolete and the view is unimplemented in most databases, developers should confirm object existence in ALL_VIEWS before authoring dependent code, and should plan migration paths away from OKR_IP_COMBINATIONS_V in favor of supported alternatives.