Search Results process_seconds

Overview

APPS.MTL_INTERFACE_PROC_CONTROLS_V is a supplementary Oracle EBS view in the Inventory (INV) application, registered under FND Design Data INV.MTL_INTERFACE_PROC_CONTROLS_V. It belongs to the standard APPS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. The view controls the behavior of the concurrent managers and workers that process the open inventory interface — the mechanism by which records staged in the MTL_INTERFACE tables (such as transaction and material interface rows) are picked up, grouped, and processed asynchronously.

Its role is essentially operational: it exposes the processing parameters row(s) that govern the inventory interface manager and its workers. Rather than presenting transaction data, it presents control data — interval, priorities, worker row limits, processing timeouts, and the decomposition of those intervals and timeouts into hours, minutes, and seconds. It is the object behind the Oracle Inventory "Interface Managers" setup form, and it is therefore relevant to reporting on or troubleshooting the open interface processing cycle.

Oracle explicitly warns that this is a supplementary view intended to simplify forms coding, and that it should not be queried or altered as a data-maintenance path, since its definition may change across minor or major releases. It is an APPS-schema, FND-design-data-registered object, so it should be referenced in custom SQL as APPS.MTL_INTERFACE_PROC_CONTROLS_V.

Underlying Base Objects

The view is defined over two documented dependencies: the base table (exposed as the APPS synonym) MTL_INTERFACE_PROC_CONTROLS, and the MFG_LOOKUPS view. MTL_INTERFACE_PROC_CONTROLS is the single-row control table for each inventory interface process; the view reads that table and joins MFG_LOOKUPS to translate lookup-coded values into meaningful text. The documented query text returns all columns from the view via a simple SELECT list — PROCESS_CODE, PROCESS_STATUS, PROCESS_INTERVAL, priorities, worker sizing, timeouts, the PROCESS_NAME and PROCESS_APP_SHORT_NAME, PROCESS_TYPE, and the hour/minute/second breakdowns — implying lookup-based decode logic that produces the descriptive names. ETRM records that MTL_INTERFACE_PROC_CONTROLS_V is not referenced by any other database object, so it is a terminal, read-only presentation layer.

Key Columns

• PROCESS_CODE — numeric identifier for the interface process; the effective primary key for control purposes.
• PROCESS_STATUS — current status of the process, decoded from a lookup.
• PROCESS_INTERVAL — the scheduling interval between processing cycles; hours/minutes/seconds are decomposed into PROCESS_HOURS, PROCESS_MINUTES, and PROCESS_SECONDS.
• MANAGER_PRIORITY / WORKER_PRIORITY — priority assigned to the manager and worker concurrent programs.
• WORKER_ROWS — the number of rows each worker processes per cycle.
• PROCESSING_TIMEOUT / TIMEOUT_HOURS / TIMEOUT_MINUTES — the maximum allowable processing time before a run is considered timed out.
• PROCESS_NAME, PROCESS_APP_SHORT_NAME, PROCESS_TYPE — descriptive identifiers and the type of the interface process, resolved through MFG_LOOKUPS.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, and the concurrent request columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.
• ROW_ID — ROWID of the underlying row, exposed as column 1.

Common Use Cases and Queries

Typical uses include: confirming the configured interval and timeout for the inventory interface manager; verifying WHAT the current manager/worker priorities and WORKER_ROWS are before tuning throughput; and building diagnostic reports that time-stamp the last update to the control row through LAST_UPDATE_DATE and the concurrent request columns.

The ETRM-documented query retrieves the full control record:

SELECT ROW_ID, PROCESS_CODE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, PROCESS_STATUS, PROCESS_INTERVAL, MANAGER_PRIORITY, WORKER_PRIORITY, WORKER_ROWS, PROCESSING_TIMEOUT, PROCESS_NAME, PROCESS_APP_SHORT_NAME, PROCESS_TYPE, PROCESS_HOURS, PROCESS_MINUTES, PROCESS_SECONDS, TIMEOUT_HOURS, TIMEOUT_MINUTES FROM APPS.MTL_INTERFACE_PROC_CONTROLS_V;

A focused variant for the interface manager cycle would filter on PROCESS_CODE = 1 and return PROCESS_SECONDS, PROCESS_INTERVAL, MANAGER_PRIORITY, WORKER_PRIORITY, and WORKER_ROWS. Because the view is read-only by design, any adjustment must be made through the supported Oracle Inventory form, not through DML against the view.