My Oracle Support Banner

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

Last updated on DECEMBER 10, 2019

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:

Chapter 7 also discusses how this process is called from within the application instead of through the PTools AE - Request AE menu.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.