Search Results event_actual_cost_b




Overview
Explore in AI Chat

Overview

BIM_EDW_EVTFRCST_F_DLOG is a fact-style staging table within the Oracle EBS Marketing Intelligence (BIM) module, which is classified as obsolete in release 12.1.1 and 12.2.2. The object belongs to the Enterprise Data Warehouse (EDW) layer of BIM and stores event forecast and actual performance measures used for marketing analytics and campaign event reporting. The "_DLOG" suffix indicates that the table functions as a detail log or fact accumulation table within the BIM extract-transform-load pipeline, capturing granular event-level forecast, revenue, and attendance figures before aggregation into higher-level analytical structures.

Per the supplied ETRM metadata, the Data Vault classification is standalone, meaning no foreign-key links to other hubs or satellites were mined beyond the single security group reference. The documented physical schema exposes 63 columns owned by the BIM schema. Note that the implementation metadata explicitly states this table is not implemented in the reference database, so it should be treated as a legacy or dormant object that appears in documentation but may not exist in a given environment.

Key Information Stored

The most significant columns fall into three groups: surrogate identifiers, dimension foreign keys, and measures.

Common Use Cases and Queries

Primary use cases include event return-on-investment analysis, forecast-versus-actual variance reporting, and marketing campaign effectiveness dashboards. A typical query compares forecast and actual revenue per event:

  • SELECT EVENT_FK_KEY, SUM(EVENT_FRCST_REVENUE_B), SUM(EVENT_ACTUAL_COST_B) FROM BIM_EDW_EVTFRCST_F_DLOG GROUP BY EVENT_FK_KEY;
  • Joining to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to restrict results by the user's accessible organizations.
  • Filtering on CMPGN_STATUS_FK_KEY to isolate events in active campaigns against those in cancelled campaigns, using EVENT_NUMBER_CANCELLED for attendance analysis.

Related Objects

Based on the documented FK structure and EBS conventions, the most significant related objects are:

  • FND_SECURITY_GROUPS — joined via BIM_EDW_EVTFRCST_F_DLOG.SECURITY_GROUP_ID.
  • BIM_EDW_CMPGN_F — campaign dimension joined on CMPGN_FK_KEY.
  • BIM_EDW_EVENT_F — event dimension joined on EVENT_FK_KEY.
  • BIM_EDW_CUST_F — customer dimension joined on CUSTOMER_FK_KEY.
  • BIM_EDW_TIME_F — time dimension joined on TIME_FK_KEY.
  • BIM_EDW_ORG_F — organization dimension joined on ORG_FK_KEY.

As this table is documented as obsolete and unimplemented, dependency analysis should be confirmed against the actual database before designing any downstream integration.