Only One Primary Email Permitted
After upgrading to PeopleTools 8.51, the sign on page started displaying the following message:
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
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 (
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