Results for “mtl_cc_graph_day_v”

4 results




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

Overview

MTL_CC_GRAPH_DAY_V is a reporting view in the Oracle Inventory (INV) module that consolidates cycle count performance data at the organization, cycle count header, and count date level. Per the ETRM metadata, the view is documented with the description "10SC ONLY" and is explicitly noted as Not implemented in this database. This indicates the view was historically shipped for the Discrete/Process manufacturing "10SC" configuration context and may not exist in every Oracle EBS 12.1.1 or 12.2.2 installation.

The view is designed to feed cycle count accuracy graphs and hit/miss analytics by day. It aggregates raw cycle count entry lines and produces summary metrics such as hits, misses, total counts, adjustment values, and a truncated count date. This makes it suitable for dashboards and periodic accuracy reporting rather than transactional processing.

Underlying Base Objects

The view is defined over three core Inventory cycle counting tables:

  • MTL_CYCLE_COUNT_ENTRIES (MCCE) — the primary source of individual count lines, including system quantity, count quantity, adjustment amount, adjustment quantity, and count date.
  • MTL_CYCLE_COUNT_CLASSES (MCCC) — supplies class-level hit/miss tolerance settings (positive and negative).
  • MTL_CYCLE_COUNT_HEADERS (MCCH) — supplies header-level tolerance values used as a fallback via NVL when class-level tolerances are null.

Joins are performed on ORGANIZATION_ID and CYCLE_COUNT_HEADER_ID across all three tables. Only entries where COUNT_QUANTITY_FIRST is not null are included, and results are grouped by organization, header, and the truncated count date. The ETRM metadata records no additional referenced base objects beyond these, and lists the owner as undocumented.

Key Columns

  • ORGANIZATION_ID — the inventory organization for the cycle count activity.
  • CYCLE_COUNT_HEADER_ID — the cycle count header identifying the cycle count definition.
  • COUNT_DATE_FIRST — the count date, truncated to the day using TRUNC(...,'J'), which is the basis for daily grouping. This column is directly relevant to the user's search term "count_date_first."
  • HITS — the sum of entries considered within tolerance, computed by comparing the percentage variance against the applicable positive or negative tolerance.
  • MISSES — the sum of entries outside tolerance, including entries with a zero system quantity.
  • TOTAL_COUNTS — the total number of count entries (SUM(1)).
  • POS_ADJ_VALUE / NEG_ADJ_VALUE / ABS_ADJ_VALUE — positive, negative, and absolute adjustment amounts, respectively.
  • TRANSACTED — count of entries with a non-zero adjustment quantity.

Common Use Cases and Queries

This view supports cycle count accuracy trending by day, hit/miss ratio reporting, and adjustment value analysis. A typical query retrieves daily accuracy figures for an organization:

  • SELECT organization_id, count_date_first, hits, misses, total_counts, abs_adj_value FROM mtl_cc_graph_day_v WHERE organization_id = :org_id ORDER BY count_date_first;
  • SELECT count_date_first, SUM(hits), SUM(misses), SUM(total_counts) FROM mtl_cc_graph_day_v GROUP BY count_date_first;
  • SELECT cycle_count_header_id, SUM(transacted), SUM(abs_adj_value) FROM mtl_cc_graph_day_v GROUP BY cycle_count_header_id;

Because the view is documented as "10SC ONLY" and not implemented in all databases, availability should be confirmed against the target instance before relying on it in custom reports or integrations.