Search Results ibe_ecr_quotes_fact




Overview
Explore in AI Chat

Overview

The table IBE_ECR_QUOTES_FACT is a core data warehouse fact table within the Oracle E-Business Suite iStore (IBE) module. It stores granular, aggregated transactional information about sales quotes generated over specific time periods. Its primary role is to support Enterprise Command Center (ECC) or similar analytical reporting frameworks by providing a performant, denormalized source of quote metrics. This table is integral to generating key performance indicators (KPIs) for quote volume, conversion, and customer engagement within the iStore e-commerce platform, enabling data-driven business analysis for releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed for analytical queries, combining key foreign identifiers with aggregated measures. While the full column list is not detailed in the provided metadata, the documented foreign keys reveal its critical dimensions. The table stores aggregated facts linked to a microsite (MSITE_ID), a specific display section (SECTION_ID), an inventory item (INVENTORY_ITEM_ID and ORGANIZATION_ID), and a customer account (CUST_ACCOUNT_ID). Typical measures in such a fact table would include counts of quotes created, revised, converted to orders, or expired, along with associated aggregated amounts and quantities for the defined period. The "granular aggregate" description indicates data is likely summarized by a time dimension (e.g., day, week) and the listed business dimensions.

Common Use Cases and Queries

This table is primarily accessed for pre-built or custom operational reports within the ECC framework. Common analytical use cases include tracking quote generation trends by microsite or product category, analyzing quote-to-order conversion rates, and measuring sales pipeline velocity. A typical query pattern would involve joining this fact table to its dimension tables to slice the aggregated data. For example, to analyze quote performance by product, a query might join to MTL_SYSTEM_ITEMS_B and filter by a specific organization.

Related Objects

As indicated by its foreign key constraints, IBE_ECR_QUOTES_FACT has direct dependencies on several master and transactional tables. These relationships are essential for enriching the aggregated facts with descriptive information.

  • IBE_MSITES_B: Provides microsite details for analyzing quote activity by specific e-commerce storefront.
  • IBE_DSP_SECTIONS_B: Supplies the display section or category context, useful for understanding which site areas drive quote requests.
  • MTL_SYSTEM_ITEMS_B: Links to the product catalog via INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • HZ_CUST_ACCOUNTS: Provides customer account details for analyzing quote behavior by customer segment.

This table is part of a larger ECC reporting schema for iStore, and it may be sourced from transactional base tables such as AS_QUOTES_ALL or QP_HEADERS_ALL through an ETL process.

  • Table: IBE_ECR_QUOTES_FACT 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_ECR_QUOTES_FACT,  object_name:IBE_ECR_QUOTES_FACT,  status:VALID,  product: IBE - iStore ,  description: Granular aggregate information about quotes for a given period. ,  implementation_dba_data: IBE.IBE_ECR_QUOTES_FACT , 

  • Table: IBE_ECR_QUOTES_FACT 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_ECR_QUOTES_FACT,  object_name:IBE_ECR_QUOTES_FACT,  status:VALID,  product: IBE - iStore ,  description: Granular aggregate information about quotes for a given period. ,  implementation_dba_data: IBE.IBE_ECR_QUOTES_FACT , 

  • Table: IBE_DSP_SECTIONS_B 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_DSP_SECTIONS_B,  object_name:IBE_DSP_SECTIONS_B,  status:VALID,  product: IBE - iStore ,  description: This table stores information about the sections. ,  implementation_dba_data: IBE.IBE_DSP_SECTIONS_B , 

  • Table: IBE_DSP_SECTIONS_B 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_DSP_SECTIONS_B,  object_name:IBE_DSP_SECTIONS_B,  status:VALID,  product: IBE - iStore ,  description: This table stores information about the sections. ,  implementation_dba_data: IBE.IBE_DSP_SECTIONS_B , 

  • Table: IBE_MSITES_B 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_B,  object_name:IBE_MSITES_B,  status:VALID,  product: IBE - iStore ,  description: Stores Mini Site (Specialty Stores) Information. ,  implementation_dba_data: IBE.IBE_MSITES_B , 

  • Table: IBE_MSITES_B 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_B,  object_name:IBE_MSITES_B,  status:VALID,  product: IBE - iStore ,  description: Stores Mini Site (Specialty Stores) Information. ,  implementation_dba_data: IBE.IBE_MSITES_B ,