Search Results bim_source_code_details




Overview
Explore in AI Chat

Overview

BIM_SOURCE_CODE_DETAILS is a table owned by the BIM schema within the Oracle E-Business Suite Marketing Intelligence (BIM) product family. It stores all marketing source codes used to attribute responses, leads, and revenue to specific marketing activities and campaigns. The table is populated by the BIM_SRC_CODE_DETAILS_PKG concurrent program, which reconciles and stages source code information from upstream campaign, media, channel, and offer entities for analytical and reporting consumption.

Within the Oracle EBS 12.1.1 and 12.2.2 releases, the table serves as the canonical repository that links marketing execution records to the source codes that identify how a prospect or customer reached a campaign. Because it consolidates campaign schedule, event, offer, and security context, it acts as a convergence point for Marketing Intelligence reporting on response attribution.

From a Data Vault modeling perspective, the mined foreign key structure classifies this object as a standalone entity rather than a hub, link, or satellite. This heuristic suggests the table is treated as an independent dimension or reference table, with no downstream dependencies in the mined relationship graph. The classification is a modeling suggestion only and reflects the current FK topology rather than a formal Data Vault design decision.

Key Information Stored

The table contains 20 documented columns. The surrogate primary key is SOURCE_CODE_ID, enforced by the constraint BIM_SOURCE_CODE_DETAILS_PK. A unique index, BIM_SOURCE_CODE_DETAILS_U1, also exists on SOURCE_CODE_ID, making it both the surrogate key and the documented business-key candidate.

Common Use Cases and Queries

Typical usage centers on marketing attribution and campaign performance reporting. Analysts join source codes to campaign schedules and event offers to measure response rates by media and channel.

  • Listing all source codes for a campaign: SELECT source_code_id, source_code FROM bim_source_code_details WHERE campaign_id = :campaign_id;
  • Joining to campaign schedules: SELECT s.source_code, c.* FROM bim_source_code_details s, ams_campaign_schedules c WHERE s.campaign_schedule_id = c.campaign_schedule_id;
  • Resolving related offers: SELECT s.source_code, o.* FROM bim_source_code_details s, ams_event_offers_all_b o WHERE s.event_offer_id = o.event_offer_id;
  • Auditing load activity by concurrent request: filter on REQUEST_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.
  • Enforcing security group filtering with SECURITY_GROUP_ID for row-level access control in custom reports.

Related Objects

The following objects are directly referenced through documented foreign keys or provide the operational context for this table.

  • AMS_CAMPAIGN_SCHEDULES — referenced via CAMPAIGN_SCHEDULE_ID.
  • AMS_EVENT_OFFERS_ALL_B — referenced via EVENT_OFFER_ID.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID.
  • BIM_SRC_CODE_DETAILS_PKG — the concurrent program package that populates the table.
  • BIM_SOURCE_CODE_DETAILS_PK and BIM_SOURCE_CODE_DETAILS_U1 — the primary key constraint and unique index on SOURCE_CODE_ID.

Together, these relationships establish BIM_SOURCE_CODE_DETAILS as the central reference for marketing source code attribution data within the BIM module.