Search Results oppr_creation_date




Overview
Explore in AI Chat

Overview

APPS.BIM_FCTV_OPPR_CYCLE is an internal Oracle EBS view owned by the APPS schema and registered under FND Design Data as BIM.BIM_FCTV_OPPR_CYCLE. It is classified in the ETRM metadata as an Internal view type, and Oracle explicitly flags it as "Oracle Internal Use Only," noting that Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. The view presents a fact-style, cycle-oriented dataset that links marketing campaign and channel activity to opportunities and, ultimately, to sales orders. Its name reflects a "fact" (FCTV) structure over an opportunity cycle (OPPR_CYCLE), making it a reporting and analytics building block rather than a transactional entry point.

In Oracle EBS 12.1.1 and 12.2.2, objects of this nature typically feed marketing and order-cycle analytics — for example, tracing which campaign, media, channel, segment, and geography combination produced an opportunity, and whether that opportunity converted to an order. The user search term "oppr_creation_date" maps directly to the OPPR_CREATION_DATE column exposed by this view, which is the anchor for any time-based analysis of the opportunity cycle.

Underlying Base Objects

The documented dependencies show that BIM_FCTV_OPPR_CYCLE is defined over the following base objects:

The view itself is not referenced by any other database object, confirming it functions as a terminal reporting object. The join across AMS, ASO, AS, HZ, and BIM schemas demonstrates that it consolidates marketing, quoting, order, and location dimensions into a single denormalized cycle fact.

Key Columns

  • CAMPAIGN_ID (NUMBER) — identifies the marketing campaign associated with the opportunity.
  • MEDIA_ID (NUMBER) — the media through which the campaign was delivered.
  • CHANNEL_ID (VARCHAR2, 80) — the channel identifier for the activity.
  • MARKET_SEGMENT_ID (NUMBER) — the market segment targeted, sourced from AMS_PARTY_MARKET_SEGMENTS.
  • GEOGRAPHY_CODE (VARCHAR2, 246) — the location/geography of the opportunity, derived from HZ_LOCATIONS.
  • SALES_CHANNEL_CODE (VARCHAR2, 30) — the sales channel classification.
  • OPPORTUNITY_ID (NUMBER) — the opportunity/lead identifier from AS_LEADS_ALL.
  • OPPR_CREATION_DATE (DATE) — the date the opportunity was created; the primary time dimension for cycle analysis.
  • ORDER_HEADER_ID (NUMBER) — the resulting order header, when the opportunity converted.
  • ORDERED_DATE (DATE) — the date the order was placed, supporting cycle-duration calculations against OPPR_CREATION_DATE.

Common Use Cases and Queries

Typical scenarios include measuring campaign-to-opportunity conversion, computing the elapsed time between opportunity creation and order placement, and analyzing pipeline performance by segment, geography, or sales channel. The following query aggregates opportunity counts and average cycle time by campaign:

SELECT CAMPAIGN_ID
     , COUNT(OPPORTUNITY_ID) AS OPPS
     , AVG(ORDERED_DATE - OPPR_CREATION_DATE) AS AVG_CYCLE_DAYS
  FROM APPS.BIM_FCTV_OPPR_CYCLE
 WHERE OPPR_CREATION_DATE >= :from_date
 GROUP BY CAMPAIGN_ID
 ORDER BY OPPS DESC;

Because this is an internal view, direct SQL should be restricted to diagnostic or controlled reporting use, and production integrations should rely on Oracle-supported APIs and standard concurrent programs.