| layout | default |
|---|---|
| title | INV ABC assignments | Oracle EBS SQL Report |
| description | Imported from BI Publisher Description: ABC assignments report Application: Inventory Source: ABC assignments report (XML) Short Name: INVARAASXML DB… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, BI Publisher, Enginatics, R12 only, INV, ABC, assignments, org_organization_definitions, hr_operating_units, gl_sets_of_books |
| permalink | /INV%20ABC%20assignments/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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
Operating Unit, Organization Code, ABC Group, Sort Option
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
BI Publisher, Enginatics, R12 only
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
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.
| 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/ |
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.
- 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.
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.
- 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.
- ABC Group: The specific assignment group to report on.
- Sort Option: Sort by Item, Class, or Value.
- 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