Search Results pa_projects_all




Overview
Explore in AI Chat

Overview

PA_PROJECTS_ALL is the master table in the Oracle Projects (PA) module of Oracle E-Business Suite, holding the highest units of work defined in Oracle Projects. Each row represents a single project — a container for tasks, budgets, expenditures, billing events, and revenue — and serves as the integration point between Project Management, Project Costing, Project Billing, and numerous external applications such as Payables, Assets, Purchasing, Grants, and Property Manager. The table resides in the PA schema and is the principal reference point for all project-related foreign keys across the EBS database.

In ETRM 12.2.2 the table is documented with 201 columns, and in a Data Vault modeling heuristic — mined from its foreign-key structure — PA_PROJECTS_ALL classifies as a hub, since it is the central anchor whose surrogate key is referenced by a very large number of dependent links and satellites across EBS.

Key Information Stored

The primary key is PA_PROJECTS_PK, defined on the PROJECT_ID surrogate column. Five unique indexes identify the business-key candidates: PA_PROJECTS_U1 (PROJECT_ID, SEGMENT1), PA_PROJECTS_U2 (SEGMENT1), PA_PROJECTS_U3 (NAME), PA_PROJECTS_U4 (PM_PROJECT_REFERENCE, PM_PRODUCT_CODE), and PA_PROJECTS_U5 (LONG_NAME).

The most significant columns include:

Common Use Cases and Queries

PA_PROJECTS_ALL is queried in virtually every Projects report and is a frequent starting point for joins into cost, billing, and task data.

  • Locating a project by number or name:
    SELECT project_id, name, segment1, project_status_code
    FROM pa_projects_all
    WHERE segment1 = :project_number;
  • List active projects for an operating unit:
    SELECT p.project_id, p.segment1, p.name, s.project_status_name
    FROM pa_projects_all p, pa_project_statuses s
    WHERE p.project_status_code = s.project_status_code
    AND p.org_id = :org_id;
  • Join to PA_TASKS to enumerate the work breakdown structure for a project.
  • Exclude templates when reporting:
    WHERE NVL(template_flag,'N') = 'N'
  • Feed downstream reporting on billing setup (billing cycle, invoice formats, indirect rate schedules).

Related Objects

The table participates in an extensive relationship graph. The most significant dependents and referenced objects include:

Because of this breadth of referencing relationships, care should be taken before purging or reorganizing project rows, as hundreds of EBS tables depend on the PROJECT_ID values defined here.