Search Results net_bookings_at_list

Overview

The ISC_EDW_BOOKINGS_BILLINGS_S view is an Oracle E-Business Suite database object owned by the APPS schema with a status of VALID. It resides in the ISC product family, which is Supply Chain Intelligence, the EBS module that supplies the operational data foundation for supply chain analytics and data-warehouse style reporting. As documented, the view is used by the Bookings reports.

Functionally, the view is a star-schema style summary (denoted by the "_S" suffix convention used in ISC EDW objects) that consolidates booking, billing, cancellation, return, and margin measures against a set of pre-resolved dimensional foreign keys. It exposes fact measures such as NET_BOOKINGS, GROSS_BOOKINGS, BILLINGS, COGS, DISCOUNTS, GROSS_MARGIN, and NET_BOOKINGS_AT_LIST alongside dimension keys for area, region, country, business group, category, operating unit, legal entity, sales channel, order source, order type, and calendar period, quarter, and year. Because the arithmetic is embedded in the view definition, consumers of the Bookings reports receive consistent, pre-calculated business metrics rather than reconciling raw transaction tables themselves.

The user term "net_bookings" corresponds directly to a projected column of this view, making the object the authoritative source for that metric in the ISC reporting layer.

Underlying Base Objects

The documented ETRM view text selects from a single aliased source, BOOKINGS, from which all measure columns are derived. The remaining keys originate from aliased dimension sources: GEO (geography), ORG (organization), ITEM (category), and TIME (calendar). In the ISC EDW model, these aliases typically correspond to pre-built dimension views or summary tables ending in the ISC EDW naming convention (for example geographic, organization, item category, and calendar period dimension objects). The ETRM metadata does not enumerate the referenced base tables, so the exact physical table names behind the BOOKINGS, GEO, ORG, ITEM, and TIME aliases should be confirmed against the view's full DDL or the ISC EDW data model in the target instance.

The join relationships are expressed through surrogate key columns (columns ending in "_FK" or "_FK_KEY"), indicating that the view is designed to be joined back to dimension objects in the ISC EDW schema on those keys.

Key Columns

• NET_BOOKINGS — UNIT_SELL_PRC_G × QTY_ORDERED less UNIT_SELL_PRC_G × QTY_RETURNED; the true selling-price value of booked orders net of returns.
• GROSS_BOOKINGS — selling price × quantity ordered plus selling price × quantity cancelled.
• NET_BOOKINGS_AT_LIST — list price × quantity ordered less list price × quantity returned.
• BILLINGS — selling price × quantity invoiced less selling price × quantity returned.
• CANCELLATIONS, RETURNS — selling price × cancelled quantity and selling price × returned quantity, respectively.
• COGS — unit cost × quantity ordered less unit cost × returned quantity.
• DISCOUNTS — (list price − selling price) × ordered quantity, adjusted for returns.
• GROSS_MARGIN — (selling price − unit cost) × ordered quantity, adjusted for returns.
• Dimensional keys: AREA_FK, REGION_FK, COUNTRY_FK, BUS_GRP_FK, CATG_FK, INT_ORGA_FK, LEGAL_ENT_FK, OPER_UNIT_FK, ORDER_SOURCE_FK, ORDER_TYPE_FK, SALES_CHANNEL_FK, PERIOD_FK, QTR_FK, YEAR_FK.

All NVL calls default missing price components to zero, so measure columns return numeric values even when pricing is absent.

Common Use Cases and Queries

This view supports Bookings analysis and margin reporting across organizational and geographic dimensions. A representative query aggregates net bookings by year and operating unit:

• SELECT YEAR_FK, OPER_UNIT_FK, SUM(NET_BOOKINGS) net_bkg FROM APPS.ISC_EDW_BOOKINGS_BILLINGS_S GROUP BY YEAR_FK, OPER_UNIT_FK;
• Comparing NET_BOOKINGS to BILLINGS highlights the gap between orders and invoiced revenue.
• GROSS_MARGIN and DISCOUNTS support profitability and pricing-effectiveness reporting.
• Joining the dimension keys to ISC EDW dimension views enables drill-down by region, country, category, sales channel, or period.

Because the measures are pre-computed, the view is well suited to ad-hoc analysis, OBIEE/BI Publisher Bookings reports, and any downstream extraction that requires a single consistent definition of net bookings.