Results for “event_actual_cost_g”

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

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.

• EVTFRCST_PK_KEY and EVTFRCST_PK — the surrogate warehouse key and the business-facing primary key for the event forecast record. These uniquely identify each fact row.
• EVENT_FK_KEY, CMPGN_FK_KEY, and CMPGN_STATUS_FK_KEY — dimension references tying each row to a specific event and its parent campaign and status.
• CUSTOMER_FK_KEY, MKTSGMT_FK_KEY, TGTSGMT_FK_KEY, and SRCLST_FK_KEY — customer, marketing segment, target segment, and source list references used to attribute forecast performance.
• TIME_FK_KEY, ORG_FK_KEY, ITEM_FK_KEY, and OFFER_FK_KEY — standard EDW conformed dimensions for time, organization, product, and offer.
• EVENT_FRCST_COST_G/B/T and EVENT_FRCST_REVENUE_G/B/T — forecast cost and revenue measures in global, base, and transaction currency respectively. Actual counterparts are stored in EVENT_ACTUAL_COST_G/B/T.
• EVENT_NUMBER_CANCELLED, EVENT_NUMBER_ATTENDED, EVENT_NUMBER_AVAILABLE, and EVENT_NUMBER_ENROLLED — attendance funnel metrics for the event.
• SECURITY_GROUP_ID — the sole documented foreign key, referencing FND_SECURITY_GROUPS to enforce Oracle EBS multi-org and function security row filtering.
• USER_MEASURE1–5, USER_FK1–5_KEY, and USER_ATTRIBUTE1–15 — extensibility columns reserved for customer-specific analytics.

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.