Search Results sales_channel_fk




Overview
Explore in AI Chat

Overview

ISC_EDW_BOOK_TO_SHIP_CYCLE_S is a Supply Chain Intelligence (ISC) reporting view owned by the APPS schema in Oracle E-Business Suite. It is referenced by the Book to Ship and Book to Pick Cycle Time reports, which are part of the ISC/EDW (Enterprise Data Warehouse) analytics layer that supports order fulfillment performance measurement. The view consolidates booking, geographical, organizational, item, calendar, and lookup dimensions to expose cycle-time measures that quantify the elapsed interval between the order booking date and the latest pick or ship date for a given order line.

The view is a denormalized, star-schema-style construct. Each row carries foreign key surrogate values that map to dimension tables (geography, organization, items, time, and lookup), together with two computed metrics: BOOK_TO_LATEST_PICK_CYCLE and BOOK_TO_LATEST_SHIP_CYCLE. Because the underlying tables use EDW surrogate keys, the view is typically consumed by BI Publisher reports, Oracle Business Intelligence, or custom SQL that joins back to the published EDW dimension views for descriptive attributes.

Underlying Base Objects

ETRM metadata records no referenced base objects, but the view text exposes the actual join graph. The view is defined over five EDW objects:

The query filters to SHIPPABLE_FLAG = 'Y' and aggregates with MAX over pick and ship dates, grouped by booking date, line, and all dimension keys.

Key Columns

  • SALES_CHANNEL_FK — surrogate key to the sales channel dimension; the column referenced by the searched term sales_channel_fk. It distinguishes direct, indirect, web, and other booking channels.
  • AREA_FK, COUNTRY_FK, REGION_FK — geography dimension keys for ship-to location analysis.
  • BUS_GRP_FK, INT_ORGA_FK, LEGAL_ENT_FK, OPER_UNIT_FK — organizational keys covering business group, inventory organization, legal entity, and operating unit.
  • CATG_FK — item category key derived from the top model revision.
  • PERIOD_FK, QTR_FK, YEAR_FK — calendar keys for time-series trending.
  • ORDER_SOURCE_FK, ORDER_TYPE_FK — booking order source and type classification.
  • BOOK_TO_LATEST_PICK_CYCLE, BOOK_TO_LATEST_SHIP_CYCLE — computed cycle-time measures in days.
  • LINE_ID — booking line identifier used for granular grouping.

Common Use Cases and Queries

A typical query analyzes average ship cycle time by sales channel and period:

  • SELECT SALES_CHANNEL_FK, PERIOD_FK, AVG(BOOK_TO_LATEST_SHIP_CYCLE) FROM APPS.ISC_EDW_BOOK_TO_SHIP_CYCLE_S GROUP BY SALES_CHANNEL_FK, PERIOD_FK;
  • Benchmarking pick versus ship cycle times by operating unit and region.
  • Joining keys to EDW dimension views to present descriptive labels in Book to Ship reports.
  • Trending order fulfillment performance across calendar quarters and years.