My Oracle Support Banner

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

Last updated on JULY 10, 2020

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 '%FirstName LastName%';

Originating System Name is Trading Community Architecture Parties

HZ_PARTY:2649142 FirstName LastName FirstName LastName -G D Name-196551 QUERY
HZ_PARTY:2649146 FirstName LastName FirstName LastName -Mr D P Name & Mrs H J Name-196556 QUERY
HZ_PARTY:2649149 FirstName LastName FirstName LastName -Mr A S & Mrs C M Name1-196560 QUERY
HZ_PARTY:2649147 JFirstName LastName FirstName LastName QUERY
HZ_PARTY:2649144 FirstName LastName FirstName LastName QUERY
HZ_PARTY:2649140 FirstName LastName FirstName LastName 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 FirstName LastName FirstName LastName -G D Name-196551 QUERY
HZ_PARTY:2649146 FirstName LastName FirstName LastName -Mr D P Name & Mrs H J Name-196556 QUERY
HZ_PARTY:2649149 FirstName LastName FirstName LastName -Mr A S & Mrs C M Name1-196560 QUERY
HZ_PARTY:2649140 FirstName LastName FirstName LastName QUERY
HZ_PARTY:2649144 FirstName LastName FirstName LastName QUERY
HZ_PARTY:1211 FirstName LastName FirstName LastName MAILHTML
HZ_PARTY:2649147 FirstName LastName FirstName LastName 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 JFirstName LastName FirstName LastName -G D Name-196551 - This person is a contact of GD Todd
HZ_PARTY:2649146 JFirstName LastName FirstName LastName -Mr D P Name & Mrs H J Name-196556 This person is a contact of GD Todd
HZ_PARTY:2649149 FirstName LastName FirstName LastName -Mr A S & Mrs C M Name1-196560 This person is a contact of GD Todd
HZ_PARTY:2649140 FirstName LastName FirstName LastName - Person Party Record
HZ_PARTY:2649144 FirstName LastName FirstName LastName- Person Party Record
HZ_PARTY:1211 FirstName LastName FirstName LastName -Person Party Record
HZ_PARTY:2649147 FirstName LastName FirstName LastName -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 FirstName LastName 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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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