Need To Remove Users From 'Notifying The Following People' LOV Submitting Concurrent Request (Doc ID 1569605.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Release 12.1.3

Submitting any concurrent request -> Notify others shows LOV

select *
from wf_local_roles
where display_name like '%Joan Moore%';

Originating System Name is Trading Community Architecture Parties

HZ_PARTY:2649142 Joan Moore Joan Moore-G D Todd-196551 QUERY
HZ_PARTY:2649146 Joan Moore Joan Moore-Mr D P Todd & Mrs H J Todd-196556 QUERY
HZ_PARTY:2649149 Joan Moore Joan Moore-Mr A S & Mrs C M Crossland-196560 QUERY
HZ_PARTY:2649147 Joan Moore Joan Moore QUERY
HZ_PARTY:2649144 Joan Moore Joan Moore QUERY
HZ_PARTY:2649140 Joan Moore Joan Moore QUERY

ORIG_SYSTEM ORIG_SYSTEM_ID START_DATE STATUS
HZ_PARTY 2649142 06/24/2009 14:49:38 ACTIVE
HZ_PARTY 2649146 06/24/2009 14:53:37 ACTIVE
HZ_PARTY 2649149 06/24/2009 14:57:08 ACTIVE
HZ_PARTY 2649147 ACTIVE
HZ_PARTY 2649144 ACTIVE
HZ_PARTY 2649140 ACTIVE

1. select * from HZ_PARTY_WF_ROLES_V where display_name = 'Joan Moore';

HZ_PARTY:2649142 Joan Moore Joan Moore-G D Todd-196551 QUERY
HZ_PARTY:2649146 Joan Moore Joan Moore-Mr D P Todd & Mrs H J Todd-196556 QUERY
HZ_PARTY:2649149 Joan Moore Joan Moore-Mr A S & Mrs C M Crossland-196560 QUERY
HZ_PARTY:2649140 Joan Moore Joan Moore QUERY
HZ_PARTY:2649144 Joan Moore Joan Moore QUERY
HZ_PARTY:1211 Joan Moore Joan Moore MAILHTML
HZ_PARTY:2649147 Joan Moore Joan Moore QUERY

ORIG_SYSTEM ORIG_SYSTEM_ID START_DATE STATUS EXPIRATION_DATE
HZ_PARTY 2649142 24/06/2009 14:49:38 ACTIVE 31/12/4712 00:00:01
HZ_PARTY 2649146 24/06/2009 14:53:37 ACTIVE 31/12/4712 00:00:01
HZ_PARTY 2649149 24/06/2009 14:57:08 ACTIVE 31/12/4712 00:00:01
HZ_PARTY 2649140 ACTIVE
HZ_PARTY 2649144 ACTIVE
HZ_PARTY 1211 ACTIVE
HZ_PARTY 2649147 ACTIVE

Originating System Name is Trading Community Architecture Parties

HZ_PARTY:2649142 Joan Moore Joan Moore-G D Todd-196551 - This person is a contact of GD Todd
HZ_PARTY:2649146 Joan Moore Joan Moore-Mr D P Todd & Mrs H J Todd-196556 This person is a contact of GD Todd
HZ_PARTY:2649149 Joan Moore Joan Moore-Mr A S & Mrs C M Crossland-196560 This person is a contact of GD Todd
HZ_PARTY:2649140 Joan Moore Joan Moore - Person Party Record
HZ_PARTY:2649144 Joan Moore Joan Moore- Person Party Record
HZ_PARTY:1211 Joan Moore Joan Moore -Person Party Record
HZ_PARTY:2649147 Joan Moore Joan Moore -Person Party Record

How to remove these from the LOV?

Tried to merge and inactivate these parties and run Synchronize WF LOCAL tables program, but they still show in the LOV when submitting a concurrent request.

The records for Joan Moore were added by AR code, so the same code has to have an option to remove in AR.
After you remove them in AR, the synchronization between AR and WF should remove the rows from WF_LOCAL_ROLES.

Cause

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