Search Results ibe_ecr_orders_fact




Overview
Explore in AI Chat

Overview

The IBE_ECR_ORDERS_FACT table is a core data object within the Oracle E-Business Suite (EBS) iStore (IBE) module. It functions as a fact table designed to store granular, aggregated information about orders for a specific period. Its primary role is to support reporting and analytical queries related to e-commerce order performance, providing a denormalized and performance-optimized structure for extracting key metrics. This table is integral to the E-Commerce Reporting (ECR) framework, enabling businesses to analyze sales trends, product performance, and channel effectiveness over time.

Key Information Stored

As a fact table, IBE_ECR_ORDERS_FACT contains aggregated measures and foreign keys to related dimension tables. While the specific measure columns are not detailed in the provided metadata, typical data stored in such a table includes summarized order counts, total revenue amounts, and average order values. The documented foreign key columns are critical for dimensional analysis: MSITE_ID links to the microsite (IBE_MSITES_B), SECTION_ID links to the storefront section or category (IBE_DSP_SECTIONS_B), and the composite key of INVENTORY_ITEM_ID and ORGANIZATION_ID links to the product master (MTL_SYSTEM_ITEMS_B). These relationships allow for slicing the aggregated order facts by channel, site section, and product.

Common Use Cases and Queries

This table is primarily used for generating e-commerce performance dashboards and operational reports. Common analytical queries include calculating total sales revenue by microsite, identifying top-selling product categories within specific site sections, or analyzing order volume trends over time. A typical reporting query would join the fact table to its dimension tables to produce a readable report. For example:

  • SELECT ms.MSITE_NAME, sec.SECTION_NAME, SUM(fact.ORDER_AMOUNT) FROM IBE_ECR_ORDERS_FACT fact JOIN IBE_MSITES_B ms ON fact.MSITE_ID = ms.MSITE_ID JOIN IBE_DSP_SECTIONS_B sec ON fact.SECTION_ID = sec.SECTION_ID GROUP BY ms.MSITE_NAME, sec.SECTION_NAME;

The table is likely populated via a concurrent process or batch job that aggregates transactional data from the core order management tables (e.g., OE_ORDER_HEADERS_ALL) for performance.

Related Objects

The IBE_ECR_ORDERS_FACT table has defined foreign key relationships with several key dimension tables, as documented in the ETRM metadata. These relationships are essential for accurate reporting:

  • IBE_MSITES_B: Joined via MSITE_ID. This links the order aggregates to the specific iStore microsite where the order originated.
  • IBE_DSP_SECTIONS_B: Joined via SECTION_ID. This links the aggregates to the specific section or category of the storefront, enabling merchandising analysis.
  • MTL_SYSTEM_ITEMS_B: Joined via INVENTORY_ITEM_ID and ORGANIZATION_ID. This links the aggregates to the master product/item definition, allowing for product-level performance reporting.

This table is a central component in a star schema, where it is the fact table surrounded by these dimension tables. It may also be the source for higher-level summary tables or materialized views within the iStore reporting architecture.

  • Table: IBE_ECR_ORDERS_FACT 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_ECR_ORDERS_FACT,  object_name:IBE_ECR_ORDERS_FACT,  status:VALID,  product: IBE - iStore ,  description: Granular aggregate information of Orders for a given period. ,  implementation_dba_data: IBE.IBE_ECR_ORDERS_FACT , 

  • Table: IBE_ECR_ORDERS_FACT 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_ECR_ORDERS_FACT,  object_name:IBE_ECR_ORDERS_FACT,  status:VALID,  product: IBE - iStore ,  description: Granular aggregate information of Orders for a given period. ,  implementation_dba_data: IBE.IBE_ECR_ORDERS_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 ,