Search Results pa_mc_cust_event_rdl_all




Overview
Explore in AI Chat

Overview

The PA_MC_CUST_EVENT_RDL_ALL table is a core transactional table within the Oracle E-Business Suite Projects module (PA), specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for storing multi-currency revenue distribution information for customer revenue events. Its primary role is to record the accounting distribution details for revenue recognized from projects, but specifically for each reporting set of books (SOB) within a multi-currency or multi-ledger environment. This enables organizations to maintain accurate project revenue accounting across different reporting currencies and legal entities, supporting the Multi-Currency Accounting (MCA) and Multi-Org Accounting (MOAC) features of Oracle EBS.

Key Information Stored

The table's structure is defined by its composite primary key and its foreign key relationships. The primary key columns—SET_OF_BOOKS_ID, PROJECT_ID, TASK_ID, and EVENT_NUM—uniquely identify a revenue distribution line for a specific reporting ledger. Key data stored includes the financial dimensions of the distribution, such as the accounted amounts (e.g., ACCT_RAW_COST, ACCT_BURDENED_COST, ACCT_REVENUE) in the reporting currency. It also holds references to the source transaction details via columns like LINE_NUM, DRAFT_REVENUE_NUM, DRAFT_INVOICE_NUM, and their respective item line numbers. Critical currency conversion information, including CURRENCY_CODE and RATE_TYPE, is stored to maintain an audit trail of how transaction amounts were converted from the transaction currency to the reporting set of books' currency.

Common Use Cases and Queries

This table is essential for financial reporting and reconciliation of project revenue across multiple ledgers. Common use cases include generating ledger-specific revenue reports, reconciling project revenue between the primary and reporting sets of books, and troubleshooting revenue recognition issues in a multi-currency context. A typical analytical query would join this table to its parent, PA_CUST_EVENT_RDL_ALL, to compare transaction currency amounts with reported amounts.

Sample Query Pattern:
SELECT mc.set_of_books_id,
mc.project_id,
mc.event_num,
mc.acct_revenue,
mc.currency_code,
mc.rate_type
FROM pa_mc_cust_event_rdl_all mc,
gl_sets_of_books sob
WHERE mc.set_of_books_id = sob.set_of_books_id
AND sob.name = '&REPORTING_LEDGER'
AND mc.project_id = &PROJECT_ID;

Related Objects

The table maintains strict referential integrity through documented foreign key relationships, positioning it at the intersection of Projects, General Ledger, and Multi-Currency Accounting. Key related objects include:

  • PA_CUST_EVENT_RDL_ALL: The primary (transaction currency) revenue distribution table. Joined via PROJECT_ID, TASK_ID, EVENT_NUM, and LINE_NUM.
  • GL_SETS_OF_BOOKS: Defines the reporting ledger context. Joined via SET_OF_BOOKS_ID.
  • PA_DRAFT_REVENUE_ITEMS & PA_DRAFT_INVOICE_ITEMS: Source draft revenue and invoice lines. Joined via PROJECT_ID and the respective draft number and line number columns.
  • FND_CURRENCIES & GL_DAILY_CONVERSION_TYPES: Reference tables for valid currency codes and conversion rate types used in the amount translation process.