PS_RSFD_SMGR_UPD Table Increases Exponentially when Running RSF_ACCESS Process
Last updated on JUNE 14, 2017
Applies to:PeopleSoft Enterprise CRM Sales - Version 9 and later
Information in this document applies to any platform.
PS_RSFD_SMGR_UPD table increases exponentially when running RSF_ACCESS process.
Is there a way to archive the contents of the table since this occupies a lot of database space?
Here is the Peoplebooks description of the Sales Access update(RSF_ACCESS) process:
Run Sales Access Update
Click to access the Sales Access Update page, where you can update sales users and their access.
Note. Each time that you create a sales user or change a user's visibility settings, you must run the Sales Access Update process to apply the change.
In Chapter 7:
Use the Tree Manager page to add nodes and define territories.
Note. After you make changes to a tree, run the Sales Access Update process to apply the changes. The Sales Access Update process updates the access that sales users have in a territory tree and the structure for rolling up forecasts.
However, it does not reassign leads or opportunities; use the reorganization or reassignment features of PeopleSoft Enterprise Sales for that purpose.
Here is the Peoplebooks link: https://docs.oracle.com/cd/E16107_01/psft/acrobat/crm91csfa-b1009.pdf
Chapter 7 also discusses how this process is called from within the application instead of through the PTools AE - Request AE menu.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms