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 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.
No Comments