INV ABC assignments – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Imported from BI Publisher Description: ABC assignments report Application: Inventory Source: ABC assignments report (XML) Short Name: INVARAAS_XML DB package: INV_INVARAAS_XMLP_PKG
Report Parameters
Operating Unit, Organization Code, ABC Group, Sort Option
Oracle EBS Tables Used
org_organization_definitions, hr_operating_units, gl_sets_of_books, mtl_abc_assignment_groups, fnd_currencies, mtl_item_flexfields, mtl_abc_assignments, mtl_abc_classes, mtl_abc_compiles, org_group
Report Categories
BI Publisher, Enginatics, R12 only
Related Reports
INV Cycle count open requests listing, INV Cycle counts pending approval, INV Onhand Quantities, INV Cycle count entries and adjustments, INV Cycle count listing, INV Cycle count unscheduled items, INV Cycle count hit/miss analysis, CAC Calculate ICP PII Item Costs
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 ABC assignments 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | INV_ABC_assignments.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-abc-assignments/ |
INV ABC assignments - Case Study & Technical Analysis
Executive Summary
The INV ABC assignments report documents the classification of inventory items into ABC classes (A, B, C) based on their value, usage, or frequency. ABC analysis is a standard supply chain technique where ‘A’ items are high-value/high-priority, and ‘C’ items are low-value. This report shows which class each item has been assigned to, which drives cycle counting frequencies and inventory control policies.
Business Use Cases
- Cycle Count Planning: Verifies that high-value (‘A’) items are assigned to frequent count schedules (e.g., monthly) while low-value (‘C’) items are counted less often (e.g., annually).
- Inventory Policy Review: Helps managers analyze if the current ABC thresholds are appropriate (e.g., “Are too many items falling into Class A?”).
- Stocking Strategy: ‘A’ items might be stocked in more secure or accessible locations; this report helps validate those location assignments.
- Obsolete Inventory Identification: Items that have moved from ‘A’ to ‘C’ (or ‘D’) over time may be candidates for obsolescence review.
Technical Analysis
Core Tables
MTL_ABC_ASSIGNMENTS: The table linking an item to an ABC class within an assignment group.MTL_ABC_CLASSES: Defines the classes (A, B, C, etc.).MTL_ABC_ASSIGNMENT_GROUPS: Defines the group (e.g., “Cycle Count Group”, “Planning Group”).MTL_ABC_COMPILES: Stores the compilation header that calculated the ABC values.
Key Joins & Logic
- Assignment Logic: The query joins
MTL_ABC_ASSIGNMENTStoMTL_SYSTEM_ITEMS(viaINVENTORY_ITEM_ID) andMTL_ABC_CLASSES(viaABC_CLASS_ID). - Group Context: Assignments are always within the context of an
ASSIGNMENT_GROUP_ID. An item can be Class ‘A’ for Cycle Counting but Class ‘B’ for Planning. - Scope: Filters by Organization, as ABC analysis is organization-specific.
Key Parameters
- ABC Group: The specific assignment group to report on.
- Sort Option: Sort by Item, Class, or 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