Search Results object_id_to2




Overview
Explore in AI Chat

Overview

PA_OBJECT_RELATIONSHIPS is a core Oracle Projects (PA) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores every relationship between projects, project structures, and tasks. It is the central repository that models how project elements relate to one another — such as a task rolling up to a parent task, a structure referencing a project, or a control item being associated with a project element. Because a single project can participate in many concurrent structures and hierarchical arrangements, the table is populated heavily and is one of the most frequently joined objects in Projects reporting.

Its heuristic Data Vault classification is a link. This classification is a modeling suggestion derived from the foreign-key topology: the table resolves many-to-many associations between project objects, positioning it as a relationship (link) entity rather than a descriptive (satellite) entity or a standalone (hub) entity. Each row captures one association, qualified by a relationship type and subtype.

Key Information Stored

The table contains 28 documented columns. The most important include:

Two unique indexes serve as business-key candidates: PA_OBJECT_RELATIONSHIPS_U1 on OBJECT_RELATIONSHIP_ID and PA_OBJECT_RELATIONSHIPS_U2 on the composite of OBJECT_TYPE_FROM, OBJECT_ID_FROM1, OBJECT_ID_FROM2, OBJECT_TYPE_TO, OBJECT_ID_TO1, OBJECT_ID_TO2, and RELATIONSHIP_TYPE. U2 enforces that a given directed relationship is defined only once.

Common Use Cases and Queries

Typical uses include resolving task hierarchies, retrieving structures associated with a project, and reporting dependency lags and weighting percentages. A representative query retrieves all relationships for a given structure or task:

  • SELECT relationship_type, object_type_from, object_id_from1, object_type_to, object_id_to1, weighting_percentage FROM pa_object_relationships WHERE object_id_from1 = :task_id AND relationship_type = :type;
  • Join to PA_PROJ_ELEMENT_VERSIONS to resolve element descriptions for reporting on project structures.
  • Join to PA_CONTROL_ITEMS to associate control items with their linked project elements.

Reporting scenarios commonly aggregate weighting percentages across a structure or reconstruct dependency chains using LAG_DAY for scheduling and earned-value analysis.

Related Objects

  • PA_CONTROL_ITEMS — referenced via OBJECT_ID_TO1 and OBJECT_ID_FROM1 foreign keys; links control items to project objects.
  • PA_PROJ_ELEMENT_VERSIONS — referenced via OBJECT_ID_FROM1 and OBJECT_ID_TO1; provides versioned project element detail.
  • PA_STRUCTURES_TASKS_TMP — references PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID, used in structure/task processing.
  • PA_OBJECT_RELATIONSHIPS_PK — the primary key constraint enforcing uniqueness on OBJECT_RELATIONSHIP_ID.
  • PA_OBJECT_RELATIONSHIPS_U1 / _U2 — unique indexes supporting business-key lookups.