INV Cycle counts pending approval – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Imported Oracle standard Cycle counts pending approval report Source: Cycle counts pending approval report (XML) Short Name: INVARCPA_XML DB package: INV_INVARCPA_XMLP_PKG
Report Parameters
Organization Code, Cycle Count Name, Category Set 1, Category Set 2, Category Set 3, Sort By
Oracle EBS Tables Used
mtl_cc_serial_numbers, mtl_item_locations_kfv, mtl_system_items_vl, mtl_cycle_count_headers, mtl_cycle_count_items, mtl_cycle_count_entries, mtl_abc_classes, org_organization_definitions, gl_ledgers, fnd_currencies, cst_cost_groups, wms_license_plate_numbers, org_access_view
Report Categories
Related Reports
INV Cycle count entries and adjustments, INV Cycle count listing, INV Cycle count open requests listing, INV Cycle count hit/miss analysis, INV Cycle count schedule requests, INV Cycle count unscheduled items, INV Transaction Register, INV Items, INV Item Upload
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 | None |
| Blitz Report™ XML Import | INV_Cycle_counts_pending_approval.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-cycle-counts-pending-approval/ |
INV Cycle counts pending approval - Case Study & Technical Analysis
Executive Summary
The INV Cycle counts pending approval report is a workflow management tool for inventory supervisors. It lists all cycle count entries where the variance (difference between system and physical count) exceeds the pre-defined approval tolerances. These entries are “stuck” in a pending state until a manager reviews and approves (or rejects/recounts) them.
Business Use Cases
- Approval Workflow: The primary “inbox” for managers to review large adjustments before they hit the General Ledger.
- Fraud Detection: Large variances needing approval are often the first indicator of theft or significant process failures.
- Period Close: All pending approvals must be resolved before the inventory period can be closed effectively (or at least before the adjustments are reflected in finance).
Technical Analysis
Core Tables
MTL_CYCLE_COUNT_ENTRIES: The count entries.MTL_CYCLE_COUNT_HEADERS: Defines the approval tolerances.MTL_ABC_CLASSES: Used if tolerances are defined by ABC class.
Key Joins & Logic
- Status Filter: Filters for
ENTRY_STATUS_CODE= 2 (Pending Approval). - Tolerance Check: The system automatically places an entry in this status if:
ABS(Variance Qty) > Quantity ToleranceORABS(Variance Value) > Value Tolerance.
- Sorting: Often sorted by value to prioritize the biggest hits.
Key Parameters
- Cycle Count Name: The specific count definition.
- Sort By: Options usually include Item, Location, or Variance Value.
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