Search Results isc_dr_charges_01_mv




Overview
Explore in AI Chat

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

Overview

ISC_DR_CHARGES_01_MV is an APPS-owned materialized view (exposed through the FND – Application Object Library product registration) that consolidates depot repair charge data for reporting and analytics within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The object is part of the Depot Repair (ISC) schema family and aggregates material, labor, and expense charges across repair organizations, customers, products, and multiple time hierarchies. Its 26 documented columns hold both aggregated monetary measures and supporting count metrics used by Oracle's business intelligence layer.

The ETRM metadata classifies this object heuristically as standalone from a Data Vault perspective, meaning no parent-child FK chain was mined from its structure itself (it holds the FK, but is not referenced by others). In a Data Vault model this would typically suggest a satellite pattern — a table carrying descriptive measures keyed by a composite business key — rather than a hub or link. The unique index I_SNAP$_ISC_DR_CHARGES_01_ on the ten business attributes reinforces this satellite-style interpretation.

Key Information Stored

The materialized view's grain is defined by the composite business key enforced by the unique index, comprising ten dimension attributes:

The measure columns capture charges split by cost type and by the G (global/organization) versus SG (secondary grouping) allocation basis: MATERIAL_CHARGES_G / _SG, LABOR_CHARGES_G / _SG, and EXPENSE_CHARGES_G / _SG. Parallel MV_*_CNT columns (MV_MATERIAL_CHARGES_G_CNT, MV_LABOR_CHARGES_SG_CNT, etc.) plus MV_CNT provide record counts supporting weighted averages and reconciliation. No surrogate single-column primary key is documented; the ten-attribute unique index serves as the business-key candidate.

Common Use Cases and Queries

This MV is typically used by Oracle Depot Repair reporting and Oracle Business Intelligence applications to present repair cost summaries without querying the transactional tables directly. A common pattern aggregates material and labor charges by repair organization and period:

  • SELECT rep_org, period_id, SUM(material_charges_g + labor_charges_g + expense_charges_g) FROM isc_dr_charges_01_mv GROUP BY rep_org, period_id;
  • Filtering by AGGREGATION_FLAG to select a specific roll-up level.
  • Joining REPAIR_TYPE_ID to CSD_REPAIR_TYPES_B to decode repair type descriptions.
  • Comparing G versus SG charge columns to analyze allocation differences.

Because it is a materialized view, refresh behavior and staleness should be verified before using it for real-time reporting; for point-in-time needs, DBMS_MVIEW.REFRESH may be invoked.

Related Objects

These relationships allow the MV to be integrated into standard depot repair and cost analytics dashboards.