Search Results pa_mc_draft_revs_all




Overview
Explore in AI Chat

Overview

The PA_MC_DRAFT_REVS_ALL table is a core data object within the Oracle E-Business Suite Projects module (PA). It serves a critical function in the application's multi-currency architecture by storing draft revenue amounts for projects in each configured reporting currency. This table operates in conjunction with the primary draft revenues table (PA_DRAFT_REVENUES_ALL), which holds amounts in the project's functional currency. The existence of PA_MC_DRAFT_REVS_ALL enables organizations to generate and review project revenue forecasts and accruals in multiple reporting currencies, which is essential for consolidated financial reporting across global entities. Its role is to maintain the currency-specific draft revenue data until it is finalized and transferred to the general ledger.

Key Information Stored

The table's structure is defined by its primary key and its relationships to other core entities. The primary key columns are SET_OF_BOOKS_ID, PROJECT_ID, and DRAFT_REVENUE_NUM. This composite key uniquely identifies a draft revenue record for a specific project and ledger (set of books) combination. While the provided metadata does not list all columns, the foreign key relationships indicate it must store at least the converted revenue amounts in the reporting currency. Implicitly, it will also contain columns for the reporting currency code and the conversion rate or date used for the translation from the functional currency amounts stored in PA_DRAFT_REVENUES_ALL.

Common Use Cases and Queries

This table is primarily accessed for multi-currency financial reporting and reconciliation within Projects. A common use case is to generate a report comparing draft revenue amounts across different reporting currencies for audit or analytical purposes. Support personnel may query this table to troubleshoot discrepancies in revenue amounts between the Projects module and the General Ledger during the transfer process. A typical analytical query would join this table to the projects and draft revenue master tables.

SELECT pmdr.set_of_books_id,
       pmdr.project_id,
       pmdr.draft_revenue_num,
       pda.draft_revenue_type,
       pmdr.reporting_currency_amount -- Example inferred column
  FROM pa_mc_draft_revs_all pmdr,
       pa_draft_revenues_all pda
 WHERE pmdr.project_id = pda.project_id
   AND pmdr.draft_revenue_num = pda.draft_revenue_num
   AND pmdr.set_of_books_id = :p_ledger_id;

Related Objects

The table has defined foreign key relationships with several fundamental EBS tables, as documented in the metadata:

  • GL_SETS_OF_BOOKS_11I: Via SET_OF_BOOKS_ID. This links the draft revenue record to the specific ledger for which the reporting currency amount is calculated.
  • PA_DRAFT_REVENUES_ALL: Via PROJECT_ID and DRAFT_REVENUE_NUM. This is the most critical relationship, as PA_MC_DRAFT_REVS_ALL is a child table that holds the multi-currency equivalents for the master draft revenue record.
  • PA_PROJECTS_ALL: Via PROJECT_ID. This enforces referential integrity to the master projects table.

These relationships ensure data consistency and are essential for any joins performed in custom reports or interfaces that involve multi-currency project revenues.