Search Results user_attribute25




Overview
Explore in AI Chat

Overview

ISCBV_EDW_BOOK_SUM1_FCV is a valid APPS-owned view within the Oracle E-Business Suite Supply Chain Intelligence (ISC) product family. It functions as a flattened, pre-aggregated presentation layer for booking summary data consumed by the Enterprise Data Warehouse (EDW) and Supply Chain Intelligence reporting stack. The naming convention — "EDW," "BOOK," "SUM1," and the "FCV" suffix — indicates that this object is a summary-level (SUM1) bookings fact view, with "FCV" denoting a flattened/consumable view variant intended for downstream analytical consumption rather than transactional data entry.

The view exposes bookings metrics that support order-to-cash and booking-analysis reporting, presenting amounts measured in both base currency (the _B suffix) and global/functional currency (the _G suffix). It is designed to be queried directly by BI Publisher reports, OBIEE/OBIA dashboards, custom extracts, and EDW ETL routines that populate fact and dimension tables. As a database view in the APPS schema, it carries no independent storage and inherits the security posture of its owning schema and any synonyms or grants layered over it.

Underlying Base Objects

The view's defining query selects from the base object ISCBV_EDW_BOOK_SUM1_BASE_FCV. That base view supplies the granular booking rows, and ISCBV_EDW_BOOK_SUM1_FCV applies GROUP BY logic and aggregate functions to consolidate them into the summarized shape described in its definition. No additional base tables are documented for this view; the aggregation and grouping are performed entirely over the columns emitted by the base FCV. The ETRM metadata records no independently documented referenced base tables, so the relationship should be understood strictly as a summary-over-base-view dependency, where the summary view is the public interface and the base view remains the internal staging layer.

Key Columns

The column list reflects a star-schema-oriented design with foreign key references, degenerate dimensions, and additive measures.

Common Use Cases and Queries

This view is typically used for booking trend analysis, currency-converted revenue summaries, and fulfillment-versus-booking comparisons. A representative query totaling booked and invoiced amounts by ordering unit and currency follows:

  • SELECT OPERATING_UNIT_FK, CURRENCY_BASE_FK, SUM(BOOKED_AMT_G) booked, SUM(INVOICED_AMT_G) invoiced FROM ISCBV_EDW_BOOK_SUM1_FCV GROUP BY OPERATING_UNIT_FK, CURRENCY_BASE_FK;
  • Trend analysis by booked date: SELECT DATE_BOOKED, SUM(BOOKED_AMT_G) FROM ISCBV_EDW_BOOK_SUM1_FCV GROUP BY DATE_BOOKED ORDER BY DATE_BOOKED;
  • Fulfillment gap: SELECT ORDER_NUMBER, SUM(BOOKED_AMT_G) - SUM(FULFILLED_AMT_G) gap FROM ISCBV_EDW_BOOK_SUM1_FCV GROUP BY ORDER_NUMBER;
  • Customer-level summaries joined by BILL_TO_CUST_FK, or set-of-books reporting via SET_OF_BOOKS_FK.

Because the view already aggregates, consumers should avoid re-aggregating at a finer grain than the GROUP BY keys above, and should apply the same operating unit security context enforced elsewhere in ISC reporting.