Only One Primary Email Permitted


After upgrading to PeopleTools 8.51, the sign on page started displaying the following message:

only-one-primary-email-address-is-permitted.png

Only one Primary Email Address is permitted. (48,9)

This message may also appear when you are trying to update a user profile. It is caused by users having more than one primary email address flagged in the PSUSEREMAIL table:

select OPRID, count(*)
from PSUSEREMAIL
where PRIMARY_EMAIL = 'Y'
group by OPRID
having count(PRIMARY_EMAIL) > 1;

The fix is to change the PRIMARY_EMAIL flag from Y for all but one email address for each User (OPRID).

One way is to set the primary email flag to N where an email address has not been specified (this may not always be an option).

update PSUSEREMAIL
set PRIMARY_EMAIL = 'N'
where PRIMARY_EMAIL = 'Y'
and EMAILID = ' '
and OPRID in (
    select  OPRID
    from    PSUSEREMAIL
    where   PRIMARY_EMAIL = 'Y'
    group by OPRID
    having count(PRIMARY_EMAIL) > 1
);

Other fixes might including picking a specific email type (e.g. BUS) as the primary email and changing all other types so that the primary email flag is N.


Revision #1
Created Sun, Jul 28, 2019 6:54 PM by PeopleSoft Wiki
Updated Sun, Jul 28, 2019 6:56 PM by PeopleSoft Wiki