Search Results pa_fp_adj_elements




Overview
Explore in AI Chat

Overview

The PA_FP_ADJ_ELEMENTS table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically supporting the Financial Planning (FP) functionality. Its primary role is to store denormalized header information for Plan Adjustments. In the context of project budgeting and forecasting, plan adjustments are modifications made to a project's financial plan after its initial baseline is established. This table acts as a central repository for the key identifiers and metadata associated with each adjustment transaction, enabling efficient tracking, reporting, and integration of these financial changes within the broader project accounting framework across versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to link an adjustment to its fundamental project entities. While the full column list is not detailed in the provided metadata, the documented foreign key relationships explicitly identify its most critical columns. These include PROJECT_ID, which links to the master project definition; TASK_ID, for task-level adjustments; BUDGET_VERSION_ID, specifying the budget version being adjusted; and RESOURCE_ASSIGNMENT_ID, connecting to the specific resource assignment being modified. Additional columns likely exist to store adjustment amounts, dates, statuses, and creation metadata, forming a denormalized header record for each adjustment entry.

Common Use Cases and Queries

This table is integral to processes involving the review and audit of financial plan changes. Common use cases include generating reports on all adjustments made to a specific project budget, analyzing the volume of adjustments by task or resource, and reconciling forecast changes. A typical reporting query would join PA_FP_ADJ_ELEMENTS to its related master tables to provide contextual information. For example, to list adjustments for a project, one might use a SQL pattern such as: SELECT p.segment1 project_number, t.task_number, bv.version_name, adj.* FROM pa_fp_adj_elements adj, pa_projects_all p, pa_tasks t, pa_budget_versions bv WHERE adj.project_id = p.project_id AND adj.task_id = t.task_id (+) AND adj.budget_version_id = bv.budget_version_id AND p.project_id = :p_project_id. This facilitates traceability from the adjustment record back to the core project data.

Related Objects

PA_FP_ADJ_ELEMENTS maintains defined foreign key relationships with several fundamental PA tables, as per the provided documentation. These relationships are:

  • PA_PROJECTS_ALL: Joined via PA_FP_ADJ_ELEMENTS.PROJECT_ID to provide the master project context for every adjustment.
  • PA_TASKS: Joined via PA_FP_ADJ_ELEMENTS.TASK_ID to associate adjustments made at the task level.
  • PA_BUDGET_VERSIONS: Joined via PA_FP_ADJ_ELEMENTS.BUDGET_VERSION_ID to identify the specific budget version being adjusted.
  • PA_RESOURCE_ASSIGNMENTS: Joined via PA_FP_ADJ_ELEMENTS.RESOURCE_ASSIGNMENT_ID to link adjustments to a particular resource assignment on the project plan.
These relationships ensure referential integrity and are critical for any data extraction or integration involving financial plan adjustments.

  • Table: PA_FP_ADJ_ELEMENTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FP_ADJ_ELEMENTS,  object_name:PA_FP_ADJ_ELEMENTS,  status:VALID,  product: PA - Projects ,  description: This table stores denormalized header information for Plan Adjustments ,  implementation_dba_data: PA.PA_FP_ADJ_ELEMENTS , 

  • Table: PA_FP_ADJ_ELEMENTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FP_ADJ_ELEMENTS,  object_name:PA_FP_ADJ_ELEMENTS,  status:VALID,  product: PA - Projects ,  description: This table stores denormalized header information for Plan Adjustments ,  implementation_dba_data: PA.PA_FP_ADJ_ELEMENTS , 

  • Lookup Type: FIN_PLAN_OBJ_TYPE_CODE 12.1.1

    product: PA - Projects ,  meaning: Financial Plan Object Type Code ,  description: Financial Plan Object Type Code , 

  • Lookup Type: FIN_PLAN_OBJ_TYPE_CODE 12.2.2

    product: PA - Projects ,  meaning: Financial Plan Object Type Code ,  description: Financial Plan Object Type Code , 

  • View: PA_FP_ENTER_ADJ_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_ENTER_ADJ_LINES_V,  object_name:PA_FP_ENTER_ADJ_LINES_V,  status:VALID,  product: PA - Projects ,  description: The pa_fp_enter_adj_lines_v view store the adjusted amounts by period for one adjustment reason. ,  implementation_dba_data: APPS.PA_FP_ENTER_ADJ_LINES_V , 

  • View: PA_FP_ENTER_ADJ_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_ENTER_ADJ_LINES_V,  object_name:PA_FP_ENTER_ADJ_LINES_V,  status:VALID,  product: PA - Projects ,  description: The pa_fp_enter_adj_lines_v view store the adjusted amounts by period for one adjustment reason. ,  implementation_dba_data: APPS.PA_FP_ENTER_ADJ_LINES_V , 

  • View: PA_FP_VIEW_ADJ_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_VIEW_ADJ_V,  object_name:PA_FP_VIEW_ADJ_V,  status:VALID,  product: PA - Projects ,  description: The pa_fp_view_adj_v view store the adjusted amounts by period for all adjustment reasons. ,  implementation_dba_data: APPS.PA_FP_VIEW_ADJ_V , 

  • View: PA_FP_VIEW_ADJ_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_VIEW_ADJ_V,  object_name:PA_FP_VIEW_ADJ_V,  status:VALID,  product: PA - Projects ,  description: The pa_fp_view_adj_v view store the adjusted amounts by period for all adjustment reasons. ,  implementation_dba_data: APPS.PA_FP_VIEW_ADJ_V , 

  • Table: PA_RESOURCE_ASSIGNMENTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCE_ASSIGNMENTS,  object_name:PA_RESOURCE_ASSIGNMENTS,  status:VALID,  product: PA - Projects ,  description: Resource assignments for a budget version at a branch of project's work breakdown ,  implementation_dba_data: PA.PA_RESOURCE_ASSIGNMENTS , 

  • Table: PA_RESOURCE_ASSIGNMENTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCE_ASSIGNMENTS,  object_name:PA_RESOURCE_ASSIGNMENTS,  status:VALID,  product: PA - Projects ,  description: Resource assignments for a budget version at a branch of project's work breakdown ,  implementation_dba_data: PA.PA_RESOURCE_ASSIGNMENTS , 

  • Table: PA_BUDGET_VERSIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGET_VERSIONS,  object_name:PA_BUDGET_VERSIONS,  status:VALID,  product: PA - Projects ,  description: Versions of project budgets ,  implementation_dba_data: PA.PA_BUDGET_VERSIONS , 

  • Table: PA_BUDGET_VERSIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGET_VERSIONS,  object_name:PA_BUDGET_VERSIONS,  status:VALID,  product: PA - Projects ,  description: Versions of project budgets ,  implementation_dba_data: PA.PA_BUDGET_VERSIONS , 

  • Table: PA_TASKS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_TASKS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL ,