Search Results wsm_parameters




Overview
Explore in AI Chat

Overview

The WSM_PARAMETERS table is a core configuration table within the Oracle E-Business Suite Shop Floor Management (WSM) module. It serves as the primary repository for organization-level parameters that govern the behavior of Oracle Shop Floor Management (OSFM). Its fundamental role is to define and control the operational rules for manufacturing organizations enabled for OSFM. As indicated in the documentation, an organization must meet specific prerequisites to be defined in this table, including being a standard costing organization and having particular lot number control settings in Inventory and Work in Process (WIP) parameters. The table acts as a central control point, with its primary key being referenced by numerous transactional and interface tables across the WSM module.

Key Information Stored

The table's structure is centered on the organization identifier. While the full column list is not detailed in the provided excerpt, the primary key and foreign key relationships explicitly identify the ORGANIZATION_ID as the critical column. This column stores the unique identifier (typically from INV_ORG_PARAMETERS) for each manufacturing organization configured for OSFM. Based on the description, other columns in the table likely store parameters that enforce the stated conditions, such as flags or settings related to lot number uniqueness, lot number defaulting, and costing method validation. The table's single-record-per-organization design establishes it as the definitive source for determining if an organization is OSFM-enabled and under what specific rules it operates.

Common Use Cases and Queries

The primary use case is validating whether an organization is set up for Oracle Shop Floor Management operations. This validation is crucial before executing lot-based transactions, job interfaces, or split/merge operations. Common queries involve joining with inventory organization tables to list all OSFM-enabled organizations or to troubleshoot setup issues. For instance, to identify all configured organizations, a basic query would be:

SELECT wp.organization_id, mp.organization_code
FROM wsm_parameters wp,
mtl_parameters mp
WHERE wp.organization_id = mp.organization_id;

Another critical use case is in data validation scripts for interface tables (e.g., WSM_LOT_JOB_INTERFACE). Before processing records, logic often checks for the existence of a corresponding record in WSM_PARAMETERS to ensure the transaction is for a valid OSFM organization. Reporting on OSFM configuration and its alignment with underlying INV and WIP parameters also relies heavily on this table.

Related Objects

The WSM_PARAMETERS table has a central relationship with the Inventory parameters table and is a parent to numerous WSM transactional entities. The documented relationships are as follows:

This extensive set of foreign key constraints underscores the table's role as a fundamental control table for the entire OSFM lot and transaction management architecture.