Search Results pa_project_asset_line_details




Overview
Explore in AI Chat

Overview

The PA_PROJECT_ASSET_LINE_DETAILS table is a core transactional table within the Oracle E-Business Suite Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. Its primary role is to establish and maintain a detailed audit trail between capital asset lines created in Projects and the underlying expenditure transactions from which they are generated. As per its documented description, it stores the information necessary to drill down from an asset line to the specific cost distribution line. This functionality is critical for capital project accounting, enabling traceability from a capitalized asset value back to its original labor, material, or expense items, which supports audit compliance, reconciliation, and detailed financial analysis.

Key Information Stored

The table's structure is designed to link asset lines with their source costs. While the full column list is not provided in the excerpt, the metadata highlights its primary and foreign keys, which define its core data relationships. The primary key column is PROJ_ASSET_LINE_DTL_UNIQ_ID, ensuring each linking record is unique. The most significant foreign key relationships are through the LINE_NUM and EXPENDITURE_ITEM_ID columns, which reference the PA_COST_DISTRIBUTION_LINES_ALL table. This directly ties an asset line detail to a specific distributed cost line. Additionally, the PROJECT_ASSET_LINE_DETAIL_ID column (or a related identifier) links back to the parent header record in the PA_PROJECT_ASSET_LINES_ALL table, grouping details under a single asset line.

Common Use Cases and Queries

The primary use case is auditing and reconciling capitalized project costs. Financial controllers and project accountants query this table to validate asset valuations by tracing them to source transactions. A typical query joins this table to both asset lines and cost distribution lines to produce a detailed cost buildup report. For example:

  • Drill-down Analysis: Identifying all expenditure items contributing to a specific project asset line.
  • Reconciliation: Ensuring total capitalized costs match summed details during period-end close.
  • Transaction Inquiry: Supporting audit requests by providing a clear path from asset to original cost.

A sample SQL pattern retrieves the linked cost details for a given asset line identifier, joining PA_PROJECT_ASSET_LINE_DETAILS to PA_COST_DISTRIBUTION_LINES_ALL on LINE_NUM and EXPENDITURE_ITEM_ID.

Related Objects

This table is central to the capital asset costing flow and has defined relationships with several key objects. As per the provided metadata, its primary foreign key relationship is with PA_COST_DISTRIBUTION_LINES_ALL, the source of the actual cost transactions. It is a child table to PA_PROJECT_ASSET_LINES_ALL, which stores the header-level asset line information. For multi-currency processing, it is referenced by the PA_MC_PRJ_AST_LINE_DTLS table (likely a multi-currency reporting or conversion table) via the PROJ_ASSET_LINE_DTL_UNIQ_ID column. These relationships underscore its position as a critical junction table in the capital asset accounting data model.