Search Results gmo_batch_progression_pk

Overview

The GMO_BATCH_PROGRESSION table is a core data object within the Manufacturing Execution System (MES) for Process Manufacturing (GMO) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central repository for tracking the progression of a manufacturing batch through its defined operational steps. This table is fundamental to the real-time execution and monitoring of batch processes, enabling the system to record the current state, historical transitions, and associated transactional data as a batch moves from one stage to the next within a production line. Its role is critical for providing shop-floor visibility, enforcing process discipline, and maintaining an auditable trail of batch execution.

Key Information Stored

The primary data stored in this table revolves around the unique progression instance and its attributes. The documented primary key is the PROGRESSION_ID column, which uniquely identifies each batch progression record. While the full column list is not detailed in the provided metadata, based on its purpose, the table typically stores information such as the batch identifier (linking to the production batch), the current operation or step sequence, status codes (e.g., 'IN_PROGRESS', 'COMPLETE', 'ON_HOLD'), timestamps for state transitions, and references to the associated resources, equipment, and personnel. It acts as a log and a state machine for the batch's journey through the manufacturing process.

Common Use Cases and Queries

The primary use case is real-time batch tracking and production reporting. Shop-floor operators use interfaces built upon this table to view the status of active batches and record step completions. Common queries include identifying all batches currently in progress at a specific operation, calculating the elapsed time for a batch's current step, or generating a progression history report for a given batch. A typical SQL pattern involves joining to batch header and operation definition tables.

• Find Active Progressions: SELECT * FROM GMO.GMO_BATCH_PROGRESSION WHERE STATUS = 'IN_PROGRESS';
• Batch Progression History: SELECT progression_id, status, last_update_date FROM GMO.GMO_BATCH_PROGRESSION WHERE batch_id = :p_batch_id ORDER BY creation_date;

Related Objects

The GMO_BATCH_PROGRESSION table is central to the GMO module's data model. It is directly referenced by the primary key constraint GMO_BATCH_PROGRESSION_PK on the PROGRESSION_ID column. It will have foreign key relationships with core manufacturing tables, such as the batch header table (e.g., GMO_BATCH_HEADER) via a BATCH_ID column and likely with operational definition tables (e.g., GMO_OPERATION_CLASS). It is also the primary source for related views and transactional interfaces (APIs) that manage batch movement and status updates within the MES workflow. Reporting views often aggregate data from this table with batch and item master information.