Search Results event_offer




Overview
Explore in AI Chat

Overview

BIM_EDW_EVTFRCST_FCV is a reporting view within the Oracle EBS BIM (Marketing Intelligence) module, designed to expose event forecast and actual cost/revenue data in a flattened, dimensional format suitable for Enterprise Data Warehouse (EDW) extraction. The view consolidates event offer information with calculated financial measures — actual cost, forecast cost, and forecast revenue — applying currency conversion through the EDW_CURRENCY package to produce globalized amounts alongside transactional values.

The view's naming convention follows the standard EBS EDW staging pattern: the _FCV suffix indicates a "flat" or "fact-conformed" view intended for consumption by ETL processes that populate the EDW star schema. According to the ETRM documentation, this view is not implemented in the reference database for which the metadata was captured, meaning it exists in the source application definition but is absent from the extracted instance. This is a material caveat: DBA queries against ALL_VIEWS or DBA_VIEWS returning no rows for this object do not necessarily indicate an error in the application tier.

Note that the user's search term "flexcon whv120 revit family" is unrelated to this database object. No BIM, EBS, or ETRM construct named "Flexcon" or tied to Revit (a BIM authoring tool, not the EBS "BIM" Marketing Intelligence module) appears in the documented view text. The acronym collision between Building Information Modelling and Oracle's Business Intelligence/Marketing Intelligence usage of "BIM" is a likely source of the mismatch.

Underlying Base Objects

The ETRM metadata records no documented base objects for this view, and the referenced-object list is empty. However, the view's SQL text explicitly references the following underlying sources:

Key Columns

The view exposes a dimensional foreign-key set (CMPGN_FK, OFFER_FK, CUSTOMER_FK, ITEM_FK, and others), most of which are hardcoded to the literal 'NA_EDW', indicating that these dimensions are not populated at this grain and are substituted with a standard placeholder for EDW conformance.

  • EVTFRCST_PK / EVENT_FK — composite keys formed as EVENT_OFFER_ID || '-' || INSTANCE_CODE || '-EVENT_OFFER'.
  • INSTANCE_FK — the bare INSTANCE_CODE.
  • TIME_FK — derived from EVENT_START_DATE formatted as DD-MM-YYYY with a '-DAY' suffix, or 'NA_EDW' when null.
  • ORG_FK — ORG_ID concatenated with INSTANCE_CODE.
  • TRX_CURRENCY_FK — the transaction currency code from the cost source.
  • EVENT_ACTUAL_COST_G / _B / _T — actual cost in global, base, and transaction currencies.
  • EVENT_FRCST_COST_G / _B / _T — forecast cost across the same three currency bases.
  • EVENT_FRCST_REVENUE_G / _B / _T — forecast revenue across the three currency bases.
  • EVENT_NUMBER_CANCELLED — despite the name, computed from a COUNT of AMS_EVENT_REGISTRATIONS rows where ATTENDED_FLAG = 'Y'.

Common Use Cases and Queries

This view supports marketing event profitability reporting, forecast-versus-actual analysis, and EDW fact loading. A representative query:

  • SELECT EVTFRCST_PK, TIME_FK, ORG_FK, EVENT_ACTUAL_COST_T, EVENT_FRCST_COST_T, EVENT_FRCST_REVENUE_T FROM BIM_EDW_EVTFRCST_FCV WHERE ORG_FK = '204-INST1';
  • Forecast accuracy: compare EVENT_FRCST_REVENUE_T against EVENT_ACTUAL_COST_T grouped by TIME_FK.
  • Currency-normalised consolidation: aggregate EVENT_FRCST_COST_G and EVENT_FRCST_REVENUE_G across organisations using EVENT_ACTUAL_COST_G as a comparative baseline.

Standard AMS application grants and the EDW_CURRENCY package must be accessible to the querying schema; because the view is documented as not implemented, validate its existence in the target instance before dependent ETL or reports are promoted.