Search Results unit_sell_prc_g




Overview
Explore in AI Chat

Overview

APPS.ISC_EDW_BOOKINGS_F_FCV is a flat, denormalized reporting view within the Oracle E-Business Suite (EBS) Supply Chain Intelligence / Enterprise Data Warehouse (EDW) layer. In both 12.1.1 and 12.2.2, it exposes booking-level order and demand data in a star-schema-friendly shape, presenting foreign-key surrogate identifiers alongside a wide set of descriptive and quantitative measures. The view serves as a canonical extraction source for order bookings analytics, supporting downstream ETL into the EDW fact tables as well as ad hoc reporting against order fulfillment, pricing, and demand metrics.

The "FCV" suffix denotes this as a conformed (flat) view intended for consistent use across reporting contexts. It flattens order header and line attributes — booking identifiers, customer and location references, pricing measures, and quantity measures — into a single queryable surface, removing the need for report authors to join order headers to their lines manually.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: ISCBV_BOOKINGS_FCV. No other base tables or views are listed, and no owner is documented in the 12.2.2 metadata extract. The view is defined as a straightforward SELECT over ISCBV_BOOKINGS_FCV, projecting its columns and appending a series of constant and null placeholders — most notably the literal string 'NA_EDW' repeated across a block of trailing columns, and several to_number(NULL) expressions.

These placeholder columns are a standard EDW convention: they preserve positional alignment with the target fact table definition, ensuring that the select list shape matches the downstream ETL contract even where the source does not supply meaningful values. Because the view reads from ISCBV_BOOKINGS_FCV and that source is itself a derived object, effective lineage ultimately traces back to order management (OE) header and line tables, though those base tables are not documented in the provided metadata.

Key Columns

The view exposes three broad categories of columns:

The search term date_scheduled_fk corresponds to both DATE_SCHEDULED_FK (the date dimension surrogate key) and its unused companion SCHEDULED_DATE (the raw date value carried in the same select list). Reports filter or group on DATE_SCHEDULED_FK to resolve scheduling date attributes through the date dimension.

Common Use Cases and Queries

Typical usage involves aggregating booking measures by one or more dimensions, or filtering to a set of scheduled dates. A representative query is:

  • SELECT ORDER_NUMBER, CUSTOMER_FK, DATE_SCHEDULED_FK, QTY_ORDERED, TOTAL_NET_ORDER_VALUE FROM APPS.ISC_EDW_BOOKINGS_F_FCV WHERE DATE_SCHEDULED_FK = :p_date_key;
  • Aggregation by sales channel or operating unit: SELECT OPERATING_UNIT_FK, SALES_CHANNEL_FK, SUM(TOTAL_NET_ORDER_VALUE) FROM APPS.ISC_EDW_BOOKINGS_F_FCV GROUP BY OPERATING_UNIT_FK, SALES_CHANNEL_FK;
  • Fulfillment analysis: SELECT ORDER_NUMBER, QTY_ORDERED, QTY_SHIPPED, QTY_FULFILLED FROM APPS.ISC_EDW_BOOKINGS_F_FCV WHERE FULFILLMENT_FLAG = 'Y';

Because the view is intended for read-only analytics, query optimization depends on the statistics of the underlying ISCBV_BOOKINGS_FCV rather than on any DML capability of the view itself.