Search Results book_to_fulfill_cycle

Overview

The ISC_EDW_BOOK_FULFILL_CYCLE_S view is an Oracle E-Business Suite database object owned by the APPS schema within the Supply Chain Intelligence (ISC) product family. It is a valid, production-grade view that supports the Book to Fulfill Cycle Time report, one of the analytical reports delivered through Oracle's Supply Chain Intelligence and Enterprise Data Warehouse (EDW) reporting layer. The view consolidates transactional booking and fulfillment data from the ISC EDW booking star schema and presents it in a denormalized, dimension-key-oriented format suitable for cycle-time analytics.

The view is documented as valid under both Oracle EBS 12.1.1 and 12.2.2. In the 12.2.2 ETRM metadata, no explicit referenced base objects are enumerated in the header, though the embedded view text identifies the underlying tables. The view is intended for read-only reporting and analytical consumption rather than transactional processing.

Underlying Base Objects

The view is defined over five EDW foundation tables joined together in a star-schema pattern:

• ISC_EDW_BOOKINGS_F — the central fact table containing booking, order, and fulfillment transaction records.
• EDW_GEOGRAPHY_M — a conformed geography dimension supplying area, region, and country keys.
• EDW_ITEMS_M — the item master dimension supplying category and revision keys.
• EDW_TIME_M — the calendar time dimension supplying day, period, quarter, and year keys.
• EDW_ORGANIZATION_M — the organization dimension supplying business group, inventory organization, legal entity, and operating unit keys.
• EDW_LOOKUP_M — a lookup dimension used to restrict results to non-return order categories.

The joins are performed entirely on surrogate primary/foreign keys, which is characteristic of Oracle EDW fact-dimension modeling. The lookup join filters out order categories of 'RMA' and 'RETURN', and the fact table is further restricted to FULFILLMENT_FLAG = 'Y', ensuring only fulfilled bookings are included.

Key Columns

The view exposes a set of foreign-key columns referencing the conformed EDW dimensions, together with the calculated cycle-time metric:

• ORDER_SOURCE_FK — the primary column of interest in the user's search; it identifies the booking order source as a surrogate key from the order source dimension embedded in the bookings fact.
• ORDER_TYPE_FK — the order type surrogate key.
• BOOK_TO_FULFILL_CYCLE — calculated as MAX(DATE_FULFILLED) - BOOKED_DATE, giving the elapsed cycle time in days between booking and fulfillment.
• AREA_FK, COUNTRY_FK, REGION_FK — geographic dimension keys.
• BUS_GRP_FK, INT_ORGA_FK, LEGAL_ENT_FK, OPER_UNIT_FK — organizational dimension keys.
• CATG_FK — item category key.
• SALES_CHANNEL_FK — sales channel surrogate key.
• PERIOD_FK, QTR_FK, YEAR_FK — calendar time keys.
• LINE_ID — the booking line identifier carried through from the fact table as the grouping grain.

The GROUP BY clause establishes the grain at the booking line level, ensuring the cycle calculation reflects the maximum fulfillment date for each line.

Common Use Cases and Queries

The view is most commonly queried by the Book to Fulfill Cycle Time report and by custom analytics requiring average cycle time by order source, sales channel, region, or organization. A typical query filtered on the searched column follows:

• SELECT ORDER_SOURCE_FK, AVG(BOOK_TO_FULFILL_CYCLE) FROM APPS.ISC_EDW_BOOK_FULFILL_CYCLE_S GROUP BY ORDER_SOURCE_FK;
• SELECT SALES_CHANNEL_FK, REGION_FK, AVG(BOOK_TO_FULFILL_CYCLE) FROM APPS.ISC_EDW_BOOK_FULFILL_CYCLE_S GROUP BY SALES_CHANNEL_FK, REGION_FK;
• SELECT PERIOD_FK, YEAR_FK, COUNT(LINE_ID), AVG(BOOK_TO_FULFILL_CYCLE) FROM APPS.ISC_EDW_BOOK_FULFILL_CYCLE_S GROUP BY PERIOD_FK, YEAR_FK;

Because FK columns store surrogate keys, production queries typically join back to the corresponding EDW dimension views (for example, the order source dimension) to resolve descriptive attributes. The view is a read-only analytical object and should not be used for transactional updates.