Search Results mtl_category_sets_b

Overview

The MTL_CATEGORY_SETS_B table is the core repository for defining category sets within Oracle E-Business Suite Inventory (INV) module, versions 12.1.1 and 12.2.2. A category set is a logical grouping of item categories used for specific business purposes, such as reporting, costing, or planning. This table stores the fundamental, non-translatable attributes of each category set. It is a foundational master data table that enables the flexible classification and hierarchical structuring of items, which is critical for inventory management, product catalog organization, and integration with other EBS modules like Order Management, Cost Management, and Advanced Supply Chain Planning.

Key Information Stored

The table's primary key is CATEGORY_SET_ID, which uniquely identifies each category set. While the provided metadata does not list all columns, based on its central role, the table typically stores columns such as CATEGORY_SET_NAME, DESCRIPTION, STRUCTURE_ID (linking to the Flexfield structure for categories), VALIDATE_FLAG (to enforce category membership), and CONTROLS (determining how categories are assigned). A critical foreign key column documented is DEFAULT_CATEGORY_ID, which references MTL_CATEGORIES_B to specify a default category within the set. The table's design ensures referential integrity for a wide array of functional setups across the application.

Common Use Cases and Queries

This table is primarily accessed for setup validation, data integrity checks, and reporting on categorization structures. Common scenarios include identifying all category sets available for item assignment or verifying the default category for a specific set. A typical query retrieves category set details by joining with its translation table, MTL_CATEGORY_SETS_TL, for language-specific names.

• Sample Query: SELECT mcsb.CATEGORY_SET_ID, mcsb.CATEGORY_SET_NAME, mcsb.DEFAULT_CATEGORY_ID, mcst.DESCRIPTION FROM INV.MTL_CATEGORY_SETS_B mcsb, INV.MTL_CATEGORY_SETS_TL mcst WHERE mcsb.CATEGORY_SET_ID = mcst.CATEGORY_SET_ID AND mcst.LANGUAGE = USERENV('LANG');
• Reporting Use Case: Generating a list of all category sets used by the Cost Management module (CST) by joining with tables like CST_COST_TYPE_HISTORY.

Related Objects

MTL_CATEGORY_SETS_B has extensive relationships, underscoring its importance as a master data entity. Its primary key is referenced by numerous tables across different products. Key documented relationships include:

• Translation: MTL_CATEGORY_SETS_TL (join on CATEGORY_SET_ID) for multilingual descriptions.
• Category Definition: MTL_CATEGORY_SET_VALID_CATS (CATEGORY_SET_ID) defines which categories belong to a set.
• Inventory & Costing: MTL_DEFAULT_CATEGORY_SETS, CST_COST_TYPE_HISTORY, CST_COST_UPDATES (all on CATEGORY_SET_ID).
• Supply Chain Planning: CSP_PLANNING_PARAMETERS, CSP_EXCESS_RULES_B (CATEGORY_SET_ID).
• Customer Facing Applications: ICX_WEB_STORE_OPTIONS, IBE_CT_IMEDIA_SEARCH (CATEGORY_SET_ID).
• Other Modules: AS_AP_TRACKING_OBJECTIVES (PRODUCT_CAT_SET_ID), PA_PLAN_RES_DEFAULTS (ITEM_CATEGORY_SET_ID), ZX_FC_TYPES_B (OWNER_ID_COLUMN_1).

The foreign key to MTL_CATEGORIES_B on DEFAULT_CATEGORY_ID establishes a direct link to the category master table.