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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms