IP Master | Invoices in Flow - Recipient Search Field doesn't work

Problem encountered :

We meet following issue: In IP Master, in the "Invoices In Flow" tab, the field "Recipient" has issue when we display the popup selection (please see screenshot).



Resolution process :

We had a discrepancy between the tables ip_group_user and eflow_users.

After execute these following SQL queries, the issue has been solved:

delete from eflow_apps where user_network_name not in (select user_network_name from eflow_users)

delete from flow_current where recipient_name not in (select user_name from eflow_users)

delete FROM BW_USER_AUTHENTICATION where UAU_USER_NETWORK_NAME not in (select user_network_name from eflow_users)

delete from ip_group_user where user_network_name not in (select user_network_name from eflow_users)

update eflow_users set active = 0 where user_network_name not in (select user_network_name from eflow_apps)​

Did you find this article useful?