Search Results pa_project_assets_all




Overview
Explore in AI Chat

Overview

The PA_PROJECT_ASSETS_ALL table is a core data repository within Oracle E-Business Suite (EBS) Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master table for defining and tracking assets associated with capital projects. Its primary role is to establish and maintain the critical linkage between project-related expenditures in Projects and the resulting fixed assets in the Fixed Assets (FA) module. This table is central to the capital asset lifecycle, enabling the systematic capitalization of project costs and the subsequent creation of asset records for financial accounting, depreciation, and reporting.

Key Information Stored

The table stores the defining attributes for each project asset. Its primary key is the system-generated PROJECT_ASSET_ID. The most critical foreign key is PROJECT_ID, which ties the asset definition to a specific project in PA_PROJECTS_ALL. The table holds the target asset's categorization via ASSET_CATEGORY_ID (linking to FA_CATEGORIES_B) and tracks its status within the asset creation process. Crucially, it maintains references to the Fixed Assets module through columns like FA_ASSET_ID, PARENT_ASSET_ID, and RET_TARGET_ASSET_ID (all linking to FA_ADDITIONS_B), which are populated upon asset creation or retirement. The CAPITAL_EVENT_ID links the asset to a specific capital event in PA_CAPITAL_EVENTS that triggers the capitalization process.

Common Use Cases and Queries

This table is essential for reporting and auditing the pipeline of assets being built through projects. Common use cases include generating a list of all assets defined for a specific project, identifying project assets pending transfer to Fixed Assets (where FA_ASSET_ID is null), and reconciling capitalized project costs to the final asset value. A typical query would join to PA_PROJECTS_ALL for project details and FA_ADDITIONS_B for the resulting asset information. For example, to find all capitalized assets for a project, one might use:

  • SELECT ppa.segment1 project_number, ppa.name project_name, paa.fa_asset_id, fa.asset_number FROM pa_project_assets_all paa JOIN pa_projects_all ppa ON paa.project_id = ppa.project_id LEFT JOIN fa_additions_b fa ON paa.fa_asset_id = fa.asset_id WHERE ppa.segment1 = 'P12345';

This table is also heavily referenced in standard Oracle reports for project asset tracking and capital work in progress (CWIP) analysis.

Related Objects

PA_PROJECT_ASSETS_ALL is a central hub with documented relationships to several key tables. It is the parent table for assignment and line detail tables: PA_PROJECT_ASSET_ASSIGNMENTS (via PROJECT_ASSET_ID) and PA_PROJECT_ASSET_LINES_ALL (via PROJECT_ASSET_ID). Its primary foreign key dependencies, as per the provided metadata, are:

  • PA_PROJECTS_ALL (via PROJECT_ID): The master projects table.
  • FA_CATEGORIES_B (via ASSET_CATEGORY_ID): The Fixed Assets category definition.
  • PA_CAPITAL_EVENTS (via CAPITAL_EVENT_ID): The table storing capital transaction events.
  • FA_ADDITIONS_B (via FA_ASSET_ID, PARENT_ASSET_ID, RET_TARGET_ASSET_ID): The Fixed Assets master table, linking the project asset definition to the actual asset, its parent, or a retirement target.