Results for “pa_mc_cust_rdl_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_MC_CUST_RDL_ALL is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores revenue distribution information for expenditure items across each reporting set of books. The name decomposes into its functional elements: PA for Projects, MC for Multi-Currency, CUST for customer-specific revenue treatment, and RDL for revenue distribution lines. The table records how revenue attributable to a given expenditure item is spread, allocated, or recognized, and it preserves amounts and exchange rates in both the functional and foreign currency contexts of a reporting ledger. Because the same expenditure item can participate in multiple reporting sets of books, the data is partitioned logically by ledger.

From a data-modeling perspective, the heuristic Data Vault classification for this object is link. Its primary key is composed of three foreign-key-like business identifiers rather than a single surrogate key, and the table resolves many-to-many style associations among ledgers, expenditure item revenue distributions, draft revenue items, and draft invoice items. Practitioners modeling this object in a warehouse typically treat it as a link table surrounded by hubs for expenditure items, projects, and sets of books.

The table is populated by the Projects revenue generation and multi-currency processes, and it is tightly coupled to draft revenue and draft invoice generation, since its foreign keys include references to PA_DRAFT_REVENUE_ITEMS and PA_DRAFT_INVOICE_ITEMS.

Key Information Stored

The documented physical schema contains 24 columns. The most significant are as follows.

• SET_OF_BOOKS_ID, EXPENDITURE_ITEM_ID, LINE_NUM — the composite primary key (PA_MC_CUST_RDL_ALL_PK) and unique index (PA_MC_CUST_RDL_U1). Together they identify one revenue distribution line for a given expenditure item within a specific reporting ledger. This triplet is the business-key candidate; no single surrogate key column is documented.
• AMOUNT and BILL_AMOUNT — the distributed revenue amount and the associated billable amount for the line.
• RAW_COST — the underlying raw cost base from which the distribution is derived.
• PROJECT_ID, DRAFT_REVENUE_NUM, DRAFT_REVENUE_ITEM_LINE_NUM — link the distribution back to the draft revenue item it belongs to.
• DRAFT_INVOICE_NUM, DRAFT_INVOICE_ITEM_LINE_NUM — link the distribution to the corresponding draft invoice item.
• CURRENCY_CODE, EXCHANGE_RATE, CONVERSION_DATE, RATE_TYPE — foreign currency and conversion attributes applied to the amounts.
• PROJFUNC_INV_RATE_TYPE, PROJFUNC_INV_RATE_DATE, PROJFUNC_INV_EXCHANGE_RATE — the project functional currency invoice rate context.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, BATCH_NAME — concurrent program audit and traceability columns.
• PRC_ASSIGNMENT_ID — the associated project revenue/cost assignment identifier.

Common Use Cases and Queries

Typical reporting scenarios include reconciling revenue distribution by ledger, validating multi-currency revenue amounts, and tracing draft revenue to draft invoices.

• Revenue distribution by ledger:

  SELECT set_of_books_id, expenditure_item_id, amount, currency_code
  FROM   pa_mc_cust_rdl_all
  WHERE  set_of_books_id = :p_sob_id;

• Reconciling a specific expenditure item across ledgers:

  SELECT expenditure_item_id, line_num, amount, raw_cost, draft_revenue_num
  FROM   pa_mc_cust_rdl_all
  WHERE  expenditure_item_id = :p_exp_item_id;

• Locating distributions tied to a draft revenue item:

  SELECT r.*
  FROM   pa_mc_cust_rdl_all r
  WHERE  r.project_id = :p_project_id
  AND    r.draft_revenue_num = :p_dr_num;

Related Objects

The documented foreign keys identify the principal parent objects that reference or are referenced by this table.

• GL_SETS_OF_BOOKS_11I — joined on PA_MC_CUST_RDL_ALL.SET_OF_BOOKS_ID; supplies the reporting ledger.
• PA_CUST_REV_DIST_LINES_ALL — joined on EXPENDITURE_ITEM_ID and LINE_NUM; the source revenue distribution lines.
• PA_DRAFT_REVENUE_ITEMS — joined on PROJECT_ID, DRAFT_REVENUE_NUM, and DRAFT_REVENUE_ITEM_LINE_NUM.
• PA_DRAFT_INVOICE_ITEMS — joined on PROJECT_ID, DRAFT_INVOICE_ITEM_LINE_NUM, and LINE_NUM.
• FND_CURRENCIES — joined on CURRENCY_CODE; validates the currency of the distribution.
• GL_DAILY_CONVERSION_TYPES — referenced twice, on RATE_TYPE and PROJFUNC_INV_RATE_TYPE, supplying conversion rate definitions.