Search Results pa_budget_versions

Overview

The PA_BUDGET_VERSIONS table is a core data repository within Oracle E-Business Suite Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the master table for storing header-level information for every distinct version of a project budget or financial plan. Each record represents a unique snapshot or iteration of budgeted amounts, costs, and revenues for a specific project. The table's primary role is to define the version's attributes, such as its type, status, entry method, and structural dependencies, while the detailed line-item data is stored in related child tables. It is fundamental to the project budgeting, forecasting, and financial planning lifecycle.

Key Information Stored

The table's structure captures metadata and control attributes for each budget version. The primary key is BUDGET_VERSION_ID, a unique system-generated identifier. Critical foreign key columns establish relationships to other master data, defining the version's context and rules. These include PROJECT_ID linking to PA_PROJECTS_ALL, BUDGET_TYPE_CODE linking to PA_BUDGET_TYPES (e.g., original, current, baseline), and BUDGET_ENTRY_METHOD_CODE linking to PA_BUDGET_ENTRY_METHODS (e.g., spread, manual). Other significant columns include RESOURCE_LIST_ID, FIN_PLAN_TYPE_ID, PERIOD_MASK_ID, and RBS_STRUCT_VERSION_ID, which govern the resources, planning options, time periods, and Resource Breakdown Structure (RBS) used. The PARENT_PLAN_VERSION_ID supports version hierarchy by linking to another record within the same table, enabling scenarios like creating a new version from a copy of an existing one.

Common Use Cases and Queries

This table is central to queries for budget version reporting, audit trails, and data integrity checks. A common use case is generating a list of all budget versions for a specific project, including their types and creation details. Another is identifying the current or baseline budget version for financial reporting. Sample SQL patterns include joining to project and budget type tables for descriptive reporting:

Listing versions for a project: SELECT pbv.budget_version_id, pbv.version_name, pbt.name budget_type, pbv.creation_date FROM pa_budget_versions pbv, pa_budget_types pbt WHERE pbv.project_id = :p_project_id AND pbv.budget_type_code = pbt.budget_type_code ORDER BY pbv.creation_date DESC;
Finding the hierarchy of versions: SELECT child.version_name, parent.version_name parent_version FROM pa_budget_versions child LEFT JOIN pa_budget_versions parent ON child.parent_plan_version_id = parent.budget_version_id WHERE child.project_id = :p_project_id;

It is also frequently referenced in data fixes to update version attributes or correct invalid foreign key references.

Related Objects

As indicated by its extensive foreign key relationships, PA_BUDGET_VERSIONS is a pivotal hub within the Projects schema. Key related objects include:

