My Oracle Support Banner

Interface Managers Form (INVTMSMG) Shows Status PROCESS_STATUS "Active" But mtl_interface_proc_controls Table Shows "Inactive" (Doc ID 2058217.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
INVTMSMG.FMB

Goal

The Table mtl_interface_proc_controls shows the process status of the managers as "Inactive" but the Interface Managers Form (INVTMSMG) shows the status as "Active", the managers actually work.

Where does the form get its information from?

i.e the following SQL can be used to check Interface Mangers Status

Select process_name,
       process_app_short_name,
process_status,
       process_interval,worker_rows
       From mtl_interface_proc_controls;

OR

Select process_name, process_app_short_name,
        process_status, process_interval,worker_rows
        from mtl_interface_proc_controls_v;

Please refer to the following for further details :

Note 112146.1 , Troubleshooting Interface Managers

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.