PS_RSFD_SMGR_UPD Table Increases Exponentially when Running RSF_ACCESS Process (Doc ID 1959277.1)

Last updated on JUNE 14, 2017

Applies to:

PeopleSoft Enterprise CRM Sales - Version 9 and later
Information in this document applies to any platform.

Goal

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.

Solution

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