INV Default Category Sets – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master data report that lists Inventory functional areas and their default category sets
Report Parameters
Oracle EBS Tables Used
mtl_default_category_sets, mtl_category_sets_v
Report Categories
Related Reports
CAC Inventory and Intransit Value (Period-End), CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, AR Transaction Upload, CAC New Standard 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 Default Category Sets 03-Apr-2018 110157.xlsx |
| Blitz Report™ XML Import | INV_Default_Category_Sets.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-default-category-sets/ |
INV Default Category Sets - Case Study & Technical Analysis
Executive Summary
The INV Default Category Sets report is a configuration audit document. In Oracle EBS, different functional areas (Inventory, Purchasing, Costing, Order Management, etc.) can use different “Category Sets” to classify items. This report lists which Category Set is the “Default” for each functional area. It is essential for understanding how items are grouped for reporting and processing across the suite.
Business Use Cases
- Implementation Audit: Verifies that the system is configured correctly (e.g., “Is the ‘Purchasing’ functional area using the ‘Purchasing Categories’ set?”).
- Reporting Context: Helps analysts understand why an item might have a category of “Hardware” in an Inventory report but “IT Equipment” in a Purchasing report (different category sets).
- Master Data Governance: Ensures consistency in how items are classified across the enterprise.
Technical Analysis
Core Tables
MTL_DEFAULT_CATEGORY_SETS: The mapping table between functional areas and category sets.MTL_CATEGORY_SETS_V: Details of the category sets.FND_LOOKUP_VALUES: Used to decode theFUNCTIONAL_AREA_ID(e.g., 1=Inventory, 2=Purchasing).
Key Joins & Logic
- Functional Area Mapping: Joins the internal ID of the functional area to its readable name.
- Structure Definition: Shows the Flexfield Structure associated with the category set.
Key Parameters
- (None): Typically runs for the entire installation or filtered by organization if applicable (though default category sets are usually site/installation level).
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