Parent/Dimension Tables: PA_PROJECTS_ALL, PA_BUDGET_TYPES, PA_BUDGET_ENTRY_METHODS, PA_FIN_PLAN_TYPES_B, PA_RESOURCE_LISTS_ALL_BG, PA_PERIOD_MASKS_B, PA_PROJ_ELEMENT_VERSIONS (for RBS and Project Structure versions).
Child/Transaction Tables: PA_BUDGET_LINES and PA_BUDGET_ACCT_LINES store the detailed budget quantities and amounts. PA_BC_PACKETS, PA_BC_BALANCES, and PA_BC_COMMITMENTS_ALL link budget versions for burdening and commitments processing.
Financial Planning Objects: PA_FP_ELEMENTS, PA_FP_ADJ_ELEMENTS, and PA_FIN_PLAN_ADJ_LINES use BUDGET_VERSION_ID to tie planning adjustments to a specific version.
Grants Accounting (GMS): The GMS_BALANCES table references it for tracking award-funded project balances.

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_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_PROJ_FP_OPTIONS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJ_FP_OPTIONS, object_name:PA_PROJ_FP_OPTIONS, status:VALID, product: PA - Projects , description: This table stores the default financial planning options for a project, plan type or plan version. , implementation_dba_data: PA.PA_PROJ_FP_OPTIONS ,
Table: PA_PROJ_FP_OPTIONS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJ_FP_OPTIONS, object_name:PA_PROJ_FP_OPTIONS, status:VALID, product: PA - Projects , description: This table stores the default financial planning options for a project, plan type or plan version. , implementation_dba_data: PA.PA_PROJ_FP_OPTIONS ,
View: PA_TASK_BUDGETS2_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_TASK_BUDGETS2_V, object_name:PA_TASK_BUDGETS2_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_TASK_BUDGETS2_V ,
View: PA_TASK_BUDGETS2_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_TASK_BUDGETS2_V, object_name:PA_TASK_BUDGETS2_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_TASK_BUDGETS2_V ,
Table: PA_BUDGET_ACCT_LINES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_ACCT_LINES, object_name:PA_BUDGET_ACCT_LINES, status:VALID, product: PA - Projects , description: This entity stores consolidated accounting information for a budget version. , implementation_dba_data: PA.PA_BUDGET_ACCT_LINES ,
View: PA_FCST_PROJ_ERR_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_FCST_PROJ_ERR_V, object_name:PA_FCST_PROJ_ERR_V, status:VALID, product: PA - Projects , description: PA_PROJ_FCST_ERR_V is a view that shows project forecasting error information , implementation_dba_data: APPS.PA_FCST_PROJ_ERR_V ,
Table: PA_FP_MERGED_CTRL_ITEMS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_MERGED_CTRL_ITEMS, object_name:PA_FP_MERGED_CTRL_ITEMS, status:VALID, product: PA - Projects , description: This table stores information about the change documents that have been merged into a financial plan version. , implementation_dba_data: PA.PA_FP_MERGED_CTRL_ITEMS ,
Table: PA_BUDGET_ACCT_LINES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_ACCT_LINES, object_name:PA_BUDGET_ACCT_LINES, status:VALID, product: PA - Projects , description: This entity stores consolidated accounting information for a budget version. , implementation_dba_data: PA.PA_BUDGET_ACCT_LINES ,
View: PA_FCST_PROJ_ERR_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_FCST_PROJ_ERR_V, object_name:PA_FCST_PROJ_ERR_V, status:VALID, product: PA - Projects , description: PA_PROJ_FCST_ERR_V is a view that shows project forecasting error information , implementation_dba_data: APPS.PA_FCST_PROJ_ERR_V ,
Table: PA_FP_MERGED_CTRL_ITEMS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_MERGED_CTRL_ITEMS, object_name:PA_FP_MERGED_CTRL_ITEMS, status:VALID, product: PA - Projects , description: This table stores information about the change documents that have been merged into a financial plan version. , implementation_dba_data: PA.PA_FP_MERGED_CTRL_ITEMS ,
Table: PA_FP_UPGRADE_AUDIT 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_UPGRADE_AUDIT, object_name:PA_FP_UPGRADE_AUDIT, status:VALID, product: PA - Projects , description: This table stores information about upgraded budget types for a project. , implementation_dba_data: PA.PA_FP_UPGRADE_AUDIT ,
Table: PA_FP_UPGRADE_AUDIT 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_UPGRADE_AUDIT, object_name:PA_FP_UPGRADE_AUDIT, status:VALID, product: PA - Projects , description: This table stores information about upgraded budget types for a project. , implementation_dba_data: PA.PA_FP_UPGRADE_AUDIT ,
Table: PA_BC_BALANCES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BC_BALANCES, object_name:PA_BC_BALANCES, status:VALID, product: PA - Projects , description: PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat , implementation_dba_data: PA.PA_BC_BALANCES ,
Table: PA_BC_BALANCES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BC_BALANCES, object_name:PA_BC_BALANCES, status:VALID, product: PA - Projects , description: PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat , implementation_dba_data: PA.PA_BC_BALANCES ,
Table: PA_PROJ_ELEMENT_VERSIONS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJ_ELEMENT_VERSIONS, object_name:PA_PROJ_ELEMENT_VERSIONS, status:VALID, product: PA - Projects , description: PA_PROJ_ELEMENT_VERSIONS stores the common versioned information related to tasks and structures. - For future use , implementation_dba_data: PA.PA_PROJ_ELEMENT_VERSIONS ,
Table: PA_PROJ_ELEMENT_VERSIONS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJ_ELEMENT_VERSIONS, object_name:PA_PROJ_ELEMENT_VERSIONS, status:VALID, product: PA - Projects , description: PA_PROJ_ELEMENT_VERSIONS stores the common versioned information related to tasks and structures. - For future use , implementation_dba_data: PA.PA_PROJ_ELEMENT_VERSIONS ,
View: PA_ORGFCST_PERIODS_TMP_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ORGFCST_PERIODS_TMP_V, object_name:PA_ORGFCST_PERIODS_TMP_V, status:VALID, product: PA - Projects , description: The PA_ORGFCST_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates. , implementation_dba_data: APPS.PA_ORGFCST_PERIODS_TMP_V ,
View: PA_ORGFCST_PERIODS_TMP_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ORGFCST_PERIODS_TMP_V, object_name:PA_ORGFCST_PERIODS_TMP_V, status:VALID, product: PA - Projects , description: The PA_ORGFCST_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates. , implementation_dba_data: APPS.PA_ORGFCST_PERIODS_TMP_V ,
View: PA_PROJECT_BAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJECT_BAL_V, object_name:PA_PROJECT_BAL_V, status:VALID, product: PA - Projects , description: Master View for Budget Funds Check Results - Source for views created on various Levels , implementation_dba_data: APPS.PA_PROJECT_BAL_V ,
View: PA_PROJECT_BAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJECT_BAL_V, object_name:PA_PROJECT_BAL_V, status:VALID, product: PA - Projects , description: Master View for Budget Funds Check Results - Source for views created on various Levels , implementation_dba_data: APPS.PA_PROJECT_BAL_V ,
Table: PA_FP_OF_WEBADI_XFACE 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_OF_WEBADI_XFACE, object_name:PA_FP_OF_WEBADI_XFACE, status:VALID, product: PA - Projects , implementation_dba_data: PA.PA_FP_OF_WEBADI_XFACE ,
View: PA_RES_MAP_BTC_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RES_MAP_BTC_V, object_name:PA_RES_MAP_BTC_V, status:VALID, product: PA - Projects , description: This view selects raw BTC cdls to be resource mapped during the Funds Checking process. , implementation_dba_data: APPS.PA_RES_MAP_BTC_V ,
View: PA_RES_MAP_BTC_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RES_MAP_BTC_V, object_name:PA_RES_MAP_BTC_V, status:VALID, product: PA - Projects , description: This view selects raw BTC cdls to be resource mapped during the Funds Checking process. , implementation_dba_data: APPS.PA_RES_MAP_BTC_V ,
Table: PA_FP_OF_WEBADI_XFACE 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_OF_WEBADI_XFACE, object_name:PA_FP_OF_WEBADI_XFACE, status:VALID, product: PA - Projects , implementation_dba_data: PA.PA_FP_OF_WEBADI_XFACE ,
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_FIN_PLAN_ADJ_LINES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FIN_PLAN_ADJ_LINES, object_name:PA_FIN_PLAN_ADJ_LINES, status:VALID, product: PA - Projects , description: This table stores the adjustment lines for a Financial Plan , implementation_dba_data: PA.PA_FIN_PLAN_ADJ_LINES ,
Table: PA_ALLOC_RUN_TARGETS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ALLOC_RUN_TARGETS, object_name:PA_ALLOC_RUN_TARGETS, status:VALID, product: PA - Projects , description: Target projects and tasks for each target line for an allocation run , implementation_dba_data: PA.PA_ALLOC_RUN_TARGETS ,
Table: PA_ALLOC_RUN_TARGETS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ALLOC_RUN_TARGETS, object_name:PA_ALLOC_RUN_TARGETS, status:VALID, product: PA - Projects , description: Target projects and tasks for each target line for an allocation run , implementation_dba_data: PA.PA_ALLOC_RUN_TARGETS ,
View: PA_FP_PERIOD_INFO_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_FP_PERIOD_INFO_V, object_name:PA_FP_PERIOD_INFO_V, status:VALID, product: PA - Projects , description: The pa_fp_period_info_v view store the period information plan versions. , implementation_dba_data: APPS.PA_FP_PERIOD_INFO_V ,
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 ,
View: PA_BUDGET_VERSIONS_DRAFT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BUDGET_VERSIONS_DRAFT_V, object_name:PA_BUDGET_VERSIONS_DRAFT_V, status:VALID, product: PA - Projects , description: 10SC Only - Retrofitted , implementation_dba_data: APPS.PA_BUDGET_VERSIONS_DRAFT_V ,
View: PA_BUDGET_VERSIONS_DRAFT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BUDGET_VERSIONS_DRAFT_V, object_name:PA_BUDGET_VERSIONS_DRAFT_V, status:VALID, product: PA - Projects , description: 10SC Only - Retrofitted , implementation_dba_data: APPS.PA_BUDGET_VERSIONS_DRAFT_V ,
Table: PA_FIN_PLAN_ADJ_LINES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FIN_PLAN_ADJ_LINES, object_name:PA_FIN_PLAN_ADJ_LINES, status:VALID, product: PA - Projects , description: This table stores the adjustment lines for a Financial Plan , implementation_dba_data: PA.PA_FIN_PLAN_ADJ_LINES ,
View: PA_FP_PERIOD_INFO_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_FP_PERIOD_INFO_V, object_name:PA_FP_PERIOD_INFO_V, status:VALID, product: PA - Projects , description: The pa_fp_period_info_v view store the period information plan versions. , implementation_dba_data: APPS.PA_FP_PERIOD_INFO_V ,
Table: PA_FP_TXN_CURRENCIES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_TXN_CURRENCIES, object_name:PA_FP_TXN_CURRENCIES, status:VALID, product: PA - Projects , description: This table stores the plannable transaction currencies for a project. , implementation_dba_data: PA.PA_FP_TXN_CURRENCIES ,
Table: PA_ORG_FORECAST_LINES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ORG_FORECAST_LINES, object_name:PA_ORG_FORECAST_LINES, status:VALID, product: PA - Projects , description: This table stores the detailed forecast lines data for the PA_ORG_FCST_ELEMENTS table , implementation_dba_data: PA.PA_ORG_FORECAST_LINES ,
Table: PA_BUDGET_ENTRY_METHODS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_ENTRY_METHODS, object_name:PA_BUDGET_ENTRY_METHODS, status:VALID, product: PA - Projects , description: Implementation-defined methods for entering budgets , implementation_dba_data: PA.PA_BUDGET_ENTRY_METHODS ,
Table: PA_BUDGET_ENTRY_METHODS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGET_ENTRY_METHODS, object_name:PA_BUDGET_ENTRY_METHODS, status:VALID, product: PA - Projects , description: Implementation-defined methods for entering budgets , implementation_dba_data: PA.PA_BUDGET_ENTRY_METHODS ,
Table: PA_ORG_FORECAST_LINES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ORG_FORECAST_LINES, object_name:PA_ORG_FORECAST_LINES, status:VALID, product: PA - Projects , description: This table stores the detailed forecast lines data for the PA_ORG_FCST_ELEMENTS table , implementation_dba_data: PA.PA_ORG_FORECAST_LINES ,
Table: PA_FP_EXCLUDED_ELEMENTS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_EXCLUDED_ELEMENTS, object_name:PA_FP_EXCLUDED_ELEMENTS, status:VALID, product: PA - Projects , description: Stores tasks which have been excluded for financial planning purposes. , implementation_dba_data: PA.PA_FP_EXCLUDED_ELEMENTS ,
Table: PA_FP_EXCLUDED_ELEMENTS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_EXCLUDED_ELEMENTS, object_name:PA_FP_EXCLUDED_ELEMENTS, status:VALID, product: PA - Projects , description: Stores tasks which have been excluded for financial planning purposes. , implementation_dba_data: PA.PA_FP_EXCLUDED_ELEMENTS ,
Table: PA_FP_TXN_CURRENCIES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_TXN_CURRENCIES, object_name:PA_FP_TXN_CURRENCIES, status:VALID, product: PA - Projects , description: This table stores the plannable transaction currencies for a project. , implementation_dba_data: PA.PA_FP_TXN_CURRENCIES ,
Table: PA_FP_ELEMENTS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_ELEMENTS, object_name:PA_FP_ELEMENTS, status:VALID, product: PA - Projects , description: This table stores plannable elements for a project. , implementation_dba_data: PA.PA_FP_ELEMENTS ,
View: PA_XLA_BC_BUDGET_TXN_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_XLA_BC_BUDGET_TXN_V, object_name:PA_XLA_BC_BUDGET_TXN_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_XLA_BC_BUDGET_TXN_V ,
Table: PA_FP_ELEMENTS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_FP_ELEMENTS, object_name:PA_FP_ELEMENTS, status:VALID, product: PA - Projects , description: This table stores plannable elements for a project. , implementation_dba_data: PA.PA_FP_ELEMENTS ,
Table: PA_PERIOD_MASKS_B 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERIOD_MASKS_B, object_name:PA_PERIOD_MASKS_B, status:VALID, product: PA - Projects , description: This table stores the various period mask definitions to be used for displaying periodic data , implementation_dba_data: PA.PA_PERIOD_MASKS_B ,
Table: PA_PERIOD_MASKS_B 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERIOD_MASKS_B, object_name:PA_PERIOD_MASKS_B, status:VALID, product: PA - Projects , description: This table stores the various period mask definitions to be used for displaying periodic data , implementation_dba_data: PA.PA_PERIOD_MASKS_B ,
View: PA_XLA_BC_BUDGET_TXN_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_XLA_BC_BUDGET_TXN_V, object_name:PA_XLA_BC_BUDGET_TXN_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_XLA_BC_BUDGET_TXN_V ,