Search Results pa_fp_upgrade_audit




Overview
Explore in AI Chat

Overview

The PA_FP_UPGRADE_AUDIT table is a core data object within the Oracle E-Business Suite (EBS) Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. Its primary function is to serve as an audit trail for the upgrade of financial plan (budget) types associated with a project. This table is critical during system upgrades or migrations where budget structures are enhanced or modified, ensuring a transparent record of the transformation. It captures the relationship between the original budget data and its upgraded counterpart, thereby maintaining data integrity and providing a reference point for historical analysis and troubleshooting of the upgraded financial planning setup.

Key Information Stored

The table stores metadata that links a project's budget configuration before and after an upgrade process. Based on its foreign key relationships, the table's key columns include a unique identifier (likely a primary key), the PROJECT_ID linking to PA_PROJECTS_ALL, and the PROJ_FP_OPTIONS_ID linking to PA_PROJ_FP_OPTIONS, which stores project-level financial planning options. Crucially, it stores the BUDGET_TYPE_CODE from PA_BUDGET_TYPES that was upgraded. For the upgraded budget, it records references to the basis cost and revenue budget versions (BASIS_COST_VERSION_ID, BASIS_REV_VERSION_ID from PA_BUDGET_VERSIONS) and their corresponding entry methods (BASIS_COST_BEM, BASIS_REV_BEM from PA_BUDGET_ENTRY_METHODS). This structure provides a complete map from the old budget type to the new financial plan components.

Common Use Cases and Queries

The primary use case is auditing and reporting on the scope and success of a financial planning upgrade. Administrators can query this table to verify which projects and budget types were processed, identify any upgrade failures, or reconcile data post-migration. A typical diagnostic query would join to project and budget type tables to generate a summary report.

  • Sample Query: List Upgraded Budgets by Project:
    SELECT p.segment1 project_number, bt.name budget_type, audit.*
    FROM pa_fp_upgrade_audit audit,
    pa_projects_all p,
    pa_budget_types bt
    WHERE audit.project_id = p.project_id
    AND audit.budget_type_code = bt.budget_type_code
    ORDER BY p.segment1;
  • Validation: Comparing record counts in this audit table against the total number of projects or budget types expected to be upgraded to ensure completeness.
  • Troubleshooting: Investigating projects missing from the audit table post-upgrade to determine if they were erroneously skipped.

Related Objects

PA_FP_UPGRADE_AUDIT is centrally connected to several fundamental Projects tables, as documented by its foreign keys. These relationships are essential for joining to descriptive data.

  • PA_PROJECTS_ALL (PROJECT_ID): Provides the core project definition information, such as project number and name.
  • PA_PROJ_FP_OPTIONS (PROJ_FP_OPTIONS_ID): Links to the financial planning options and controls configured for the specific project.
  • PA_BUDGET_TYPES (BUDGET_TYPE_CODE): Identifies the specific type of budget (e.g., Original, Current) that was upgraded.
  • PA_BUDGET_VERSIONS (BASIS_COST_VERSION_ID, BASIS_REV_VERSION_ID): References the specific cost and revenue budget version records that form the basis of the upgraded plan.
  • PA_BUDGET_ENTRY_METHODS (BASIS_COST_BEM, BASIS_REV_BEM): Identifies the methodology (e.g., Spreadsheet, Resource List) used for the basis budget versions.