Search Results bim_fctv_sales_cycle




Overview
Explore in AI Chat

Overview

The APPS.BIM_FCTV_SALES_CYCLE view is a denormalized fact-style object belonging to the BIM – Marketing Intelligence product family, now marked Obsolete in Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to feed concurrent programs that load the Marketing Intelligence summary tables. Rather than capturing live transactional state, the view consolidates lead, opportunity, quote, order, campaign, and geography attributes into a single fact-shaped result set that ETL processes can consume directly.

The view spans the full sales cycle — from a sales lead through its associated opportunity, related quote, and eventual order header — and enriches each row with campaign, media, channel, market segment, and location context. This makes it a canonical source for funnel, attribution, and cycle-time reporting within the Marketing Intelligence schema.

Underlying Base Objects

The view is defined in the APPS schema and references the following documented base objects:

The first SELECT block joins these objects with outer joins to preserve leads lacking downstream artifacts, then UNIONs a second block for leads converted directly to orders.

Key Columns

Common Use Cases and Queries

Typical usage is concurrent-program loading of Marketing Intelligence summaries, ad-hoc cycle-time analysis from lead creation to ORDERED_DATE, and campaign attribution reporting.

SELECT CAMPAIGN_ID,
       COUNT(*)            AS CYCLE_ROWS,
       MIN(ORDERED_DATE)   AS FIRST_ORDER,
       MAX(ORDERED_DATE)   AS LAST_ORDER
FROM   APPS.BIM_FCTV_SALES_CYCLE
WHERE  ORDERED_DATE IS NOT NULL
GROUP  BY CAMPAIGN_ID;

SELECT LEAD_ID, OPPORTUNITY_ID, ORDER_HEADER_ID,
       LEAD_CREATION_DATE, ORDERED_DATE,
       ORDERED_DATE - LEAD_CREATION_DATE AS CYCLE_DAYS
FROM   APPS.BIM_FCTV_SALES_CYCLE
WHERE  ORDERED_DATE BETWEEN :p_start AND :p_end;

Because the object is obsolete and fact-oriented, it should be treated as a read-only integration source.