Search Results isc_opi_top_ord_wk_base_v

Overview

ISC_OPI_TOP_ORD_WK_BASE_V is a reporting view historically shipped with the Oracle Supply Chain Intelligence (ISC) product, an operational and executive reporting application built on the Oracle E-Business Suite data warehouse. The view is documented in Oracle's ETRM metadata as belonging to the ISC module, which Oracle has since designated as Obsolete. In ETRM 12.2.2 the object is explicitly flagged as "Not implemented in this database," meaning the view and its underlying semantic-layer tables are not created or maintained in current EBS 12.1.1 and 12.2.2 installations. It survives as a legacy definition that illustrates how ISC reported weekly "top orders" rankings derived from the ISC EDW aggregate and dimension layers.

The view presents a ranked, seven-day rolling snapshot of booked orders aggregated by customer, operating unit (ledger), calendar day, and set of books. Its purpose was analytic: to expose the top orders by net booked value within the current equal-time reporting window, enriched with shipped, fulfilled, and invoiced measures. The presence of the RANK() analytic function identifies it as a "top-N" base view, typically consumed by an ISC dashboard or Discoverer worksheet that filtered on RANK.

Underlying Base Objects

The view text selects from five documented ISC EDW objects, all star-schema components:

• ISC_EDW_BOOK_SUM1_F — the booking summary fact, supplying order number, booked/shipped/fulfilled/invoiced amounts and their associated dates.
• EDW_TRD_PARTNER_M — the trade partner (customer) dimension, joined on bill-to customer location.
• EDW_ORGANIZATION_M — the organization dimension, joined on operating unit.
• EDW_TIME_M — the calendar day dimension for the booking date.
• EDW_GL_BOOK_M — the set-of-books (ledger) dimension.

No base Oracle EBS transactional tables (for example, OE_ORDER_HEADERS_ALL) are referenced directly; the view sits strictly above the ISC warehouse. Date filtering calls FII_TIME_WH_API.GET_CURR_EQTR_START and FII_TIME_WH_API.TODAY, restricting rows to the current equal-time quarter start through today, and further to the last seven days.

Key Columns

• SOBL_BOOK_FK_KEY — surrogate key to the ledger dimension.
• OPER_UNIT_FK_KEY — surrogate key to the operating unit dimension.
• CAL_DAY_FK_KEY — booking-day calendar key.
• TPRT_FK_KEY — trade partner (customer location) key.
• ORDER_NUMBER / CUSTOMER_NAME / ORDERED_DATE — descriptive order attributes.
• NET_BOOKED_VALUE / BOOKED_DATE — total net booked amount and its date.
• SHIPPED_VALUE / LATEST_SHIP_DATE, FULFILLED_VALUE / FULFILLED_DATE, INVOICED_VALUE — downstream fulfillment measures.
• HEADER_ID — source order header identifier.
• NUM_OF_ORDERS — constant 1, enabling summation.
• RANK — RANK() OVER (ORDER BY BOOKED_AMT_G DESC), the top-order ranking.

Common Use Cases and Queries

The principal use case was a "Top Orders — Last 7 Days" dashboard that ranked orders by net booked value for the current quarter, drillable by customer, operating unit, and ledger.

SELECT customer_name,
       order_number,
       net_booked_value,
       booked_date,
       rank
FROM   isc_opi_top_ord_wk_base_v
WHERE  rank <= 20
ORDER  BY rank;

Analysts also aggregated by customer to summarize weekly booking performance:

SELECT customer_name,
       SUM(num_of_orders)   AS order_count,
       SUM(net_booked_value) AS booked_value,
       SUM(shipped_value)    AS shipped_value
FROM   isc_opi_top_ord_wk_base_v
GROUP  BY customer_name
ORDER  BY booked_value DESC;

Because ISC is obsolete and the view is not implemented in ETRM 12.2.2, these queries are relevant only to historical ISC environments or as reference patterns. In current deployments, equivalent reporting should be sourced from Oracle Order Management and the available BI Publisher or OTBI data models.