Search Results pa_prj_orgs_it




Overview
Explore in AI Chat

Overview

The PA_PRJ_ORGS_IT table is a core data repository within the Oracle E-Business Suite Projects module (PA), specifically designed for the Oracle Project Analysis Collection Pack. This table serves as the master reference for organizations that are enabled for project and task execution. Its primary role is to store and maintain the list of valid organizations that can be assigned as the "carrying out" or "owning" entity for project-related transactions, commitments, and budgets. It functions as a critical dimension table within the data model for analytical reporting and transactional integrity, ensuring that organizational assignments across the Projects module are consistent and validated against a controlled list.

Key Information Stored

While the provided ETRM metadata does not list all column definitions, the structure and relationships indicate the core data elements. The table's primary key is the ORGANIZATION_ID, which uniquely identifies each project-enabled organization. A crucial foreign key is the BUSINESS_GROUP column, which links each organization to its corresponding business group in the PA_PRJ_BUSINESS_GRPS_IT table, enforcing multi-org security and partitioning of data. The table likely contains descriptive columns such as organization name and effective dates, though these are inferred from standard Oracle design patterns. The central purpose of the table is to map internal organization identifiers to their usage context within project analytics.

Common Use Cases and Queries

This table is essential for reports and integrations that require organization-specific project data. A common use case is generating a list of all projects or tasks executed by a particular organization, or validating organizational assignments during data migration. For reporting, it is frequently joined to project and task tables to translate ID values into meaningful names. A typical analytical query pattern involves joining this table to project master data:

It is also critical for data integrity checks, ensuring that organizational references in transactional tables like budgets and commitments exist in this master list.

Related Objects

The PA_PRJ_ORGS_IT table maintains defined relationships with several key transactional and setup tables, as documented in the ETRM metadata. It references the PA_PRJ_BUSINESS_GRPS_IT table via its BUSINESS_GROUP foreign key. More significantly, it is referenced as a parent table in the following relationships, demonstrating its central role:

  • PA_PROJECTS_IT_ALL.CARRYING_OUT_ORGANIZATION_ID: Links to the organization responsible for executing a project.
  • PA_TOP_TASKS_IT.CARRYING_OUT_ORGANIZATION_ID: Links to the organization responsible for executing a top task.
  • PA_PRJ_ACT_CMT_IT_ALL.OWNER_ORGANIZATION_ID: Links to the organization that owns a project-level actual commitment.
  • PA_TSK_ACT_CMT_IT_ALL.OWNER_ORGANIZATION_ID: Links to the organization that owns a task-level actual commitment.
  • PA_PRJ_BGT_LINES_IT_ALL.OWNER_ORGANIZATION_ID: Links to the organization that owns a project budget line.
  • PA_TSK_BGT_LINES_IT_ALL.OWNER_ORGANIZATION_ID: Links to the organization that owns a task budget line.

These relationships underscore that PA_PRJ_ORGS_IT is the authoritative source for organization identifiers used throughout the Project Analysis data model for both master (projects, tasks) and transactional (budgets, commitments) entities.

  • Table: PA_PRJ_ORGS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_ORGS_IT,  object_name:PA_PRJ_ORGS_IT,  status:VALID,  product: PA - Projects ,  description: Information about project/task organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_ORGS_IT , 

  • Table: PA_PRJ_ORGS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_ORGS_IT,  object_name:PA_PRJ_ORGS_IT,  status:VALID,  product: PA - Projects ,  description: Information about project/task organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_ORGS_IT , 

  • Table: PA_TSK_ACT_CMT_IT_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TSK_ACT_CMT_IT_ALL,  object_name:PA_TSK_ACT_CMT_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Task level actuals and commitments for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TSK_ACT_CMT_IT_ALL , 

  • Table: PA_TOP_TASKS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TOP_TASKS_IT,  object_name:PA_TOP_TASKS_IT,  status:VALID,  product: PA - Projects ,  description: Information about the top task level for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TOP_TASKS_IT , 

  • Table: PA_PRJ_BGT_LINES_IT_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_BGT_LINES_IT_ALL,  object_name:PA_PRJ_BGT_LINES_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Information about budgets at the project level for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_BGT_LINES_IT_ALL , 

  • Table: PA_PRJ_BUSINESS_GRPS_IT 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_BUSINESS_GRPS_IT,  object_name:PA_PRJ_BUSINESS_GRPS_IT,  status:VALID,  product: PA - Projects ,  description: Information about business groups for project/task organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_BUSINESS_GRPS_IT , 

  • Table: PA_PRJ_BUSINESS_GRPS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_BUSINESS_GRPS_IT,  object_name:PA_PRJ_BUSINESS_GRPS_IT,  status:VALID,  product: PA - Projects ,  description: Information about business groups for project/task organizations for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_BUSINESS_GRPS_IT , 

  • Table: PA_TOP_TASKS_IT 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TOP_TASKS_IT,  object_name:PA_TOP_TASKS_IT,  status:VALID,  product: PA - Projects ,  description: Information about the top task level for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TOP_TASKS_IT , 

  • Table: PA_PROJECTS_IT_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_IT_ALL,  object_name:PA_PROJECTS_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Information about projects for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PROJECTS_IT_ALL , 

  • Table: PA_PROJECTS_IT_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_IT_ALL,  object_name:PA_PROJECTS_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Information about projects for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PROJECTS_IT_ALL , 

  • Table: PA_TSK_BGT_LINES_IT_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TSK_BGT_LINES_IT_ALL,  object_name:PA_TSK_BGT_LINES_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Task level budgets for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TSK_BGT_LINES_IT_ALL , 

  • Table: PA_TSK_BGT_LINES_IT_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TSK_BGT_LINES_IT_ALL,  object_name:PA_TSK_BGT_LINES_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Task level budgets for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TSK_BGT_LINES_IT_ALL , 

  • Table: PA_TSK_ACT_CMT_IT_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TSK_ACT_CMT_IT_ALL,  object_name:PA_TSK_ACT_CMT_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Task level actuals and commitments for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_TSK_ACT_CMT_IT_ALL , 

  • Table: PA_PRJ_BGT_LINES_IT_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_BGT_LINES_IT_ALL,  object_name:PA_PRJ_BGT_LINES_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Information about budgets at the project level for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_BGT_LINES_IT_ALL , 

  • Table: PA_PRJ_ACT_CMT_IT_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_ACT_CMT_IT_ALL,  object_name:PA_PRJ_ACT_CMT_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Information about project level actuals and commitments for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_ACT_CMT_IT_ALL , 

  • Table: PA_PRJ_ACT_CMT_IT_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PRJ_ACT_CMT_IT_ALL,  object_name:PA_PRJ_ACT_CMT_IT_ALL,  status:VALID,  product: PA - Projects ,  description: Information about project level actuals and commitments for Oracle Project Analysis Collection Pack ,  implementation_dba_data: PA.PA_PRJ_ACT_CMT_IT_ALL ,