Search Results pa_proj_structure_types




Overview
Explore in AI Chat

Overview

PA_PROJ_STRUCTURE_TYPES is a table in the Oracle Projects (PA) schema that stores structure type assignments for a particular project structure. According to Oracle EBS documentation, the object is designated as being for future use, meaning it is a reserved or staging construct rather than a heavily utilized transactional table in the standard projects data model. It is classified as VALID in the ETRM 12.2.2 metadata and contains 25 documented columns.

In the broader Oracle EBS Projects architecture, this table sits adjacent to the project element and structure hierarchies. It links project elements (via PROJ_ELEMENT_ID) to structure types (via STRUCTURE_TYPE_ID), which are defined in the Oracle Bills of Material module's BOM_STRUCTURE_TYPES_B table. This cross-module dependency reflects the intent to reuse BOM structure type definitions within the Projects context.

From a Data Vault modeling perspective, the heuristic classification is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite attached to one or more parent hubs or links (PA_PROJ_ELEMENTS and BOM_STRUCTURE_TYPES_B), holding attribute context rather than acting as a central hub or associative link on its own.

Key Information Stored

The table's most significant columns fall into three categories:

  • PROJ_STRUCTURE_TYPE_ID — The surrogate primary key, enforced by unique index PA_PROJ_STRUCTURE_TYPES_U1.
  • PROJ_ELEMENT_ID — A foreign key to PA_PROJ_ELEMENTS, identifying the project element with which the structure type is associated.
  • STRUCTURE_TYPE_ID — A foreign key to BOM_STRUCTURE_TYPES_B, referencing the structure type definition sourced from Oracle Bills of Material.
  • Combined business key — The unique index PA_PROJ_STRUCTURE_TYPES_U2 on (PROJ_ELEMENT_ID, STRUCTURE_TYPE_ID) establishes the natural business key, ensuring that a given element is not assigned the same structure type more than once.
  • Standard audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and RECORD_VERSION_NUMBER provide the customary Oracle EBS who/when audit trail and optimistic locking support.
  • Descriptive flexfield (DFF) columns — ATTRIBUTE_CATEGORY plus ATTRIBUTE1 through ATTRIBUTE15 supply the extensibility framework allowing customers to add context-specific attributes without schema changes.

Common Use Cases and Queries

Because the table is documented as reserved for future use, production query patterns are limited. Nonetheless, the following scenarios illustrate its intended utility:

  • Identifying which structure types are assigned to a given project element:
    SELECT structure_type_id FROM pa.pa_proj_structure_types WHERE proj_element_id = :element_id;
  • Joining to BOM structure type definitions to retrieve descriptive names:
    SELECT pst.proj_element_id, bst.structure_type_name FROM pa.pa_proj_structure_types pst, bom.bom_structure_types_b bst WHERE pst.structure_type_id = bst.structure_type_id;
  • Reporting on DFF attribute usage for custom structure type categorization.
  • Auditing change history through the standard audit columns for reconciliation or compliance purposes.

Integrators and report developers should treat the table cautiously, verifying against the target instance whether records are actively populated before building dependencies on it.

Related Objects

  • PA_PROJ_ELEMENTS — Referenced via PROJ_STRUCTURE_TYPES.PROJ_ELEMENT_ID; the parent table defining project elements.
  • BOM_STRUCTURE_TYPES_B — Referenced via PROJ_STRUCTURE_TYPES.STRUCTURE_TYPE_ID; the base table of structure types from Oracle Bills of Material.
  • PA_PROJ_ELEMENTS_B / _TL — Base and translation tables underpinning the project element hierarchy.
  • BOM_STRUCTURE_TYPES_TL — Translation table supplying language-specific structure type descriptions.
  • PA_PROJECTS_ALL — The principal project master table, indirectly relevant through the element hierarchy.
  • PA_PROJECT_STRUCTURES and related structure views — consume element/structure relationships in the projects model.
  • Public Projects APIs (for example, the Project Structure and Element APIs) — potential programmatic access points for maintaining structure type assignments.