Search Results pa_mc_prj_ast_lines_all




Overview
Explore in AI Chat

Overview

The table PA_MC_PRJ_AST_LINES_ALL is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as a reporting currency repository for project-related Capital Work in Progress (CIP) costs. Its primary role is to store summarized cost lines from project assets, translated and aggregated into each defined reporting currency. This enables multinational organizations to report project asset costs and capitalization activities consistently across different ledgers and currencies, supporting critical financial reporting and compliance requirements.

Key Information Stored

The table's structure is designed to hold summarized, currency-converted asset line data. The documented primary key consists of SET_OF_BOOKS_ID and PROJECT_ASSET_LINE_ID, indicating that for each unique project asset line in the primary ledger, there can be a corresponding summarized record for each reporting set of books. While the full column list is not detailed in the provided metadata, the table logically stores monetary amounts (such as raw cost, burdened cost, and capitalized amounts) converted into the reporting currency. It also contains identifiers linking back to the source transaction and the target general ledger, ensuring full auditability between project expenditures and corporate financials.

Common Use Cases and Queries

This table is essential for generating multi-currency financial reports for project capitalization. A typical use case involves reconciling total CIP costs across primary and reporting ledgers. Financial analysts run queries against this table to analyze capitalized project costs by reporting currency for period-end closings. A common SQL pattern retrieves summarized asset lines for a specific reporting ledger, joining to project and asset master tables for descriptive context. For example, a report might aggregate total capitalized costs by project, using the SET_OF_BOOKS_ID to filter for a specific reporting currency ledger and joining to PA_PROJECT_ASSET_LINES_ALL to get detailed line information.

Related Objects

PA_MC_PRJ_AST_LINES_ALL maintains defined foreign key relationships with two critical tables, forming the backbone of its data integrity. The primary relationship is with PA_PROJECT_ASSET_LINES_ALL via the PROJECT_ASSET_LINE_ID column. This links each reporting currency summary record to its source transaction detail in the primary ledger. Secondly, it references GL_SETS_OF_BOOKS_11I via the SET_OF_BOOKS_ID column, identifying the specific reporting ledger (set of books) for which the currency conversion is held. These relationships are fundamental for any joins performed in reporting or data validation scripts, ensuring that multi-currency asset data aligns correctly with both project transactions and the general ledger structure.