Search Results isc_edw_book_sum1_f_fcv




Overview
Explore in AI Chat

Overview

ISC_EDW_BOOK_SUM1_F_FCV is an Oracle EBS reporting view belonging to the ISC (Supply Chain Intelligence) product family, which is flagged as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. The view functions as a flattened, denormalized fact-collection layer for the Enterprise Data Warehouse booking summary model, exposing order booking, fulfillment, invoicing, and shipping metrics alongside their associated foreign key surrogates. Its name follows the EDW convention of a fact collection view ("_FCV") within the booking summary star ("BOOK_SUM1"). The view is not implemented in a standard database, meaning it exists only when Supply Chain Intelligence and its associated EDW schema objects have been installed; consequently, references to it in a stock EBS instance will fail unless the obsolete ISC components were provisioned.

Underlying Base Objects

The only documented base object is the synonym or underlying view ISCBV_EDW_BOOK_SUM1_FCV, from which all columns are projected via a straightforward SELECT list with no joins, filters, aggregations, or transformations. In practice this view acts as a publication alias over the ISCBV layer, which itself draws from the EDW booking summary fact and dimension tables. The ETRM metadata documents no additional referenced base tables, and the header identifies no owner, so lineage beyond ISCBV_EDW_BOOK_SUM1_FCV cannot be confirmed from the supplied documentation.

Key Columns

Common Use Cases and Queries

Because the view is obsolete and not implemented by default, most usage scenarios arise in legacy ISC/DSS reporting environments or during migration analysis. Typical queries analyze booking-to-ship latency and fulfillment performance using DATE_LATEST_SHIP.

  • Ship-date analysis: SELECT ORDER_NUMBER, DATE_ORDERED, DATE_LATEST_SHIP, SHIPPED_AMT_B FROM ISC_EDW_BOOK_SUM1_F_FCV WHERE DATE_LATEST_SHIP >= :start_date;
  • On-time delivery: compare DATE_LATEST_SHIP against DATE_ORDERED to flag late shipments.
  • Financial rollup: aggregate BOOKED_AMT_G and SHIPPED_AMT_G by SET_OF_BOOKS_FK or OPERATING_UNIT_FK.
  • Star-schema joins: link the _FK surrogate columns to the matching EDW date, customer, and currency dimensions.

Before relying on this view, confirm installation of the obsolete ISC schema and validate the underlying ISCBV_EDW_BOOK_SUM1_FCV object, since the metadata confirms the view is not present in a standard database.