Results for “pa_mc_events_u1”

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

Overview

PA.PA_MC_EVENTS is a Multi-Reporting-Currency (MRC) sub table of the parent table PA.PA_EVENTS in the Oracle E-Business Suite Projects (PA) schema. It stores the currency-related attributes of project billing and revenue events for each reporting set of books associated with the corresponding parent record on PA_EVENTS. Where PA_EVENTS holds the enterprise-level definition of an event, PA_MC_EVENTS provides one row per reporting set of books, allowing amounts, exchange rates, and rate types to be retained in the reporting currency of each set of books. The object is classified as VALID and is registered under the FND Design Data namespace as PA.PA_MC_EVENTS.

Under a heuristic Data Vault classification derived from the documented foreign key structure, this table best fits a link pattern. It resolves the association between a set of books and an event while carrying descriptive currency measures. The heuristic suggestion is that the surrogate-style pairing of SET_OF_BOOKS_ID and EVENT_ID functions as the hub-like identity, with CURRENCY_CODE and RATE_TYPE acting as referenced lookup keys and the rate/amount attributes behaving as link-level descriptive data.

Key Information Stored

The physical schema comprises 15 columns in the APPS_TS_TX_DATA tablespace. The primary key is PA_MC_EVENTS_PK, defined on (SET_OF_BOOKS_ID, EVENT_ID). Two unique indexes act as business-key candidates: PA_MC_EVENTS_U1 on (SET_OF_BOOKS_ID, EVENT_ID), and PA_MC_EVENTS_U2 on (SET_OF_BOOKS_ID, PROJECT_ID, TASK_ID, EVENT_NUM). The most significant columns include:

• SET_OF_BOOKS_ID — the reporting set of books unique identifier; part of the primary key and of both unique indexes.
• EVENT_ID — the system-generated number uniquely identifying an event; the second component of the primary key.
• PROJECT_ID — identifier of the project to which the event is assigned; participates in PA_MC_EVENTS_U2.
• TASK_ID — identifier of the top-level task to which the event is assigned; also in PA_MC_EVENTS_U2.
• EVENT_NUM — the sequential number identifying the event entered for a task; completes the U2 business key.
• REVENUE_AMOUNT — revenue in the reporting currency to accrue for the event upon completion.
• BILL_AMOUNT — amount in the reporting currency to be billed upon event completion.
• CURRENCY_CODE — the currency code associated with the reporting set of books.
• EXCHANGE_RATE — the rate applied to convert into the reporting set of books currency.
• CONVERSION_DATE — the date used for that conversion.
• RATE_TYPE — the exchange rate type used for conversion.
• PROJFUNC_INV_RATE_DATE and PROJFUNC_INV_EXCHANGE_RATE — rate date and rate used when converting from bill transaction currency to project functional currency under a Fixed Date rate date type.
• DESCRIPTION — descriptive text for the event within the reporting context.
• PRC_ASSIGNMENT_ID — documented as reserved for future use.

Common Use Cases and Queries

This table is typically queried when multi-currency reporting requires event-level amounts restated into a specific reporting set of books. A common pattern joins the MRC sub table to its parent on the shared EVENT_ID and filters by reporting set of books:

• Retrieving restated event amounts: SELECT e.event_num, m.revenue_amount, m.bill_amount, m.currency_code FROM pa.pa_mc_events m, pa.pa_events e WHERE m.event_id = e.event_id AND m.set_of_books_id = :sob_id.
• Auditing exchange-rate application: selecting EXCHANGE_RATE, CONVERSION_DATE, and RATE_TYPE for a given project or task using the PA_MC_EVENTS_U2 key columns.
• Reconciling bill versus revenue amounts in reporting currency for revenue accrual and invoice generation reporting.
• Identifying events lacking a reporting-currency row for a given set of books, which indicates incomplete MRC conversion.

Related Objects

The documented foreign keys and parent relationship connect PA_MC_EVENTS to the following significant objects:

• PA.PA_EVENTS — the parent table; joined on EVENT_ID.
• GL.GL_SETS_OF_BOOKS_11I — referenced through SET_OF_BOOKS_ID, supplying the reporting set of books definition.
• PA.PA_PROJECTS_ALL — referenced through PROJECT_ID.
• PA.PA_TASKS — referenced through TASK_ID.
• FND.FND_CURRENCIES — referenced through CURRENCY_CODE.
• GL.GL_DAILY_CONVERSION_TYPES — referenced through RATE_TYPE, defining valid exchange rate types.

Because PA_MC_EVENTS is an MRC sub table, its contents are populated and maintained in step with the parent PA_EVENTS record for each reporting set of books, and reporting against it should always be scoped by SET_OF_BOOKS_ID to avoid cross-set-of-books duplication.