Oracle Fusion/Projects/Project Foundation

PJF_PROJECTS_ALL_B

Project definitions — number, type, owning organization, dates and status.

Key Columns

PROJECT_IDSEGMENT1NAMEPROJECT_TYPE_IDCARRYING_OUT_ORGANIZATION_ID

Child Tables

PJF_PROJECTS_ALL_TL

Translated (multi-language) project name and description.

PJF_PROJ_ELEMENTS_B

Work breakdown structure elements — the tasks (and financial task rollups) under a project.

PJF_PROJECT_PARTIES

Project team members and their project roles (project manager, team member, customer, etc.).

PJO_PLAN_VERSIONS_B

Budget and forecast plan versions for a project — one current baselined version per plan type.

Common Joins

PJF_PROJECTS_ALL_TLvia PROJECT_ID + LANGUAGE

Translated project name and description.

PJF_PROJECT_TYPES_Bvia PROJECT_TYPE_ID

The project type that drives costing, billing and capitalization behaviour.

PJF_PROJ_ELEMENTS_Bvia PROJECT_ID

The work breakdown structure (tasks) for the project.

Used In

Project FoundationProject CostingProject Billing

Notes

SEGMENT1 is the user-facing project number. Column set varies by release.

Project foundation: projects, tasks and teams

Projects live in PJF_PROJECTS_ALL_B with translated names in PJF_PROJECTS_ALL_TL, the WBS in PJF_PROJ_ELEMENTS_B, and the team in PJF_PROJECT_PARTIES. Project type (PJF_PROJECT_TYPES_B) drives costing and billing behaviour.