Search Results event_offer_tot_actl_cost

Overview

BIM_EDW_EVENT_COST_V is a reporting view in the Oracle E-Business Suite Marketing Intelligence (BIM) module that aggregates actual and forecasted cost values associated with event offers. It is designed to serve as a source for the Enterprise Data Warehouse (EDW), exposing summarized cost metrics in a denormalized form suitable for downstream analytical reporting and extraction processes. The view is particularly relevant to the search term event_offer_tot_actl_cost, which corresponds directly to the EVENT_OFFER_TOT_ACTL_COST column the view exposes.

The view consolidates data from activity metrics tables used by Oracle Marketing (AMS) and returns, for each event offer in a given transaction currency, the total forecasted cost and total actual cost as of the last calculated date. This makes it a convenient single-row-per-event-offer access point for cost reporting rather than requiring consumers to join and aggregate the underlying metrics tables themselves.

Underlying Base Objects

The view is defined over two base tables: AMS_ACT_METRICS_ALL (aliased AAM) and AMS_METRICS_ALL_B (aliased AMT). These are core Oracle Marketing activity and metric definition tables.

• AMS_ACT_METRICS_ALL — stores the calculated metric values (actual and forecasted) at activity level, together with the transaction currency and last calculation date.
• AMS_METRICS_ALL_B — stores the metric definitions, including the ARBOR category and summary metric relationship used to filter cost-type metrics.

The join is performed on AAM.METRIC_ID = AMT.METRIC_ID. The view is restricted to event offer activity metrics (ARC_ACT_METRIC_USED_BY = 'EVEO') and to cost-category metrics (METRIC_CATEGORY = 901), excluding summary metrics with SUMMARY_METRIC_ID IS NULL. Note that the ETRM documentation records this object as not implemented in the reference database and lists no separately documented base objects.

Key Columns

• EVENT_OFFER_ID — sourced from AAM.ACT_METRIC_USED_BY_ID; identifies the event offer the cost figures relate to.
• TRANSACTION_CURRENCY_CODE — the currency in which the metric values are expressed.
• LAST_CALCULATED_DATE — the date the metrics were last calculated; part of the grouping key.
• EVENT_OFFER_TOT_FRCST_COST — the aggregated forecasted cost, SUM(NVL(AAM.TRANS_FORECASTED_VALUE,0)).
• EVENT_OFFER_TOT_ACTL_COST — the aggregated actual cost, SUM(NVL(AAM.TRANS_ACTUAL_VALUE,0)); the column matching the user's search term.

Because the view uses GROUP BY on the first three columns, it returns one row per event offer, currency, and calculation date combination.

Common Use Cases and Queries

The view is typically queried for event ROI and marketing spend analysis. A representative query retrieving actual cost per event offer is:

• SELECT EVENT_OFFER_ID, TRANSACTION_CURRENCY_CODE, LAST_CALCULATED_DATE, EVENT_OFFER_TOT_ACTL_COST FROM BIM_EDW_EVENT_COST_V ORDER BY EVENT_OFFER_ID;
• Comparing forecast versus actual: select EVENT_OFFER_TOT_FRCST_COST and EVENT_OFFER_TOT_ACTL_COST together to compute variance.
• Filtering by currency or calculation date to isolate a reporting period before loading into the EDW.

As a read-only view, it is safe for extraction and reporting use and should not be written to directly.