Results for “pos_adj_value”

12 results




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

Overview

MTL_CC_GRAPH_QTR_V is a read-only inventory view in Oracle E-Business Suite that presents quarterly cycle count performance summary data. It is documented in ETRM under product INV (Inventory) and is explicitly flagged in the metadata with the description "10SC ONLY." This designation indicates that the object belongs to a restricted or specialized deployment context and is not part of the general-purpose inventory schema for standard 12.1.1 or 12.2.2 installations. The ETRM 12.2.2 metadata further notes that the view is "Not implemented in this database," confirming that it may not be present or created during a normal upgrade or fresh install.

The view's role is analytical rather than transactional. It aggregates cycle count entries by organization, cycle count header, and quarter start date, producing summary metrics used for cycle count accuracy graphs and hit-or-miss tolerance reporting. In environments where it is deployed, it functions as a reporting view supporting UI graphs and performance inquiries that summarize count outcomes over a fiscal quarter.

Underlying Base Objects

The view is defined over three cycle counting tables in the INV schema:

  • MTL_CYCLE_COUNT_ENTRIES (MCCE) — stores individual cycle count entry lines, including system quantity, count quantity, adjustment amount, adjustment quantity, and count date.
  • MTL_CYCLE_COUNT_CLASSES (MCCC) — stores tolerance definitions at the cycle count class level, supplying positive and negative hit/miss tolerance values.
  • MTL_CYCLE_COUNT_HEADERS (MCCH) — stores header-level cycle count definitions and header-level tolerance values.

Although the documented base-object list is empty, the embedded view text clearly shows these three tables joined by ORGANIZATION_ID and CYCLE_COUNT_HEADER_ID. Tolerance values are resolved with NVL, preferring the class-level value (MCCC) and falling back to the header-level value (MCCH). Rows are restricted to entries whose COUNT_QUANTITY_FIRST is not null, and results are grouped by organization, cycle count header, and the truncated quarter start date.

Key Columns

  • ORGANIZATION_ID — identifies the inventory organization that owns the cycle count data.
  • CYCLE_COUNT_HEADER_ID — uniquely identifies the cycle count definition represented by the aggregated row.
  • HITS — count of entries falling within the applicable tolerance.
  • MISSES — count of entries exceeding tolerance, or entries with a zero system quantity.
  • TOTAL_COUNTS — total number of evaluated count entries (SUM of 1).
  • POS_ADJ_VALUE — sum of positive adjustment amounts.
  • NEG_ADJ_VALUE — sum of negative adjustment amounts.
  • ABS_ADJ_VALUE — sum of the absolute adjustment amount. This is the column associated with the search term "abs_adj_value" and represents the total magnitude of inventory adjustment regardless of direction.
  • TRANSACTED — count of entries with a non-zero adjustment quantity.
  • QTR_START_DATE — the truncated quarter start date derived from COUNT_DATE_FIRST.

Common Use Cases and Queries

The view supports cycle count accuracy and adjustment reporting, typically consumed by Oracle Forms-based graph blocks. A representative query for adjustment magnitude by organization and quarter is:

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

Before using the view, verify its existence in the target database, since ETRM reports it as not implemented and restricted to 10SC deployments.