Search Results wsm_sector_extensions




Overview
Explore in AI Chat

Overview

The WSM_SECTOR_EXTENSIONS table is a core data object within the Oracle E-Business Suite (EBS) Shop Floor Management (WSM) module, specifically supporting the Oracle Shop Floor Management (OSFM) functionality. It serves as the master definition table for Sector Extensions. In the context of OSFM, a Sector Extension represents a discrete segment of a manufacturing process for which a lot-based job is defined. This table is essential for configuring and managing the logical divisions of the production floor, enabling detailed tracking, resource assignment, and cost accounting for specific phases of lot-based manufacturing operations. Its validity in both EBS 12.1.1 and 12.2.2 indicates its foundational role in the OSFM architecture.

Key Information Stored

The table stores the defining attributes for each Sector Extension within a manufacturing organization. While the full column list is not detailed in the provided metadata, the primary and unique key structures reveal the most critical data points. Each record is uniquely identified by a system-generated SECTOR_EXTENSION_ID (Primary Key). Furthermore, the combination of ORGANIZATION_ID and a user-defined SECTOR_EXTENSION_CODE must also be unique (Unique Key), ensuring no duplicate sector codes exist within a single inventory organization. A key functional column is DEFAULT_ACCT_CLASS_CODE, which links the sector to a specific WIP Accounting Class, dictating the default cost accounting treatment for jobs executed within this sector.

Common Use Cases and Queries

This table is primarily accessed during the setup and configuration of OSFM and during the execution and inquiry of lot-based jobs. Common operational scenarios include validating sector definitions before creating new jobs, reporting on all configured sectors within an organization, and troubleshooting accounting issues by verifying the default accounting class assignment. A typical query to list all Sector Extensions for an organization, along with their default accounting class, would follow this pattern:

  • SELECT se.sector_extension_code, se.description, wac.class_code, wac.class_type FROM wsm_sector_extensions se, wip_accounting_classes wac WHERE se.organization_id = :org_id AND se.default_acct_class_code = wac.class_code AND se.organization_id = wac.organization_id ORDER BY se.sector_extension_code;

Data in this table is typically maintained via the OSFM application screens, not via direct SQL manipulation.

Related Objects

The WSM_SECTOR_EXTENSIONS table maintains integral relationships with other key EBS tables, as documented by its foreign key constraints:

  • Referenced By (Parent Tables):
    • WIP_ACCOUNTING_CLASSES via DEFAULT_ACCT_CLASS_CODE and ORGANIZATION_ID: Ensures the assigned default accounting class is valid.
    • WSM_PARAMETERS via ORGANIZATION_ID: Ensures the sector is defined for a valid organization configured in WSM.
  • Referenced In (Child Table):
    • WSM_SUBINVENTORY_EXTENSIONS via SECTOR_EXTENSION_ID: This is a critical relationship where subinventories are assigned to specific Sector Extensions, controlling material movement and inventory transactions within the defined manufacturing sector.