Results for “mtl_cc_graph_wk_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_CC_GRAPH_WK_V is an Oracle E-Business Suite Inventory (INV) reporting view associated with the cycle count graphing and analysis functionality. Its ETRM metadata carries the description "10SC ONLY," indicating that the view is confined to a specific ten-schema configuration rather than being deployed across the general EBS installation base. In the Oracle 12.1.1 and 12.2.2 releases, the view is catalogued as not implemented in the reference database, meaning the DDL may be present in the product source but is not instantiated as a live database object in the standard environment.
The view presents weekly aggregated cycle count performance metrics. It transforms row-level cycle count entry data into per-organization, per-header, per-week summaries that distinguish accurate counts (hits) from inaccurate counts (misses), and that quantify the financial and quantity impact of count adjustments. Its role in EBS reporting is to supply the dataset behind cycle count accuracy trending, typically rendered as graphical or tabular accuracy statistics for inventory management review.
Underlying Base Objects
The view text references three Inventory base tables:
- MTL_CYCLE_COUNT_ENTRIES (aliased MCCE) — the driving table, holding individual count entry records, including system quantity, counted quantity, adjustment quantity, adjustment amount, and count date.
- MTL_CYCLE_COUNT_CLASSES (aliased MCCC) — the cycle count class definitions, supplying class-level hit/miss tolerance values.
- MTL_CYCLE_COUNT_HEADERS (aliased MCCH) — the cycle count header records, supplying header-level hit/miss tolerance values where class-level tolerances are not defined.
The three tables are joined on ORGANIZATION_ID and CYCLE_COUNT_HEADER_ID. The documented metadata lists no referenced base objects, so the relationship above is derived from the view text itself. The tolerance resolution logic applies NVL against the class tolerance first, falling back to the header tolerance, establishing the acceptable variance threshold used to classify each count as a hit or a miss.
Key Columns
- ORGANIZATION_ID — the inventory organization to which the aggregated counts belong.
- CYCLE_COUNT_HEADER_ID — the cycle count header that groups the counted items.
- HITS — the number of count entries whose deviation from system quantity falls within the applicable tolerance.
- MISSES — the number of count entries outside tolerance, plus entries where the system quantity is zero.
- TOTAL_COUNTS — the total number of cycle count entries in the aggregation group.
- POS_ADJ_VALUE — the sum of positive adjustment amounts.
- NEG_ADJ_VALUE — the sum of negative adjustment amounts.
- TRANSACTED — the count of entries carrying a non-zero adjustment quantity.
- WEEK_START_DATE — the week bucket, computed as TRUNC(COUNT_DATE_FIRST,'DAY').
Common Use Cases and Queries
The principal use case is weekly cycle count accuracy reporting by organization, supporting hit-rate and miss-rate analysis and adjustment value tracking.
- Hit and miss ratio per week: SELECT organization_id, week_start_date, hits, misses, total_counts, ROUND(hits*100/total_counts,2) hit_pct FROM mtl_cc_graph_wk_v ORDER BY organization_id, week_start_date;
- Adjustment exposure: SELECT organization_id, week_start_date, pos_adj_value, neg_adj_value, (pos_adj_value + neg_adj_value) net_adj FROM mtl_cc_graph_wk_v ORDER BY week_start_date;
- Transacted count volume: SELECT cycle_count_header_id, week_start_date, transacted FROM mtl_cc_graph_wk_v WHERE transacted > 0;
Because the view is documented as 10SC ONLY and not implemented in the reference database, availability must be verified against the target environment before use. Where the view is absent, equivalent logic can be constructed directly over MTL_CYCLE_COUNT_ENTRIES, MTL_CYCLE_COUNT_CLASSES, and MTL_CYCLE_COUNT_HEADERS.
-
View: MTL_CC_GRAPH_WK_V 12.1.1
10SC ONLY
Not implemented in this database·Explore INV module →
-
View: MTL_CC_GRAPH_WK_V 12.2.2
10SC ONLY
Not implemented in this database·Explore INV module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2