Search Results process_output

Overview

MTH_PROCESS_OUTPUT_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Tax and Manufacturing/Enterprise Resource) metadata as an "OTHER" API. It belongs to the Oracle Manufacturing Execution System (MES) / Shop Floor Management module, specifically the equipment and production output tracking subsystem designated by the "MTH" prefix. The package provides the core processing logic for capturing, staging, validating, and summarizing equipment production output data, which is essential for measuring manufacturing throughput and equipment utilization on the shop floor.

The package header is authorized with AUTHID CURRENT_USER and carries a source header reference indicating it was created in 2012 and last modified under patchset 120.0.12020000.1. It is compiled under the APPS schema in both Oracle EBS 12.1.1 and 12.2.2, with identical operational behavior across both editions since the underlying technology stack for this module has remained stable.

Key Procedures and Functions

The package exposes three documented procedures:

• VALIDATE — A validation routine that accepts a mode and source parameter and returns an error buffer and return code. It validates input data before processing, ensuring that staging records meet business rules prior to permanent commitment.
• PROCESS_OUTPUT — The main processing procedure for output data. It accepts a mode parameter supporting INIT (initial load), INCR (incremental), and RECAL (recalculation) operations, and a source parameter supporting TAG and CSV data acquisition methods. For recalculation, optional date range, equipment, and plant scope parameters are provided. It returns a return code only.
• PROCESS_OUTPUT_SUMMARY — Generates summarized equipment output records, aggregating detailed output data for reporting and analysis.

No parameters should be assumed beyond those documented in the source header excerpt.

Tables Accessed

The package reads and writes a broad set of MTH tables via APPS synonyms, reflecting its role as a central integration point for output processing:

• Staging and error tables — MTH_EQUIP_OUTPUT_STG holds incoming raw data, MTH_EQUIP_OUTPUT is the destination transactional table, and MTH_EQUIP_OUTPUT_ERR captures rejected records.
• Equipment and plant master data — MTH_EQUIPMENTS_D, MTH_EQUIPMENT_DENORM_D, MTH_PLANTS_D, MTH_ENTITIES, and MTH_ITEMS_D provide equipment, plant, and item context.
• Shift and time dimensions — MTH_EQUIPMENT_SHIFTS_D and MTH_HOUR_D support shift-based and hourly output attribution.
• Rates and standards — MTH_EQUIP_STANDARD_RATES_F supplies standard rates for throughput comparison.
• Production scheduling — MTH_PRODUCTION_SCHEDULES_F and MTH_PRODUCTION_SEGMENTS_F link output to scheduled production segments.
• Summary tables — MTH_EQUIP_OUTPUT_SUMMARY and MTH_EQUIP_STATUS_SUMMARY persist aggregated output and status metrics.

Usage Notes

MTH_PROCESS_OUTPUT_PKG is typically invoked from concurrent programs, Oracle Forms within the Shop Floor Management responsibility, or custom integration code that loads equipment output from external data acquisition systems (tags or CSV feeds). The INIT mode is used for the first-time load of production history, INCR processes ongoing incremental output events, and RECAL supports deliberate recalculation over a specified date range, equipment, or plant. Because only one other package references it directly, consumers should treat it as a mid-tier processing engine invoked programmatically. Error buffer and return code parameters must be checked after every call to detect and handle rejected records logged to MTH_EQUIP_OUTPUT_ERR.