Search Results isc_dbi_cpm_002_mv




Overview
Explore in AI Chat

Overview

ISC_DBI_CPM_002_MV is a materialized view owned by the APPS schema within Oracle E-Business Suite, catalogued under the product family ISC – Supply Chain Intelligence. In ETRM release 12.1.1 the object is documented with a physical schema of 21 columns, and it is flagged as obsolete in the ISC module. The ETRM record states "Not implemented in this database," indicating the definition exists in the reference metadata but was not instantiated in the target instance examined. The "DBI" prefix and "MV" suffix identify it as a Supply Chain Intelligence business-intelligence aggregation, a denormalized snapshot maintained for analytic reporting rather than transactional processing.

Heuristic Data Vault classification, mined from the foreign-key structure, returns standalone. No parent-child links beyond a single reference to FND_DM_PRODUCTS were detected, and no dependent tables were identified. From a modeling standpoint this object is therefore best treated as a satellite-like aggregation rather than a true hub or link: it carries descriptive and additive measures keyed by a composite business grain, with no downstream dependency chain.

Key Information Stored

The view stores a multidimensional aggregation of booked and returned transaction amounts, sliced by customer, item category, time, and organizational grouping. The most significant columns are:

The unique index I_SNAP$_ISC_DBI_CPM_002_MV defines the business-key candidate grain: CLASS_CODE, CUSTOMER_ID, ITEM_CATEGORY_ID, PRODUCT_ID, ENT_QTR_ID, ENT_PERIOD_ID, WEEK_ID, REPORT_DATE_JULIAN, CUSTOMER_FLAG, ITEM_CAT_FLAG, and GRP_ID, each wrapped in SYS_OP_MAP_NONNULL. No separate surrogate primary key column is documented.

Common Use Cases and Queries

Typical usage centers on period-over-period booked-versus-returned analysis, customer and item-category profitability, and trend reporting across the week/period/quarter hierarchy.

  • Booked-to-returned ratio by product and quarter, grouping on ENT_QTR_ID and summing BOOKED_AMT_G against RETURNED_AMT_G.
  • Customer-level net revenue, filtering CUSTOMER_FLAG to the appropriate aggregation level.
  • Comparison reporting between BOOKED_AMT_G and BOOKED_AMT_G1 to expose shift between two aggregation dimensions.
  • Trend lines driven by REPORT_DATE_JULIAN or WEEK_ID for the C-prefixed calculated measures.

Sample pattern: SELECT PRODUCT_ID, ENT_QTR_ID, SUM(BOOKED_AMT_G), SUM(RETURNED_AMT_G) FROM ISC_DBI_CPM_002_MV WHERE CUSTOMER_FLAG = 'Y' GROUP BY PRODUCT_ID, ENT_QTR_ID;

Related Objects

  • FND_DM_PRODUCTS – joined on ISC_DBI_CPM_002_MV.PRODUCT_ID = FND_DM_PRODUCTS.PRODUCT_ID; the sole documented foreign-key relationship.
  • ISC_DBI_CPM_001_MV and sibling ISC_DBI_CPM_00x_MV aggregations – parallel Supply Chain Intelligence snapshots sharing dimension keys (CUSTOMER_ID, ITEM_CATEGORY_ID, time hierarchy) for combined reporting.
  • ISC_DBI_MV family views – additional DBI materialized views in the same product that reuse PRODUCT_ID and the shared time columns.

Because the table is obsolete and documented as not implemented, integration effort should confirm whether a replacement view or native DBI subject area now serves the same analytic requirement.