Results for “isc_num_booked_orders”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.ISC_OPI_IND_CR_TAB_BASE_V is a reporting view within the Oracle E-Business Suite (EBS) Enterprise Trading and Risk Management / Supply Chain Intelligence (ISC) product family. Its purpose is to expose the current quarter-to-date (QTD) and current week-to-date performance measures used by the Order-to-Cash and Operational Performance Indicator (OPI) dashboards. The view consolidates booked, shipped, invoiced, revenue, and cash-collection metrics into a single, unpivoted result set, keyed by set-of-books.

The view is defined using a nested subquery against a set of warehouse/BI objects (FII_AR_OPERATIONS_SUMMARY, EDW_GL_BOOK_M, BISBV_PERFORMANCE_MEASURES) plus a DUAL-derived dated driver. The presence of FII_TIME_WH_API.GET_CURR_EQTR_START and FII_TIME_WH_API.TODAY indicates that period boundaries are resolved dynamically at query time, making the view suitable for real-time dashboard refreshes rather than fixed-batch extracts. The view is dedicated to the six ISC performance measures and is intended for use by OPI dashboard regions that render indicator tiles filtered by operating-unit / book context.

Underlying Base Objects

The ETRM metadata lists no documented base objects (referenced base objects: none documented). However, the view SQL itself explicitly references the following objects:

• FII_AR_OPERATIONS_SUMMARY — the warehouse fact that supplies the actual measure values (order_count, amt_booked_g, amt_shipped_g, amt_invoiced_ar_g, amt_rev_earned_g, amt_cash_received_g) at the calendar-date grain.
• EDW_GL_BOOK_M — the general-ledger book dimension; joined on set_of_books_fk_key = fabk_fa_book_pk_key to supply SOBL_BOOK_PK_KEY.
• BISBV_PERFORMANCE_MEASURES — the measure metadata (measure name and short name) used for the DECODE pivots.
• DUAL-derived inline view — supplies CURR_START and CURR_TODAY via the FII_TIME_WH_API package for quarter/week boundary resolution.

Key Columns

• SOBL_BOOK_FK_KEY — the set-of-books foreign key; the reporting grain for the view.
• MEASURE_NAME — the descriptive name of the measure (from BISBV_PERFORMANCE_MEASURES).
• MEASURE_QTD — quarter-to-date value of the measure. The DECODE maps each measure_short_name to its source column, including ISC_NUM_BOOKED_ORDERS → order_count.
• MEASURE_WK — week-to-date value. This is populated only when the calendar date falls within the current week (weeks-since-start equals 0); otherwise the expression returns 0.
• SORT_ORDER — a numeric ordering key (1 through 6) used to render the measures in a fixed display sequence on the dashboard.

Note that order_count is not exposed as a standalone column; it is translated by the DECODE into the MEASURE_QTD and MEASURE_WK expressions whenever measure_short_name = 'ISC_NUM_BOOKED_ORDERS'. This is why a search for "order_count" resolves to this view.

Common Use Cases and Queries

The view is typically consumed by OPI indicator pages that display a set of tiles for the current quarter. A representative query is:

• Fetch all measures for a given book, ordered for display:
  SELECT measure_name, measure_qtd, measure_wk, sort_order
FROM apps.isc_opi_ind_cr_tab_base_v
WHERE sobl_book_fk_key = :book_id
ORDER BY sort_order;
• Retrieve only the booked-order count for a specific book:
  SELECT measure_qtd, measure_wk
FROM apps.isc_opi_ind_cr_tab_base_v
WHERE sobl_book_fk_key = :book_id
AND measure_name = 'ISC_NUM_BOOKED_ORDERS';

Because the view performs the quarter-to-date roll-up internally, consumers do not need to join to the time dimension or apply their own date filters; the WHERE clause only needs to restrict by book and, optionally, measure name. This design makes the view a convenient, single-row-per-measure source for dashboard tiles and for cross-checking OPI indicators against the underlying FII_AR_OPERATIONS_SUMMARY facts during reconciliation.