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 FEBRUARY 13, 2019

Applies to:

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


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,
       From mtl_interface_proc_controls;


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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.