Search Results export_flag




Overview
Explore in AI Chat

Overview

MTL_CYCLE_COUNT_ENTRIES is a core Inventory (INV) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines and stores individual cycle count entries. Each row represents a discrete counting event performed against a specific item, subinventory, and locator combination within an organization. The table acts as the operational workhorse behind the Cycle Counting process, capturing counted quantities, system-on-hand quantities, adjustment details, and approval information that ultimately drive inventory adjustments and material transactions.

From a Data Vault modeling perspective, the heuristic classification for this table is satellite-leaning. It primarily records descriptive and descriptive-history attributes tied to a parent header key (CYCLE_COUNT_HEADER_ID) rather than acting as an aggregation-independent hub or a pure associative link. The 92-column structure and the presence of FIRST, CURRENT, and PRIOR count column families reinforce this satellite interpretation, capturing the evolving state of a counting transaction across its lifecycle.

Key Information Stored

The table is anchored by its surrogate primary key, CYCLE_COUNT_ENTRY_ID, defined through the unique index MTL_CYCLE_COUNT_ENTRIES_U1 and the constraint MTL_CYCLE_COUNT_ENTRIES_PK. This surrogate key is also the business-key candidate referenced by downstream tables. The most significant business columns include:

Standard audit columns such as LAST_UPDATE_DATE, CREATED_BY, and the ATTRIBUTE1–ATTRIBUTE15 descriptive flexfield columns are also present.

Common Use Cases and Queries

Typical reporting scenarios include reconciliation of counted versus system quantities, analysis of adjustment variances by item or subinventory, and approval tracking. A representative query joining header and item context follows:

SELECT cce.cycle_count_entry_id, cce.inventory_item_id,
       cce.subinventory, cce.count_quantity_current,
       cce.system_quantity_current, cce.adjustment_quantity
FROM   mtl_cycle_count_entries cce
WHERE  cce.organization_id = :org_id
AND    cce.entry_status_code = 'APPROVED';

Other practical uses include feeding counts into MTL_MATERIAL_TRANSACTIONS, verifying that adjustments posted to GL via the INVENTORY_ADJUSTMENT_ACCOUNT, and exporting count results through the MTL_CC_ENTRIES_INTERFACE for mass upload processing.

Related Objects

The table participates in a dense foreign key network. Significant related objects include:

Warehouse Management extensions reference WMS_LICENSE_PLATE_NUMBERS through PARENT_LPN_ID and OUTERMOST_LPN_ID, supporting LPN-aware counting.