Search Results pa_mc_cust_rdl_all




Overview
Explore in AI Chat

Overview

The PA_MC_CUST_RDL_ALL table is a core data object within the Oracle E-Business Suite Projects module (PA), specifically for releases 12.1.1 and 12.2.2. It is a transactional table that stores multi-currency revenue distribution information. Its primary role is to hold the converted revenue amounts for customer expenditure items across different reporting sets of books, which are secondary accounting ledgers used for statutory or management reporting. This table is essential for organizations operating in multiple currencies, as it enables the tracking and reporting of project revenue in both the primary (functional) and secondary (reporting) currencies, ensuring accurate financial consolidation and compliance.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies a revenue distribution line for a specific reporting ledger. The key columns are SET_OF_BOOKS_ID (the reporting ledger), EXPENDITURE_ITEM_ID (the source transaction), and LINE_NUM (the specific distribution line). Beyond the key, critical stored data includes the PROJECT_ID for project association, and monetary amounts such as REVENUE and RAW_REVENUE stored in the reporting currency. It also holds currency conversion details, including CURRENCY_CODE (the reporting currency), RATE_TYPE, PROJFUNC_INV_RATE_TYPE, and the corresponding exchange RATE and RATE_DATE used for the conversion from the functional currency. Links to draft revenue and invoice items (DRAFT_REVENUE_NUM, DRAFT_INVOICE_ITEM_LINE_NUM) are also maintained for integration with the billing cycle.

Common Use Cases and Queries

A primary use case is generating financial reports for a specific reporting set of books, providing a consolidated view of project revenue in a secondary currency. This is critical for statutory reporting in a local currency or for management review across geographic divisions. Another common scenario involves reconciling revenue between the primary and reporting ledgers by analyzing the conversion rates and amounts stored in this table. Troubleshooting billing or revenue recognition issues often requires tracing amounts from draft invoices back to their multi-currency distributions.

Sample SQL to retrieve converted revenue for a specific project and reporting ledger:

  • SELECT pmcrdl.project_id, pmcrdl.expenditure_item_id, pmcrdl.revenue, pmcrdl.currency_code, pmcrdl.rate
  • FROM pa_mc_cust_rdl_all pmcrdl
  • WHERE pmcrdl.set_of_books_id = :reporting_sob_id
  • AND pmcrdl.project_id = :project_id;

Related Objects

PA_MC_CUST_RDL_ALL is centrally connected to several key transactional and reference tables via documented foreign key relationships. It directly references GL_SETS_OF_BOOKS_11I via SET_OF_BOOKS_ID to validate the reporting ledger. The core revenue distribution is sourced from PA_CUST_REV_DIST_LINES_ALL, linked by EXPENDITURE_ITEM_ID and LINE_NUM. For the billing process, it relates to PA_DRAFT_REVENUE_ITEMS and PA_DRAFT_INVOICE_ITEMS via PROJECT_ID and associated draft line identifiers. Currency and conversion rate validation is enforced through references to FND_CURRENCIES (CURRENCY_CODE) and GL_DAILY_CONVERSION_TYPES (RATE_TYPE, PROJFUNC_INV_RATE_TYPE).