Search Results pa_mc_events




Overview
Explore in AI Chat

Overview

PA_MC_EVENTS is a transactional table in the Oracle Projects (PA) schema that stores project event information for each reporting currency. Its name derives from the Multi-Currency (MC) processing that Oracle Projects performs to convert event-based revenue and billing amounts into the functional currencies of multiple sets of books. The table is central to the event revenue and event billing workflows, where a single business event (such as a customer acceptance milestone) may be recognized across several ledgers, each requiring its own converted amount, exchange rate, and rate date.

The primary key of the table is PA_MC_EVENTS_PK, defined on the composite of SET_OF_BOOKS_ID and EVENT_ID. Because each unique event carries foreign-key links to projects, tasks, currencies, conversion types, and set of books, the object occupies an event-centric relationship position within the schema. Heuristic Data Vault classification based on the foreign-key structure yields a link classification, suggesting this table be modeled dimensionally as a connecting object between ledger, project, task, and currency dimensions, with the converted monetary values acting as measures.

Key Information Stored

The table contains 15 documented columns. The most significant are summarized below.

  • SET_OF_BOOKS_ID and EVENT_ID — Together they form the surrogate primary key (PA_MC_EVENTS_PK), uniquely identifying each reporting-currency record for an event.
  • PROJECT_ID and TASK_ID — Identify the project and task to which the event belongs, and together with SET_OF_BOOKS_ID and EVENT_NUM form the unique business key index PA_MC_EVENTS_U2.
  • EVENT_NUM — The user-facing event number within the project and task context.
  • REVENUE_AMOUNT and BILL_AMOUNT — The event-derived revenue and billing amounts captured in the reporting currency.
  • CURRENCY_CODE — The reporting currency of the stored amounts, validated against FND_CURRENCIES.
  • EXCHANGE_RATE, RATE_TYPE, and CONVERSION_DATE — Define the conversion used, the conversion-rate type from GL_DAILY_CONVERSION_TYPES, and the effective date of the rate.
  • PRJFUNC_INV_RATE_DATE and PRJFUNC_INV_EXCHANGE_RATE — The project functional currency rate date and exchange rate used for invoicing-related conversion.
  • PRC_ASSIGNMENT_ID and DESCRIPTION — Reference the project rate/assignment used for conversion and provide free-text descriptive detail.

The unique index PA_MC_EVENTS_U1 (SET_OF_BOOKS_ID, EVENT_ID) reinforces the primary key, while PA_MC_EVENTS_U2 (SET_OF_BOOKS_ID, PROJECT_ID, TASK_ID, EVENT_NUM) is the principal business-key candidate for natural lookups.

Common Use Cases and Queries

Typical use cases include reconciling event revenue and billing by reporting currency, auditing exchange rates applied at conversion time, and supporting multi-ledger reporting in Projects. A representative query retrieves event amounts per ledger for a project and task:

  • SELECT e.set_of_books_id, e.event_id, e.event_num, e.currency_code, e.revenue_amount, e.bill_amount, e.exchange_rate FROM pa_mc_events e WHERE e.project_id = :project_id AND e.task_id = :task_id AND e.set_of_books_id = :ledger_id ORDER BY e.event_num;
  • Drill-down from an event into its conversion context using RATE_TYPE, CONVERSION_DATE, and PRJFUNC_INV_EXCHANGE_RATE to explain variances between reporting currencies.
  • Join to GL_SETS_OF_BOOKS_11I to label ledgers and to FND_CURRENCIES to obtain currency names and precision in reporting extracts.

Related Objects

PA_MC_EVENTS is joined or referenced by the following significant objects:

  • GL_SETS_OF_BOOKS_11I — via SET_OF_BOOKS_ID, supplying ledger context.
  • PA_PROJECTS_ALL — via PROJECT_ID, supplying project attributes.
  • PA_TASKS — via TASK_ID, supplying task detail.
  • FND_CURRENCIES — via CURRENCY_CODE, supplying currency definitions.
  • GL_DAILY_CONVERSION_TYPES — via RATE_TYPE, supplying conversion-rate type definitions.

These relationships establish PA_MC_EVENTS as an integration point between Oracle Projects event processing and the General Ledger multi-currency framework.