Search Results pa_fi_amount_details




Overview
Explore in AI Chat

Overview

The PA_FI_AMOUNT_DETAILS table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. It functions as the detailed transactional repository for financial amounts associated with forecast items. Forecast items are a fundamental component of the project forecasting and budgeting capabilities in Oracle Projects, representing planned revenue, cost, or labor for a project task. This table's primary role is to store the granular, line-level amount details that roll up to create a complete financial forecast, enabling detailed analysis, reporting, and variance tracking against actual project performance.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the table's description and foreign key relationship define its critical purpose and structure. The central column is FORECAST_ITEM_ID, which is a foreign key linking each amount detail record to its parent header record in the PA_FORECAST_ITEMS table. Typical data stored in this table would include detailed line amounts, potentially broken down by financial period, currency code, quantity, raw and burdened cost amounts, revenue amounts, and transaction dates. It may also hold attributes for the amount type (e.g., planned, committed) and classification, serving as the detailed ledger for a forecast item's financial composition.

Common Use Cases and Queries

This table is essential for generating detailed forecast reports, conducting variance analysis between forecasted and actual amounts, and supporting audit trails. Common operational and reporting queries involve joining to the parent forecast item and project task tables. A typical SQL pattern retrieves all amount details for a specific forecast item or project to analyze cost breakdowns:

  • SELECT * FROM pa_fi_amount_details fad, pa_forecast_items fi WHERE fad.forecast_item_id = fi.forecast_item_id AND fi.project_id = :p_project_id;

Another critical use case is aggregating forecast amounts by period or task for comparison with actual costs from PA_COST_DISTRIBUTION_LINES_ALL or revenue from PA_REVENUE_DISTRIBUTION_LINES_ALL, enabling project managers to track financial performance against the plan.

Related Objects

The PA_FI_AMOUNT_DETAILS table has a direct and documented dependency on the PA_FORECAST_ITEMS table, as confirmed by the ETRM foreign key metadata. This is a one-to-many relationship where a single forecast item header can have multiple associated amount detail lines. The join is performed on the column PA_FI_AMOUNT_DETAILS.FORECAST_ITEM_ID referencing PA_FORECAST_ITEMS.FORECAST_ITEM_ID. Consequently, this table is also intrinsically linked to higher-level project entities like PA_PROJECTS and PA_TASKS through its parent table. For transactional integration, it may be populated or referenced by private APIs within the PA forecasting suite, though these are not explicitly listed in the provided documentation.