Search Results wsm_lot_job_interface




Overview
Explore in AI Chat

Overview

The WSM_LOT_JOB_INTERFACE table is a critical interface table within the Oracle E-Business Suite (EBS) Shop Floor Management (WSM) module for versions 12.1.1 and 12.2.2. Its primary role is to serve as the staging area for importing lot-based jobs into the Oracle Shop Floor Management (OSFM) manufacturing execution system. As a standard Oracle interface table, it follows the pattern of allowing external data to be loaded into a temporary holding area before being validated and processed by a concurrent program—typically the "Import Jobs" process—which then creates the corresponding discrete job records in the core WIP_ENTITIES and related tables. This design ensures data integrity and provides a mechanism for error handling and correction before transactional records are created.

Key Information Stored

The table stores all necessary attributes to define a new lot-based manufacturing job. While the full column list is extensive, the documented foreign key relationships highlight the most critical fields. The primary key is the HEADER_ID, which uniquely identifies each interface record. Essential descriptive columns include JOB_NAME and WIP_ENTITY_ID for identifying the job, and ORGANIZATION_ID to specify the manufacturing organization. Key manufacturing definition columns are PRIMARY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR, and ALTERNATE_ROUTING_DESIGNATOR, which define the product and its production process. Inventory and accounting controls are specified via COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID, and CLASS_CODE. The table also contains control columns such as PROCESS_PHASE and PROCESS_STATUS to manage the interface record's lifecycle during the import process.

Common Use Cases and Queries

The primary use case is the bulk creation of manufacturing jobs from an external system, such as a Plant Floor Data Collection (PFDC) system or a custom planning application. A typical implementation involves populating the interface table via a custom program or SQL*Loader, then running the standard "Import Jobs" concurrent request. Common diagnostic queries include checking for records pending import or those that have errored. For example, to identify pending records for a specific organization: SELECT JOB_NAME, PRIMARY_ITEM_ID, PROCESS_STATUS FROM WSM_LOT_JOB_INTERFACE WHERE ORGANIZATION_ID = 123 AND PROCESS_PHASE = 1 AND PROCESS_STATUS IN (1, 3); A status of 1 typically indicates 'Pending', while 3 indicates 'Error'. After a successful import, the interface records are usually purged or archived by the concurrent process.

Related Objects

The documented foreign key relationships explicitly define this table's integration points within the EBS manufacturing schema. These relationships enforce referential integrity during the import process, ensuring that valid master data is referenced.

  • BOM_BILL_OF_MATERIALS: Joined via PRIMARY_ITEM_ID, ORGANIZATION_ID, and ALTERNATE_BOM_DESIGNATOR to validate the bill of materials for the assembly.
  • BOM_OPERATIONAL_ROUTINGS: Joined via PRIMARY_ITEM_ID, ORGANIZATION_ID, and ALTERNATE_ROUTING_DESIGNATOR to validate the production routing.
  • MTL_SECONDARY_INVENTORIES & MTL_ITEM_LOCATIONS: Joined via COMPLETION_SUBINVENTORY and COMPLETION_LOCATOR_ID (with ORGANIZATION_ID) to validate the completion destination.
  • WIP_ACCOUNTING_CLASSES: Joined via CLASS_CODE and ORGANIZATION_ID to validate the job's accounting class.
  • WIP_ENTITIES: Joined via either JOB_NAME or WIP_ENTITY_ID (with ORGANIZATION_ID) to prevent duplication or to update existing jobs.
  • WSM_PARAMETERS: Joined via ORGANIZATION_ID to validate the organization's setup within OSFM.

The primary key constraint, WSM_LOT_JOB_INTERFACE_PK, ensures the uniqueness of the HEADER_ID column within the interface table itself.

  • Table: WSM_LOT_JOB_INTERFACE 12.1.1

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_LOT_JOB_INTERFACE,  object_name:WSM_LOT_JOB_INTERFACE,  status:VALID,  product: WSM - Shop Floor Management ,  description: Interface table for the Import of Lot based Jobs in OSFM. ,  implementation_dba_data: WSM.WSM_LOT_JOB_INTERFACE , 

  • Table: WSM_LOT_JOB_INTERFACE 12.2.2

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_LOT_JOB_INTERFACE,  object_name:WSM_LOT_JOB_INTERFACE,  status:VALID,  product: WSM - Shop Floor Management ,  description: Interface table for the Import of Lot based Jobs in OSFM. ,  implementation_dba_data: WSM.WSM_LOT_JOB_INTERFACE , 

  • Table: WSM_PARAMETERS 12.1.1

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_PARAMETERS,  object_name:WSM_PARAMETERS,  status:VALID,  product: WSM - Shop Floor Management ,  description: To define an organization parameter for OSFM, the organization should satisfy the following conditions;1. Standard Costing organization.2. LotNumber Uniqueness in Inventory parameters should be NONE.3. LotNumber Default Type in WIP paramete ,  implementation_dba_data: WSM.WSM_PARAMETERS , 

  • Table: WSM_PARAMETERS 12.2.2

    owner:WSM,  object_type:TABLE,  fnd_design_data:WSM.WSM_PARAMETERS,  object_name:WSM_PARAMETERS,  status:VALID,  product: WSM - Shop Floor Management ,  description: To define an organization parameter for OSFM, the organization should satisfy the following conditions;1. Standard Costing organization.2. LotNumber Uniqueness in Inventory parameters should be NONE.3. LotNumber Default Type in WIP paramete ,  implementation_dba_data: WSM.WSM_PARAMETERS ,