Overview
This article provides information on how to resolve an error when attempting to update Favorites within PeopleSoft. If an error is encountered when trying to delete or update a Favorite under ‘My Favorites’, there are two methods to resolve this condition.
Detail
If an error is encountered when trying to delete or update a Favorite under ‘My Favorites’, there are two methods to resolve this condition.
Method A (the scalpel)
- First identify all of the existing ‘Favorites’ links which are not visible in ‘Favorites’. To do this, first click on Favorites > Edit Favorites. Then compare the blue links under ‘Favorites’ to the those listed under ‘Edit Favorites’. Any Favorite listed under ‘Edit Favorites’ and not under ‘Favorites’ are invalid.
- Click Delete for all the invalid favorites. (IMPORTANT: All invalid favorites must be deleted before saving or error will persist.)
- Click Save.
- Now you should be able to navigate to desired pages and add them to ‘My Favorites’.
Method B (the sledgehammer)
- Click on Favorites > Edit Favorites.
- Delete all Favorites
- Click Save
- Add all desired Favorites again.
Related Information
If unable to update Favorites after following the above, or Method B is not preferred, please use Request Help to create a ticket for further assistance.
For Internal Student Systems Team Only
If Method A does not resolve the customers issue and they are not in favor of Method B, use the following SQL to assist with identifying the invalid favorites that need to be deleted.
select * from PSPRUFDEFN A where PORTAL_REFTYPE='V' and not exists
(select 'X' from PSPRSMDEFN B
where A.PORTAL_NAME=B.PORTAL_NAME
and A.PORTAL_OBJNAME = B.PORTAL_OBJNAME)
and oprid = 'username' -- Change username accordingly
This will identify invalid favorites for the customer. Ask the customer to delete all identified invalid favorites, then save. (IMPORTANT: All invalid favorites must be deleted before saving error will persist.)