Results for “okr_ip_awds_won_b”

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

Overview

OKR_IP_AWDS_WON_B is a table within the OKR (Contracts for Rights) product family in Oracle E-Business Suite. The module is designated as obsolete, and the ETRM metadata explicitly states that the object is "not currently used." This is corroborated by the implementation note that the table is "Not implemented in this database," indicating that it does not exist in typical 12.1.1 or 12.2.2 environments unless a legacy or customized installation has retained it. The "_B" suffix follows the standard Oracle EBS convention for a base table, usually implying the existence of a corresponding "_TL" translation table, though no such companion is documented here.

Functionally, the table was intended to store records of intellectual property awards won, associating award events with the underlying IP and the parties involved. In Data Vault terms, the documented FK structure suggests this object is satellite-leaning: it carries descriptive attributes (award code, award date) that qualify an IP record held in OKR_IP_COMMON_B, rather than acting as an independent hub of business entities. This classification should be treated as a modeling suggestion rather than a confirmed architectural designation.

Key Information Stored

The documented metadata identifies the following significant columns:

• AWN_ID — The surrogate primary key, enforced by the OKR_AWARDS_WON_B_PK constraint. This is the internal identifier for an award record.
• IP_ID — Foreign key to OKR_IP_COMMON_B, linking the award to its parent intellectual property record. This is also part of the unique key OKR_AWARDS_WON_B_UK.
• PARTY_ID1 and PARTY_ID2 — Party identifiers representing the participants in the award, such as the granting and receiving parties. These are documented as part of the unique index components.
• AWARD_CODE — A business-meaningful code describing the award, and part of the documented unique key set.
• AWARD_DATE — The date the award was granted, also documented within the unique key definition.

The unique index OKR_AWARDS_WON_B_UK spans IP_ID, PARTY_ID1, PARTY_ID2, AWARD_CODE, and AWARD_DATE, making this composite the business-key candidate set. The surrogate AWN_ID is distinct from these business keys by design.

Common Use Cases and Queries

Because the table is obsolete and unimplemented, direct querying is unlikely in supported environments. Historically, it would have supported reporting on awards associated with IP contracts. A representative pattern, assuming implementation, would join to the parent IP table:

• Listing all awards for a given IP: SELECT a.award_code, a.award_date FROM okr_ip_awds_won_b a, okr_ip_common_b c WHERE a.ip_id = c.ip_id AND c.ip_id = :ip_id;
• Identifying distinct parties involved in awards: SELECT DISTINCT party_id1, party_id2 FROM okr_ip_awds_won_b WHERE award_date BETWEEN :start_date AND :end_date;
• Lookup by business key: querying by IP_ID, party, code, and date to retrieve the AWN_ID surrogate.

Any development against this table should be preceded by verifying its existence, since the metadata confirms it is not implemented in a standard database.

Related Objects

The most significant related object is the parent table referenced by the documented foreign key:

• OKR_IP_COMMON_B — Joined on IP_ID; holds the master IP record that each award qualifies.
• OKR_AWARDS_WON_B_PK — The primary key constraint on AWN_ID.
• OKR_AWARDS_WON_B_UK — The unique key constraint enforcing the business key across IP_ID, PARTY_ID1, PARTY_ID2, AWARD_CODE, and AWARD_DATE.

Given the obsolete status, no active APIs or dependent views are documented for this object.