Search Results pa_project_assets




Overview
Explore in AI Chat

Overview

The PA_PROJECT_ASSETS view is a single-organization reporting object within the Oracle E-Business Suite Projects (PA) module. It exposes project-related asset information that originates from Oracle Projects and is subsequently transferred to Oracle Assets (FA). The view presents a secure, organization-filtered projection of the underlying PA_PROJECT_ASSETS_ALL table, restricting rows to a single operating unit (ORG_ID) based on the session context held in USERENV('CLIENT_INFO').

Because the view is described as Single-Org, it is intended for reporting and integration scenarios where a caller must see only the asset records belonging to the currently active organization, rather than the entire multi-org data set. It is a key object for users building reports and interfaces that trace a capitalized project cost through to its associated asset record, including the capital event, asset category, book, depreciation, and amortization attributes.

Underlying Base Objects

The view text shows that PA_PROJECT_ASSETS is defined with a SELECT over PA_PROJECT_ASSETS_ALL, applying an ORG_ID predicate that filters by the current organization derived from the client session. In Oracle EBS 12.1.1 and 12.2.2, PA_PROJECT_ASSETS_ALL is the multi-organization table that stores project asset lines. The view is therefore a secure, single-org synonym-style wrapper for that base table.

The ETRM metadata indicates the view is not implemented in the documented database and that no referenced base objects are formally documented, but the view text explicitly names PA_PROJECT_ASSETS_ALL as the source and the PA_PROJECT_ASSETS_ALL columns as its output. The organization restriction follows the standard multi-org pattern used throughout Oracle EBS, ensuring the view behaves differently depending on the logged-in responsibility and its associated operating unit.

Key Columns

Common Use Cases and Queries

The view is typically used to report project assets by project, operating unit, or capitalization status, and to reconcile PA asset lines against FA assets. Because it is single-org, queries naturally return only rows for the session's organization.

  • Listing capitalized asset lines for a project:

SELECT project_asset_id, asset_number, asset_name, capitalized_cost, capitalized_date FROM pa_project_assets WHERE project_id = :project_id AND capitalized_flag = 'Y';

  • Finding child assets referencing a parent using the column searched:

SELECT project_asset_id, asset_number, parent_asset_id FROM pa_project_assets WHERE parent_asset_id = :parent_asset_id;

  • Reconciling PA asset lines to Oracle Assets:

SELECT project_asset_id, fa_asset_id, book_type_code, capitalized_cost FROM pa_project_assets WHERE fa_asset_id IS NOT NULL;

These patterns make PA_PROJECT_ASSETS a convenient, org-secured access point for project-to-asset reporting and reconciliation in Oracle EBS 12.1.1 and 12.2.2.