Search Results imported_lag




Overview
Explore in AI Chat

Overview

PA_STRUC_ASSOCIATIONS_V is an APPS-owned database view within the Oracle E-Business Suite Projects (PA) product family. It exposes information about the relationships between project structure elements by joining the relationship records held in PA_OBJECT_RELATIONSHIPS against project, task, and structure definition data. The view is documented in ETRM metadata for EBS 12.1.1 and 12.2.2 with a status of VALID and carries an explicit annotation of "For future use," which indicates that Oracle has not positioned it as a fully supported, end-user-facing interface. Its primary purpose is to resolve low-level relationship records into a readable, denormalized presentation that includes project identifiers, task and element numbers, element versions, and scheduling-related attributes such as lag day and the imported lag flag.

Because the view consolidates relationship data with project and structural hierarchy context, it is relevant to reporting and integration scenarios where an application or user needs to understand how project structure elements relate to one another. The inclusion of the IMPORTED_LAG column is notable: this attribute typically indicates that a lag value associated with a predecessor/successor relationship was imported from an external scheduling source rather than entered manually, which is a common consideration in projects that integrate with Primavera or similar scheduling tools.

The view is defined as a UNION of two SELECT statements. The first branch resolves relationships where the "to" object is a task and the structure context is available through a parent structure version. The second branch handles relationships where the "from" element is directly linked to a structure version, exposing null placeholders for the "to" task columns. Both branches filter on RELATIONSHIP_TYPE = 'A' and exclude records tied to project ID zero.

Underlying Base Objects

The view is defined over five base objects, all accessed via APPS synonyms:

The join paths differ between the two UNION branches. The first branch anchors on OBJECT_ID_TO1 = PV2.ELEMENT_VERSION_ID and traverses upward through PARENT_STRUCTURE_VERSION_ID to PV1 and EVS. The second branch anchors OBJECT_ID_TO1 directly to PV1.ELEMENT_VERSION_ID, producing a flatter result for structure-level associations.

Key Columns

  • OBJECT_RELATIONSHIP_ID — primary identifier of the relationship row.
  • PROJECT_ID, SEGMENT1, NAME — project identity and display name.
  • PROJ_ELEMENT_ID, ELEMENT_NUMBER, NAME — the "from" element definition.
  • ELEMENT_VERSION_ID, VERSION_NUMBER — the structure/version context.
  • OBJECT_ID_FROM1 — the originating object of the relationship.
  • RELATIONSHIP_TYPE, RELATIONSHIP_SUBTYPE — classification of the association, restricted to type 'A'.
  • LAG_DAY — the time offset (in days) between related elements.
  • IMPORTED_LAG — flag or value indicating lag was imported from an external source rather than entered natively.
  • PRIORITY, PM_PRODUCT_CODE, RECORD_VERSION_NUMBER — scheduling priority, owning product, and optimistic locking version.

In the second UNION branch, ELEMENT_VERSION_ID for the "to" side, VERSION_NUMBER, and ELEMENT_NUMBER columns are emitted as TO_NUMBER(NULL) and NULL respectively, since no corresponding "to" task exists for structure-level associations.

Common Use Cases and Queries

Typical uses include validating imported scheduling relationships, auditing lag values, and reporting on task associations for a given project. Because the view is marked "for future use," queries should be treated as diagnostic or investigative rather than as a stable integration contract. A filtered query isolating imported lag is illustrative:

  • SELECT project_id, element_number, relationship_type, lag_day, imported_lag FROM pa_struc_associations_v WHERE imported_lag IS NOT NULL;
  • Identify relationships associated with a specific project: SELECT * FROM pa_struc_associations_v WHERE project_id = :project_id;
  • Audit negative or unusually large lags: SELECT * FROM pa_struc_associations_v WHERE lag_day < 0 OR lag_day > 365;
  • Reconcile imported versus manually entered relationships by comparing IMPORTED_LAG against LAG_DAY and PM_PRODUCT_CODE.

Given the UNION structure and the reliance on PA_OBJECT_RELATIONSHIPS, performance for large project sets may benefit from filtering on PROJECT_ID and restricting the query to the relevant relationship subtype.

  • View: PA_STRUC_ASSOCIATIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_ASSOCIATIONS_V,  object_name:PA_STRUC_ASSOCIATIONS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_ASSOCIATIONS_V view selects the information of the associated object. - For future use ,  implementation_dba_data: APPS.PA_STRUC_ASSOCIATIONS_V , 

  • View: PA_STRUC_PREDECESSORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_PREDECESSORS_V,  object_name:PA_STRUC_PREDECESSORS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_PREDECESSORS_V selects the information of the predecessors. - For future use ,  implementation_dba_data: APPS.PA_STRUC_PREDECESSORS_V , 

  • View: PA_STRUC_SUCCESSORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_SUCCESSORS_V,  object_name:PA_STRUC_SUCCESSORS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_SUCCESSORS_V selects the information of the successors. - For future use ,  implementation_dba_data: APPS.PA_STRUC_SUCCESSORS_V , 

  • View: PA_STRUC_ASSOCIATIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_ASSOCIATIONS_V,  object_name:PA_STRUC_ASSOCIATIONS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_ASSOCIATIONS_V view selects the information of the associated object. - For future use ,  implementation_dba_data: APPS.PA_STRUC_ASSOCIATIONS_V , 

  • View: PA_STRUC_PREDECESSORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_PREDECESSORS_V,  object_name:PA_STRUC_PREDECESSORS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_PREDECESSORS_V selects the information of the predecessors. - For future use ,  implementation_dba_data: APPS.PA_STRUC_PREDECESSORS_V , 

  • View: PA_STRUC_SUCCESSORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_SUCCESSORS_V,  object_name:PA_STRUC_SUCCESSORS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_SUCCESSORS_V selects the information of the successors. - For future use ,  implementation_dba_data: APPS.PA_STRUC_SUCCESSORS_V , 

  • View: PA_STRUC_PARENT_LINKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_PARENT_LINKS_V,  object_name:PA_STRUC_PARENT_LINKS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_PARENT_LINKS_V selects the parent object information of a link. - For future use ,  implementation_dba_data: APPS.PA_STRUC_PARENT_LINKS_V , 

  • View: PA_STRUC_PARENT_LINKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_PARENT_LINKS_V,  object_name:PA_STRUC_PARENT_LINKS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_PARENT_LINKS_V selects the parent object information of a link. - For future use ,  implementation_dba_data: APPS.PA_STRUC_PARENT_LINKS_V , 

  • View: PA_STRUC_CHILD_LINKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_CHILD_LINKS_V,  object_name:PA_STRUC_CHILD_LINKS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_CHILD_LINKS_V selects the child object information of a link. - For future use ,  implementation_dba_data: APPS.PA_STRUC_CHILD_LINKS_V , 

  • View: PA_STRUC_CHILD_LINKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_STRUC_CHILD_LINKS_V,  object_name:PA_STRUC_CHILD_LINKS_V,  status:VALID,  product: PA - Projects ,  description: PA_STRUC_CHILD_LINKS_V selects the child object information of a link. - For future use ,  implementation_dba_data: APPS.PA_STRUC_CHILD_LINKS_V ,