Results for “visitant_id”

50+ results




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

Overview

IBW_PRODUCT_TIME_MV is an Oracle E-Business Suite materialized view owned by the APPS schema and registered under the FND — Application Object Library product. Despite its designation as a table in the ETRM object registry, its name and structure identify it as a materialized view within the Oracle Business Intelligence (IBW) reporting layer, used to aggregate product-level transactional metrics across time dimensions. In EBS 12.1.1 and 12.2.2, the object remains valid and is populated from underlying iStore and order-capture base tables, serving as a pre-computed analytical store for product performance and visit-conversion reporting.

The heuristic Data Vault classification mined from the foreign-key structure identifies this object as standalone. In Data Vault modeling terms, this suggests the object does not function as a pure hub, link, or satellite, but rather as a derived aggregate snapshot — a denormalized reporting structure that consolidates measures and dimensional keys into a single wide table. Modelers should treat it as a consumption-layer artifact rather than a canonical integration entity.

Key Information Stored

The view contains 30 documented columns spanning dimensional identifiers and additive measures. The most significant are:

The unique index I_SNAP$_IBW_PRODUCT_TIME_M defines the business-key candidate across SITE_ID, TRANSACTION_DATE, LEAF_CATEG_ID, PRODUCT_ID, VISITANT_ID, VISIT_ID, CURRENCY_CD_F, ORDER_ID, QOT_ORDER_ID, CART_ID, ORDERS_SITE_VISITS, ENT_YEAR_ID, ENT_QTR_ID, ENT_PERIOD_ID, WEEK_ID, REPORT_DATE_JULIAN, and D_GID, using SYS_OP_MAP_NONNULL to enforce uniqueness across nullable dimensions.

Common Use Cases and Queries

Primary use cases include product funnel analysis, storefront conversion reporting, and period-over-period revenue comparison. A representative query aggregates booked revenue by product and quarter:

  • SELECT PRODUCT_ID, ENT_QTR_ID, SUM(BOOKED_AMT_F) FROM IBW_PRODUCT_TIME_MV WHERE ENT_YEAR_ID = :year GROUP BY PRODUCT_ID, ENT_QTR_ID;
  • Conversion rate: SUM(ORDERS_SITE_VISITS)/SUM(NO_VISITS) grouped by LEAF_CATEG_ID.
  • Trend analysis using D_BOOKED_AMT_F to isolate incremental period movement.

Related Objects

  • FND_DM_PRODUCTS — joined via PRODUCT_ID for product attributes.
  • AHL_VISITS_B — joined via VISIT_ID for visit header detail.
  • IBW_PRODUCT_TIME — base structure from which this materialized view is derived.
  • IBW_*_MV series — companion aggregate views sharing TIME_ID and ENT_* calendar keys.
  • FND cal/period tables — resolving ENT_YEAR_ID, ENT_QTR_ID, ENT_PERIOD_ID, and WEEK_ID.