Search Results isc_dr_bklg_01_mv




Overview
Explore in AI Chat

Overview

ISC_DR_BKLG_01_MV is a materialized view in the Oracle E-Business Suite Application Object Library (FND) schema, owned by APPS. Its name follows the depot repair backlog reporting convention (ISC_DR_BKLG), where "DR" denotes Depot Repair and "BKLG" denotes backlog. The object consolidates repair order backlog metrics across organization, customer, product category, and time dimensions, making it a denormalized aggregate used primarily for service and repair analytics rather than for transactional processing.

The ETRM metadata classifies this object heuristically as standalone from a Data Vault perspective. It does not behave as a classic hub, link, or satellite; in a Data Vault model it is best treated as a derived reporting aggregate or computed satellite snapshot, refreshed from underlying repair order and time-dimension sources. The metadata also records that the object is "Not implemented in this database," meaning ISC_DR_BKLG_01_MV is optional and only present when the relevant Depot Repair reporting feature has been deployed and the concurrent program that populates it has been run.

Key Information Stored

The documented physical schema contains 32 columns. Dimension columns form the grain of the aggregate, while measure columns capture backlog counts and aging distribution.

The unique index I_SNAP$_ISC_DR_BKLG_01_MV spans REPAIR_ORGANIZATION_ID, REPAIR_TYPE_ID, YEAR_ID, CUSTOMER_ID, PRODUCT_CATEGORY_ID, ITEM_ORG_ID, QTR_ID, MONTH_ID, WEEK_ID, DAY_ID, and GRP_ID_MV, and is the documented business-key candidate. No separate named surrogate primary key column is documented; the index uses SYS_OP_MAP_NONNULL wrappers to enforce uniqueness across nullable dimension values.

Common Use Cases and Queries

Typical usage is backlog aging and service-level reporting for depot repair operations. Analysts query the view directly rather than joining the base repair tables.

Backlog by repair type for a period:

SELECT repair_type_id, SUM(open_count), SUM(close_count)
FROM   isc_dr_bklg_01_mv
WHERE  year_id = :p_year AND period_type_id = :p_period
GROUP  BY repair_type_id;

Aging-band analysis uses the DAYS_LATE_AGE_B1 through B10 columns, while trend reporting groups by YEAR_ID, QTR_ID, MONTH_ID, WEEK_ID, or DAY_ID depending on PERIOD_TYPE_ID. Customer and product-category drill-downs filter on CUSTOMER_ID and PRODUCT_CATEGORY_ID respectively, and AGGREGATION_FLAG can be used to isolate the aggregate rows produced by the refresh.

Related Objects

  • CSD_REPAIR_TYPES_B — referenced by REPAIR_TYPE_ID; source of repair type definitions.
  • JAI_FA_AST_YEARS — referenced by YEAR_ID; supplies fiscal year context for time grouping.
  • CSD_REPAIR_ORDERS — the depot repair order base table from which backlog counts are derived.
  • MTL_SYSTEM_ITEMS_B — item master supporting PRODUCT_CATEGORY_ID and ITEM_ORG_ID resolution.
  • HZ_CUST_ACCOUNTS — customer dimension source for CUSTOMER_ID.
  • ISC_DR_BKLG_01 — the materialized view's underlying base object or staging counterpart within the same reporting family.

Because the object is not always implemented, confirm its presence in DBA_MVIEWS before referencing it in custom concurrent programs or reports.