Search Results pa_mc_prj_ast_line_dtls




Overview
Explore in AI Chat

Overview

The PA_MC_PRJ_AST_LINE_DTLS table is a core transactional table within the Oracle E-Business Suite Projects module (PA). It serves a critical function in the system's multi-currency accounting architecture. Specifically, this table stores detailed information for each asset line that has been generated in every defined reporting currency. Its primary role is to maintain the converted monetary amounts and related data for project asset lines across different sets of books, enabling comprehensive financial reporting and reconciliation in a global, multi-currency environment for Oracle EBS versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which dictate the core data it holds. The primary key is a composite of SET_OF_BOOKS_ID and PROJ_ASSET_LINE_DTL_UNIQ_ID, ensuring a unique record for each asset line detail in each reporting ledger. Consequently, the table must store the converted currency amounts (such as raw cost, burdened cost, and revenue) for the associated asset line detail, specific to that set of books. It will also contain critical currency conversion information, including the conversion rate type, date, and rate used to translate amounts from the project's functional currency into the reporting currency of the specified ledger.

Common Use Cases and Queries

This table is essential for generating asset-related financial reports in any reporting currency. A common use case is reconciling project asset costs and revenues between the primary ledger and a secondary reporting ledger. Auditors and financial analysts query this table to verify the accuracy of currency conversions for capitalized project costs. A typical reporting query would join this table to the base transaction table to compare amounts.

Sample SQL Pattern:
SELECT mc.set_of_books_id,
mc.converted_raw_cost,
mc.conversion_rate,
base.*
FROM pa_mc_prj_ast_line_dtls mc,
pa_project_asset_line_details base
WHERE mc.proj_asset_line_dtl_uniq_id = base.proj_asset_line_dtl_uniq_id
AND mc.set_of_books_id = :reporting_ledger_id
AND base.project_id = :project_id;

Related Objects

The table has defined foreign key relationships with two fundamental EBS objects, as documented in the provided metadata:

  • GL_SETS_OF_BOOKS_11I: The PA_MC_PRJ_AST_LINE_DTLS.SET_OF_BOOKS_ID column references this General Ledger table. This relationship ties each multi-currency record to a specific ledger or set of books for reporting purposes.
  • PA_PROJECT_ASSET_LINE_DETAILS: The PA_MC_PRJ_AST_LINE_DTLS.PROJ_ASSET_LINE_DTL_UNIQ_ID column references this core Projects table. This is the fundamental link to the original transaction detail in its functional currency, from which all reporting currency amounts are derived.