Search Results pji_fp_xbs_accum_f




Overview
Explore in AI Chat

Overview

The PJI_FP_XBS_ACCUM_F table is a core data repository within the Project Intelligence (PJI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a fact table in the PJI data warehouse, designed to store aggregated performance metrics for projects. Its primary role is to support complex analytical reporting and performance dashboards by providing pre-summarized financial and commitment data across multiple organizational and project hierarchies. By accumulating measures at various levels of detail, this table enables efficient querying for project portfolio analysis, cost control, and revenue recognition reporting without requiring real-time aggregation from transactional source tables.

Key Information Stored

The table stores summarized measures categorized by several key dimensions. While the specific column list is not detailed in the provided metadata, the description and foreign key relationships indicate it contains a combination of dimension foreign keys and numeric fact columns. The dimension keys typically include identifiers for the project (PROJECT_ID), work breakdown structure (WBS) via PROJECT_ELEMENT_ID, resource breakdown structure (RBS) via RBS_ELEMENT_ID, budget plan (PLAN_VERSION_ID), and organization (PROJECT_ORGANIZATION_ID, PROJECT_ORG_ID). The factual measures stored are summarized values for cost, revenue, and commitments. These are likely period-based (e.g., period-to-date, quarter-to-date, year-to-date) and may include planned, actual, and forecast amounts, forming the basis for variance analysis and performance tracking.

Common Use Cases and Queries

This table is central to Project Intelligence reporting. Common use cases include analyzing project cost and revenue performance against budgets, tracking commitments against funding, and generating roll-up reports across program or organizational hierarchies. A typical analytical query would join this fact table to its dimension tables to retrieve meaningful descriptions. For example, to report actual costs by project and task, a query might join to PA_PROJECTS_ALL and PA_PROJ_ELEMENTS. Performance dashboards often query this table to calculate key metrics like Cost Variance (CV) or Schedule Performance Index (SPI) when integrated with earned value data. Data is typically accessed via pre-built PJI reports, Oracle Business Intelligence (OBIEE) analyses, or custom SQL extracts for enterprise reporting systems.

Related Objects

The PJI_FP_XBS_ACCUM_F table is integrally connected to several foundational EBS tables via foreign key relationships, as documented. These relationships define its dimensional context:

  • PA_BUDGET_VERSIONS: Joined via PLAN_VERSION_ID to associate accumulated measures with a specific project budget version.
  • PA_RBS_ELEMENTS: Joined via RBS_ELEMENT_ID to break down measures by the Resource Breakdown Structure.
  • HR_ALL_ORGANIZATION_UNITS: Joined via PROJECT_ORGANIZATION_ID and PROJECT_ORG_ID to provide organizational hierarchy context.
  • PA_PROJ_ELEMENTS: Joined via PROJECT_ELEMENT_ID to break down measures by the Work Breakdown Structure (task).
  • PA_PROJECTS_ALL: Joined via PROJECT_ID, the primary project master record.

This table is also a primary source for various PJI summary and cube views, which further aggregate data for end-user consumption.

  • Table: PJI_FP_XBS_ACCUM_F 12.2.2

    owner:PJI,  object_type:TABLE,  fnd_design_data:PJI.PJI_FP_XBS_ACCUM_F,  object_name:PJI_FP_XBS_ACCUM_F,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: This table stores summarized cost, revenue, commitments measures for project performance by work breakdown, resource breakdown and program hierarchies ,  implementation_dba_data: PJI.PJI_FP_XBS_ACCUM_F , 

  • View: PJI_XBS_PLANS_PRJ_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_XBS_PLANS_PRJ_V,  object_name:PJI_XBS_PLANS_PRJ_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  implementation_dba_data: APPS.PJI_XBS_PLANS_PRJ_V , 

  • View: PJI_AC_ACT_CMT_BY_TASK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_AC_ACT_CMT_BY_TASK_V,  object_name:PJI_AC_ACT_CMT_BY_TASK_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: This view displays actual costs, revenue, and commitments for PA and GL periods by task. The view is used by external project management systems that import financial data from Oracle Projects. ,  implementation_dba_data: APPS.PJI_AC_ACT_CMT_BY_TASK_V , 

  • View: PJI_XBS_PLANS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_XBS_PLANS_V,  object_name:PJI_XBS_PLANS_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  implementation_dba_data: APPS.PJI_XBS_PLANS_V , 

  • View: PJI_PRD_ACT_CMT_BY_TASK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_PRD_ACT_CMT_BY_TASK_V,  object_name:PJI_PRD_ACT_CMT_BY_TASK_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_PRD_ACT_CMT_BY_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. ,  implementation_dba_data: APPS.PJI_PRD_ACT_CMT_BY_TASK_V , 

  • View: PJI_AC_ACT_CMT_BY_RSRC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_AC_ACT_CMT_BY_RSRC_V,  object_name:PJI_AC_ACT_CMT_BY_RSRC_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: This view displays actual costs, revenue, and commitments for PA and GL periods by task and resources. The view is used by external project management systems that import financial data from Oracle Projects. ,  implementation_dba_data: APPS.PJI_AC_ACT_CMT_BY_RSRC_V , 

  • View: PJI_PRD_ACT_CMT_BY_RSRC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_PRD_ACT_CMT_BY_RSRC_V,  object_name:PJI_PRD_ACT_CMT_BY_RSRC_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_PRD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PA, and GL periods by task, and resources. The view is mainly used by external project management systems that import actuals from Oracle Projects ,  implementation_dba_data: APPS.PJI_PRD_ACT_CMT_BY_RSRC_V , 

  • View: PJI_PRD_ACT_CMT_PG_TASK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_PRD_ACT_CMT_PG_TASK_V,  object_name:PJI_PRD_ACT_CMT_PG_TASK_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_PRD_ACT_CMT_PG_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task at Program Level. The view is mainly used by external project management systems that import actuals from Oracle P ,  implementation_dba_data: APPS.PJI_PRD_ACT_CMT_PG_TASK_V , 

  • View: PJI_FP_XBS_ACCUM_F_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_FP_XBS_ACCUM_F_V,  object_name:PJI_FP_XBS_ACCUM_F_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: This table stores project reporting data ,  implementation_dba_data: APPS.PJI_FP_XBS_ACCUM_F_V , 

  • View: PJI_PRD_PLN_BY_TASK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_PRD_PLN_BY_TASK_V,  object_name:PJI_PRD_PLN_BY_TASK_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_PRD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PA, and GL periods by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. ,  implementation_dba_data: APPS.PJI_PRD_PLN_BY_TASK_V , 

  • View: PJI_AC_PLN_BY_TASK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_AC_PLN_BY_TASK_V,  object_name:PJI_AC_PLN_BY_TASK_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: This view displays budgeted cost and revenue for PA and GL periods by task. The view is used by external project management systems that import financial data from Oracle Projects. ,  implementation_dba_data: APPS.PJI_AC_PLN_BY_TASK_V , 

  • View: PJI_PRD_PLN_BY_RSRC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_PRD_PLN_BY_RSRC_V,  object_name:PJI_PRD_PLN_BY_RSRC_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: This new PSI view is to provide PSI functionality using new summarization model.Full Description :PJI_PRD_PLN_BY_RSRC_V is a view that displays budget costand revenue totals for PA, and GL periods by task, and resources. The view is mainly ,  implementation_dba_data: APPS.PJI_PRD_PLN_BY_RSRC_V , 

  • View: PJI_AC_PLN_BY_RSRC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_AC_PLN_BY_RSRC_V,  object_name:PJI_AC_PLN_BY_RSRC_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: This view displays budgeted cost and revenue for PA and GL periods by task and resources. The view is used by external project management systems that import financial data from Oracle Projects. ,  implementation_dba_data: APPS.PJI_AC_PLN_BY_RSRC_V , 

  • View: PJI_XTD_ACT_CMT_BY_RSRC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_XTD_ACT_CMT_BY_RSRC_V,  object_name:PJI_XTD_ACT_CMT_BY_RSRC_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_XTD_ACT_CMT_BY_RSRC_V is a view that displays actual cost, revenue totals, and commitments for PTD, QTD, YTD, and ITD by task, and resource. The view is mainly used by external project management systems that import actuals from Oracle ,  implementation_dba_data: APPS.PJI_XTD_ACT_CMT_BY_RSRC_V , 

  • View: PJI_XTD_ACT_CMT_BY_TASK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_XTD_ACT_CMT_BY_TASK_V,  object_name:PJI_XTD_ACT_CMT_BY_TASK_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_XTD_ACT_CMT_BY_TASK_V is a view that displays actual cost, revenue totals, and commitments for PTD, QTD, YTD, and ITD by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. ,  implementation_dba_data: APPS.PJI_XTD_ACT_CMT_BY_TASK_V , 

  • View: PJI_XTD_PLN_BY_RSRC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_XTD_PLN_BY_RSRC_V,  object_name:PJI_XTD_PLN_BY_RSRC_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_XTD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task, and resource. The view is mainly used by external project management systems that import actuals from Oracle Projects. ,  implementation_dba_data: APPS.PJI_XTD_PLN_BY_RSRC_V , 

  • View: PJI_XTD_PLN_BY_TASK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PJI.PJI_XTD_PLN_BY_TASK_V,  object_name:PJI_XTD_PLN_BY_TASK_V,  status:VALID,  product: PJI - Project Intelligence(Obsolete) ,  description: PJI_XTD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task. The view is mainly used by external project management systems that import actuals from Oracle Projects. ,  implementation_dba_data: APPS.PJI_XTD_PLN_BY_TASK_V ,