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:
- SITE_ID, PRODUCT_ID, VISIT_ID — core dimension keys identifying storefront, product, and visit context. PRODUCT_ID and VISIT_ID carry foreign keys to FND_DM_PRODUCTS and AHL_VISITS_B respectively.
- TRANSACTION_DATE, REPORT_DATE_JULIAN, TIME_ID — temporal dimensions supporting daily, Julian, and hierarchical time slicing.
- ENT_YEAR_ID, ENT_QTR_ID, ENT_PERIOD_ID, WEEK_ID — enterprise calendar rollups for period-based aggregation.
- LEAF_CATEG_ID, CURRENCY_CD_F — category and currency dimensional filters.
- NO_VISITS, PAGE_VIEWS, ORDERS_SITE_VISITS — traffic and engagement measures.
- BOOKED_AMT_F, BOOKED_AMT_G, BOOKED_AMT_G1 — booked revenue in functional and reporting currencies.
- D_NO_VISITS, D_PAGE_VIEWS, D_BOOKED_AMT_F, D_BOOKED_AMT_G, D_BOOKED_AMT_G1, D_TOT_COL — delta measures enabling incremental refresh comparisons.
- ORDER_ID, QOT_ORDER_ID, CART_ID, VISITANT_ID — conversion-path identifiers linking visits to quotes, carts, and orders.
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.
-
VIEW: IBW.IBW_SITE_VISITS# 12.2.2
-
VIEW: IBW.IBW_PAGE_VIEWS# 12.2.2
-
TABLE: APPS.IBW_PRODUCT_MV 12.1.1
-
TABLE: APPS.IBW_PAGE_SA_MV 12.1.1
-
VIEW: IBW.IBW_SITE_VISITS# 12.2.2
-
VIEW: IBW.IBW_PAGE_VIEWS# 12.2.2
-
TABLE: IBW.IBW_SITE_VISITS 12.1.1
-
TABLE: IBW.IBW_SITE_VISITS 12.2.2
-
TABLE: IBW.IBW_PAGE_VIEWS 12.2.2