INV Cycle count entries and adjustments – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Imported Oracle standard Cycle count entries and adjustments report Source: Cycle count entries and adjustments report (XML) Short Name: INVARCTA_XML DB package: INV_INVARCTA_XMLP_PKG
Report Parameters
Organization Code, Cycle Count Name, Subinventory, Count Date From, Count Date To, Approved Counts Only
Oracle EBS Tables Used
mtl_item_locations_kfv, mtl_cycle_count_items, mtl_abc_classes, mtl_cc_serial_numbers, org_organization_definitions, gl_ledgers, fnd_currencies, mtl_uom_conversions_view, mtl_system_items_vl, mtl_cycle_count_entries, cst_cost_groups, mtl_cycle_count_headers, wms_license_plate_numbers, org_access_view
Report Categories
Related Reports
INV Cycle count open requests listing, INV Cycle count hit/miss analysis, INV Cycle counts pending approval, INV Cycle count listing, INV Item Upload, INV Items, INV Cycle count unscheduled items, INV Onhand Quantities
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | INV Cycle count entries and adjustments - Summarized view 27-Oct-2021 210011.xlsm |
| Blitz Report™ XML Import | INV_Cycle_count_entries_and_adjustments.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-cycle-count-entries-and-adjustments/ |
INV Cycle count entries and adjustments - Case Study & Technical Analysis
Executive Summary
The INV Cycle count entries and adjustments report is a critical audit and control document that details the results of the cycle counting process. It lists the items counted, the system quantity, the actual counted quantity, and most importantly, the variance (adjustment) required to reconcile the two. This report is the primary source for analyzing inventory shrinkage or gain and is often required for financial sign-off on inventory adjustments.
Business Use Cases
- Variance Approval: Managers review this report to approve large adjustments before they are posted to the General Ledger.
- Shrinkage Analysis: Identifies items with consistent negative variances (missing stock), which may indicate theft or process errors.
- Accuracy Reporting: Provides the raw data to calculate inventory record accuracy (IRA).
- Audit Trail: Serves as the permanent record of what was counted, who counted it (if tracked), and what the result was.
Technical Analysis
Core Tables
MTL_CYCLE_COUNT_ENTRIES: The core transaction table storing the count results (System Qty, Count Qty, Adjustment Qty).MTL_CYCLE_COUNT_HEADERS: Defines the cycle count name and parameters.MTL_SYSTEM_ITEMS_VL: Item master details.MTL_ITEM_LOCATIONS_KFV: Locator details.MTL_ABC_CLASSES: ABC classification for the items.
Key Joins & Logic
- Variance Calculation: The report calculates
ADJUSTMENT_QUANTITY=COUNT_QUANTITY-SYSTEM_QUANTITY. - Value Calculation:
ADJUSTMENT_VALUE=ADJUSTMENT_QUANTITY*ITEM_COST. - Status Filtering: Can filter by entry status (e.g., ‘Pending Approval’, ‘Completed’).
- Approvals: If the adjustment exceeds the approval tolerance defined in the Cycle Count Header, the entry is marked for approval.
Key Parameters
- Cycle Count Name: The specific count definition.
- Subinventory: Filter by specific storage area.
- Start/End Date: The period of the count.
- Approved Counts Only: If ‘Yes’, only shows adjustments that have been finalized.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics