Search Results processing_timeout

Overview

MTL_INTERFACE_PROC_CONTROLS_V is a read-only view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Inventory (INV) product family and is documented in ETRM with the description "10SC ONLY," indicating that its functionality is scoped to the 10SC (discrete manufacturing / shop floor control) context rather than general inventory processing. The view exposes configuration and scheduling parameters for the interface processing programs that manage the movement of records into Oracle Inventory through the open interface tables.

Functionally, the view presents the control rows defined for interface process jobs—such as the inventory transaction processor, the receiving interface, and related concurrent programs—along with the interval, priority, and timeout settings that govern how those programs execute. Its principal reporting value lies in its derived columns: rather than exposing PROCESS_INTERVAL and PROCESSING_TIMEOUT solely as raw seconds, it decomposes them into hours, minutes, and seconds, and it resolves the PROCESS_CODE into a human-readable PROCESS_TYPE by joining to the MFG_LOOKUPS lookup view. This makes the view convenient for administrative reporting, monitoring, and diagnosing scheduling configurations without additional arithmetic in the query.

Underlying Base Objects

The view is defined over two documented base objects:

• MTL_INTERFACE_PROC_CONTROLS (SYNONYM) — the primary source of all scheduling and control data. In APPS it is accessed through a synonym referencing the underlying table that stores one row per interface process code.
• MFG_LOOKUPS (VIEW) — a lookup view filtered on LOOKUP_TYPE = 'PROCESS_TYPE'. The join resolves the stored PROCESS_CODE to its MEANING, published by the view as PROCESS_TYPE.

The join condition is A.LOOKUP_TYPE = 'PROCESS_TYPE' AND A.LOOKUP_CODE = MIPC.PROCESS_CODE. Because the join is an inner join, only process codes that have a matching, active PROCESS_TYPE lookup are returned; a control row whose code lacks a lookup entry will not appear. The view selects the base row's ROWID as ROW_ID, but as a view it is not directly updatable, so DML must be applied to the underlying base table. No materialization is present; the view is evaluated at query time.

Key Columns

• PROCESS_CODE — the interface process identifier; the join key to MFG_LOOKUPS.
• PROCESS_TYPE — the decoded meaning of PROCESS_CODE (derived from MFG_LOOKUPS.MEANING).
• PROCESS_NAME / PROCESS_APP_SHORT_NAME — the concurrent program name and its application short name.
• PROCESS_STATUS — the enabled/disabled state of the process control row.
• PROCESS_INTERVAL — the run interval, in seconds; also decomposed into PROCESS_HOURS, PROCESS_MINUTES, and PROCESS_SECONDS.
• MANAGER_PRIORITY / WORKER_PRIORITY — assignment priorities for the manager and worker programs.
• WORKER_ROWS — the row batch size processed per worker.
• PROCESSING_TIMEOUT — the timeout in seconds, decomposable via TIMEOUT_HOURS and TIMEOUT_MINUTES.
• ROW_ID — the ROWID of the underlying base row.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

The view is typically queried to review how interface processors are scheduled and prioritized, to confirm that a given process is enabled, or to audit timeout and interval settings before tuning throughput.

• List all configured interface processes with decoded type and readable interval:

SELECT process_code, process_type, process_name, process_status,
  process_hours, process_minutes, process_seconds,
  timeout_hours, timeout_minutes
FROM apps.mtl_interface_proc_controls_v
ORDER BY process_code;

• Identify processes currently enabled for execution:

SELECT process_code, process_type, process_name, manager_priority
FROM apps.mtl_interface_proc_controls_v
WHERE process_status = 'ENABLED';

• Report batch sizing and priority settings for planning:

SELECT process_type, worker_rows, manager_priority, worker_priority
FROM apps.mtl_interface_proc_controls_v
WHERE worker_rows IS NOT NULL;

Because the object is a view, updates to interval, priority, timeout, or status must be performed against MTL_INTERFACE_PROC_CONTROLS directly, not through the view.