Search Results okr_valid_prop_rgts




Overview
Explore in AI Chat

Overview

The OKR_VALID_PROP_RGTS table is a configuration reference object within the Oracle E-Business Suite (EBS) OKR — Contracts for Rights module. As documented in the ETRM metadata, its stated purpose is to defines which Rights Types are sensible for a certain Property Type. In practical terms, it acts as a cross-reference or validation matrix that constrains the combinations of Property Types and Rights Types that may be associated within a rights contract. When a user selects a Property Type during contract or rights setup, this table governs which Rights Types are surfaced as valid choices, thereby enforcing business rules at the data-model level rather than solely in the user interface.

It should be noted that the OKR module is identified in the metadata as Obsolete, and the table is marked "Not implemented in this database." Consequently, references to this object in Oracle EBS 12.1.1 or 12.2.2 are typically found in legacy code, historical schemas, or documentation rather than in active installs. The heuristic Data Vault classification, mined from the foreign key structure, describes this table as satellite-leaning. That classification suggests it is best modeled as a satellite table attached to a hub or link, holding descriptive validation attributes about the relationship between Property Types and Rights Types rather than representing an independent business entity.

Key Information Stored

The documented metadata identifies a limited but precise set of columns. The most important are:

  • ID — The surrogate primary key, enforced by the constraint OKR_VPR_PK. It uniquely identifies each valid Property-Type/Rights-Type pairing row.
  • IP_TYPE — The Property Type identifier. This is a business-key component and part of the unique constraint OKR_VPR_UK. It is also a foreign key to OKR_PROP_TYPES_B.
  • RGTP_ID — The Rights Type identifier. This is the second business-key component in OKR_VPR_UK and a foreign key to OKR_RIGHT_TYPES_B.

The combination of IP_TYPE and RGTP_ID forms the unique business key (OKR_VPR_UK), establishing that any given Property Type may be associated with each Rights Type at most once. The surrogate ID exists primarily to support foreign key references from dependent tables, notably OKR_IP_UDEF_DIM_B.VAL_PTRT_ID.

Common Use Cases and Queries

Because this table enforces a validation matrix, typical usage involves confirming that a chosen Rights Type is permitted for a given Property Type before contract creation or rights assignment. A representative query returning all valid Rights Types for a specific Property Type would be:

  • SELECT vpr.ID, vpr.IP_TYPE, vpr.RGTP_ID FROM OKR_VALID_PROP_RGTS vpr WHERE vpr.IP_TYPE = :p_property_type;

Reporting scenarios include generating a completeness matrix of Property Types against Rights Types, auditing which combinations are configured, and identifying gaps where a Property Type has no associated Rights Types. A validation query used during data entry might test existence:

  • SELECT COUNT(*) FROM OKR_VALID_PROP_RGTS WHERE IP_TYPE = :p_prop AND RGTP_ID = :p_rgtp;

Since the module is obsolete, these patterns are most relevant to historical data migration, archival analysis, or code remediation rather than day-to-day operations.

Related Objects

The foreign key relationships documented in the metadata define the principal related objects:

  • OKR_PROP_TYPES_B — Referenced via OKR_VALID_PROP_RGTS.IP_TYPE; the master list of Property Types.
  • OKR_RIGHT_TYPES_B — Referenced via OKR_VALID_PROP_RGTS.RGTP_ID; the master list of Rights Types.
  • OKR_IP_UDEF_DIM_B — References this table through the column VAL_PTRT_ID, depending on OKR_VALID_PROP_RGTS for its valid property/rights combinations.

These three tables constitute the documented dependency graph. Any query reconstructing the full validation context would join OKR_VALID_PROP_RGTS to OKR_PROP_TYPES_B on IP_TYPE and to OKR_RIGHT_TYPES_B on RGTP_ID to resolve human-readable names.