Results for “msd_category_set_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.MSD_SR_CAT_ALL_V is a master data synchronization view in Oracle EBS used by the MSD (Master Data Synchronization) schema, part of the Oracle E-Business Suite data quality and master data management stack. It exposes item category assignments from the MTL_ITEM_CATEGORIES table together with their category descriptions, concatenated category segments, and derived product metadata, in a form appropriate for the Spoke/Remote (SR) synchronization model. Its role is to provide a set-based, deterministic picture of the categories valid in a given organization so downstream consumers — typically MSD collection programs and interfaces — can pull or push category master data.

The critical behavior of this view is its branching on the MSD_ITEM_ORG setup parameter. When MSD_ITEM_ORG equals MSD_MASTER_ORG (the master organization scenario), categories are taken solely from the organization identified by MSD_MASTER_ORG. When that parameter is not set, the view instead unions categories across all organizations present in MSD_APP_INSTANCE_ORGS. In both cases the category set is filtered by MSD_CATEGORY_SET_NAME. This is why the user's search for "msd_master_org" leads here: MSD_MASTER_ORG is the parameter that switches the view's cardinality between single-organization and multi-organization modes.

Underlying Base Objects

• MSD_SETUP_PARAMETERS — provides MSD_ITEM_ORG, MSD_MASTER_ORG and MSD_CATEGORY_SET_NAME; drives the branching and filtering logic.
• MSD_APP_INSTANCE_ORGS — the set of organizations in scope when MSD_ITEM_ORG is not MSD_MASTER_ORG.
• MTL_ITEM_CATEGORIES — the transactional source of category_id/organization_id assignments.
• MTL_CATEGORIES_B_KFV — key flexfield view supplying category_id and concatenated_segments.
• MTL_CATEGORIES_TL — translatable table supplying description in the session language (userenv('LANG')).
• MSD_SR_UTIL — package supplying get_all_prd_pk, get_all_prd_desc and get_null_pk/get_null_desc, used for derived product keys and sentinel "all products"/NULL rows.
• DUAL — supplies the synthetic "all products" row via UNION ALL.

Key Columns

• category_id — identifier of the item category.
• concatenated_segments — the human-readable category flexfield concatenation from MTL_CATEGORIES_B_KFV.
• description — the category description from MTL_CATEGORIES_TL in the session language.
• get_all_prd_pk / get_all_prd_desc — derived columns (repeated three times in the select list) supplying the "all products" key and description used by MSD synchronization logic.
• Trailing NULL columns — placeholders preserving a fixed column list across the UNION branches.

Common Use Cases and Queries

The view is normally consumed by MSD collection code rather than by end users. Typical diagnostics include verifying which category set and organization scope are active, and confirming that MSD_MASTER_ORG is set as expected.

• Inspect the controlling parameters:

  SELECT parameter_name, parameter_value
    FROM msd_setup_parameters
   WHERE parameter_name IN ('MSD_ITEM_ORG','MSD_MASTER_ORG','MSD_CATEGORY_SET_NAME');

• List the categories exposed by the view:

  SELECT category_id, concatenated_segments, description
    FROM apps.msd_sr_cat_all_v
   WHERE category_id IS NOT NULL
   ORDER BY concatenated_segments;

• Confirm branch behavior by comparing the view output against MTL_ITEM_CATEGORIES for the master organization identified in MSD_MASTER_ORG.

Because the view references setup parameters and the session LANG at runtime, results change with configuration and language settings; any query should account for both.