Search Results okr_ip_udef_dim_b

Overview

OKR_IP_UDEF_DIM_B is a table belonging to the Oracle EBS OKR (Contracts for Rights) product family, which is documented as obsolete in Release 12.1.1 and 12.2.2. The table name suggests a user-defined dimension ("UDEF_DIM") holding descriptive attributes associated with contract rights processing. In the ETRM functional architecture, OKR supported royalty, licensing, and intellectual property contract management; user-defined dimension tables in this family stored flexible, customer-configurable classification values that were subsequently referenced by transactional or agreement-level records.

In the Oracle EBS 12.1.1 / 12.2.2 documentation set, the object is explicitly annotated "Not implemented in this database," meaning that no seeded DDL, indexes, or data exist in a standard installation. It appears only in the documentation as a residual artifact of a legacy design.

From a Data Vault modeling perspective, the FK topology (a single foreign key to OKR_VALID_PROP_RGTS) suggests a satellite-leaning classification. This is a heuristic suggestion only; the table is not a hub or link under that model because it does not appear to own the business key population for the referenced entity.

Key Information Stored

Because the table is not implemented in the database, no physical column list beyond the documented primary key and foreign key is available. The following items are supported by the supplied metadata:

• ID — the surrogate primary key column, defined by constraint OKR_IP_UDEF_DIM_B_PK. This is the sole documented key column and would normally be populated from a sequence or SYS_GUID-based default in EBS.
• VAL_PTRT_ID — the foreign key column referencing OKR_VALID_PROP_RGTS. In the context of the naming convention, this likely stores the identifier of a valid property rights record to which the user-defined dimension applies.

No unique indexes or alternate business keys are documented. Consequently, no business-key candidates can be asserted from the metadata; any such column would have to be identified from a customer-specific or later-release implementation. Columns for effective dates, enabled flags, or multi-language descriptions are typical of dimension tables in this family, but they are not documented here and should not be assumed.

Common Use Cases and Queries

The practical utility of this table in a standard 12.1.1 or 12.2.2 environment is limited, since the object is not created. Reference queries should therefore be treated as illustrative of what a heritage implementation might have executed:

• Joining user-defined dimension rows to their owning property rights record to produce a classification report:

SELECT d.id, d.val_ptrt_id
FROM   okr_ip_udef_dim_b d,
       okr_valid_prop_rgts r
WHERE  d.val_ptrt_id = r.id;

• Confirming object existence in a target instance before attempting extraction:

SELECT object_name, object_type, status
FROM   all_objects
WHERE  object_name = 'OKR_IP_UDEF_DIM_B';

• Impact analysis on custom extensions: any customer view or concurrent program referencing this table will fail if it is not present.

Related Objects

• OKR_VALID_PROP_RGTS — the only documented foreign table; joined on OKR_IP_UDEF_DIM_B.VAL_PTRT_ID = OKR_VALID_PROP_RGTS.ID. This is the principal dependency for the table.
• OKR_IP_UDEF_DIM_B_PK — the primary key constraint on the ID column; relevant for integrity checks and index planning.
• Other OKR user-defined dimension and property-rights tables referenced elsewhere in the OKR data model, which typically share the same naming prefix and are likewise obsolete.
• OKR concurrent programs and Oracle Forms-based setups that historically maintained dimension values; no supported API is documented for this object.

Because the table is unimplemented, integration and migration efforts should treat OKR_IP_UDEF_DIM_B as a documentation-only artifact and confirm actual usage through a metadata audit of the target instance.