Results for “close_competitor”

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

Overview

ASF_WIN_LOSS_COMPTATOR_MV is an Oracle E-Business Suite table owned by the APPS schema, delivered under the ASF — Sales Online product family. It functions as a materialized view-style aggregation object that stores competitive win/loss analysis data used by Oracle Sales Online and related forecasting and pipeline reporting components. In the ETRM 12.1.1 documented schema, the object exposes 15 columns and carries a VALID status, and it is available in both the 12.1.1 and 12.2.2 releases unless superseded by a later view definition.

The object captures period-bucketed competitive outcomes (won, lost, or forecast-rollup) attributed to sales resources, sales groups, salesforces, and product categories. It serves as the analytical substrate for the "Competitor Analysis" and "Win/Loss" dashboards in the ASF module, allowing sales management to quantify competitive performance by time period, currency, and organizational hierarchy.

From a Data Vault modeling perspective, the heuristic FK-based classification is standalone. This suggests that, were the object refactored into a Data Vault model, it would behave as a satellite or bridge-like structure rather than a pure hub — its foreign keys point outward to reference dimensions (salesforce and credit type) but the object does not itself serve as a canonical business entity hub. Modeling teams should treat it as a denormalized aggregation with link characteristics.

Key Information Stored

The table combines outcome flags, organizational context, product context, and financial measures. The most significant columns are:

• WIN and LOSS — Boolean or indicator flags marking the competitive disposition of the opportunity or deal record.
• CLOSE_COMPETITOR — Identifier for the competitor credited at close, central to competitive effectiveness reporting.
• FORECAST_ROLLUP_FLAG — Indicates whether the row participates in forecast rollup aggregation, controlling inclusion in pipeline forecast reports.
• SALESFORCE_ID — Foreign key to AS_SALESFORCE, identifying the sales organization credited with the outcome.
• CREDIT_TYPE_ID — Foreign key to IGS_FI_CR_TYPES_ALL, tying the record to a credit/compensation type classification.
• PARENT_RESOURCE_ID and PARENT_GROUP_ID — Hierarchical rollup pointers enabling parent-level reporting over individual sales resources and groups.
• SALES_GROUP_ID — Identifies the specific sales team or group.
• PRODUCT_CATEGORY_ID and PRODUCT_CAT_SET_ID — Product categorization context for competitive analysis by offering.
• PERIOD_TYPE and PERIOD_NAME — Time dimension, allowing period-based trending of win/loss outcomes.
• CURRENCY_CODE and CURRENCY_AMOUNT — Financial measure of the deal value in the recorded currency.

The metadata does not document a distinct surrogate primary key or named unique index for this object; the FK-implied business-key candidates are SALESFORCE_ID and CREDIT_TYPE_ID, combined with the period and product context columns.

Common Use Cases and Queries

Primary usage concentrates on competitive intelligence dashboards, pipeline forecast rollups, and compensation-adjacent analysis. A typical reporting query aggregates won and lost amounts by period and salesforce:

• Win rate by sales group: SELECT sales_group_id, SUM(CASE WHEN win='Y' THEN 1 ELSE 0 END)/COUNT(*) FROM asf_win_loss_comptator_mv GROUP BY sales_group_id;
• Competitive exposure by product category: aggregate currency_amount where loss='Y', grouped by product_category_id and close_competitor.
• Forecast rollup reporting: filter WHERE forecast_rollup_flag='Y' to isolate records included in the official forecast pipeline.
• Currency-normalized trending: group by currency_code and period_name to produce period-over-period comparisons.

Because the object is a materialized view, refresh timing governs data freshness; reporting windows should align to the underlying refresh schedule defined for the ASF module.

Related Objects

The following objects participate in documented foreign-key relationships or provide the reference data consumed by this table:

• AS_SALESFORCE — joined via SALESFORCE_ID = AS_SALESFORCE.SALESFORCE_ID; provides the sales organization master.
• IGS_FI_CR_TYPES_ALL — joined via CREDIT_TYPE_ID = IGS_FI_CR_TYPES_ALL.CREDIT_TYPE_ID; supplies credit type definitions.
• AS_SALES_LEADS and AS_OPPORTUNITIES — source transactional tables for win/loss outcomes feeding the materialized view.
• AS_SALES_GROUP and sales resource master tables — referenced through SALES_GROUP_ID and PARENT_RESOURCE_ID.
• ASF dashboard and forecast engine views that query this object directly for pipeline and competitive reporting.

Together these objects form the competitive analytics layer of Oracle Sales Online, with ASF_WIN_LOSS_COMPTATOR_MV acting as the pre-aggregated reporting surface for win/loss and forecast analysis.