Search Results pa_mc_project_fundings




Overview
Explore in AI Chat

Overview

The PA_MC_PROJECT_FUNDINGS table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically designed to support the Multi-Currency (MC) accounting framework. Its primary role is to store converted funding line amounts for projects across all reporting sets of books that are associated with a primary functional set of books. This table enables organizations to maintain and report on project funding commitments and budgets in multiple reporting currencies, ensuring financial compliance and analysis in a global operating environment. It acts as a reporting currency mirror of the base funding data stored in PA_PROJECT_FUNDINGS.

Key Information Stored

The table stores the reporting currency equivalents of project funding line details. While the full column list is not detailed in the provided metadata, the structure is defined by its critical foreign key relationships and purpose. The essential columns include a foreign key to the original funding line (PROJECT_FUNDING_ID), the identifier for the specific reporting set of books (SET_OF_BOOKS_ID), and the converted funding amounts in the corresponding reporting currency. Additional columns likely store currency conversion details such as conversion rate, conversion date, and the converted amounts for original, funded, and remaining funding values.

Common Use Cases and Queries

This table is central to generating multi-currency financial reports for project funding. Common use cases include reconciling funding amounts between the functional and reporting ledgers, auditing currency conversion accuracy, and producing statutory or management reports in local currencies. A typical query would join this table to its base data source and ledger information to analyze funding across currencies.

  • Reporting Funding by Reporting Currency:
    SELECT pmcpf.set_of_books_id, sob.name, pmcpf.project_funding_id, pmcpf.converted_amount FROM pa_mc_project_fundings pmcpf, gl_sets_of_books_11i sob WHERE pmcpf.set_of_books_id = sob.set_of_books_id AND pmcpf.project_id = :p_project_id;
  • Reconciling to Base Funding Table:
    SELECT pf.funding_amount func_amt, pmcpf.converted_amount rpt_amt FROM pa_project_fundings pf, pa_mc_project_fundings pmcpf WHERE pf.project_funding_id = pmcpf.project_funding_id AND pmcpf.set_of_books_id = :p_sob_id;

Related Objects

The PA_MC_PROJECT_FUNDINGS table has defined dependencies on two key tables, as per the provided relationship data:

  • PA_PROJECT_FUNDINGS: This is the source table for all project funding transactions in the functional currency. The relationship is established via the foreign key column PA_MC_PROJECT_FUNDINGS.PROJECT_FUNDING_ID referencing PA_PROJECT_FUNDINGS. Every record in the multi-currency table originates from a record here.
  • GL_SETS_OF_BOOKS_11I: This table defines the reporting ledgers. The foreign key column PA_MC_PROJECT_FUNDINGS.SET_OF_BOOKS_ID references GL_SETS_OF_BOOKS_11I, identifying for which specific reporting set of books the currency-converted amounts are stored.