What are the steps to set up rollups?

Here’s a summary of how to define rollups for Sales. All the privileges, setups, and tasks involved in setting up rollups for both the classic and Redwood user experience is provided.

This table provides the initial setup steps for rollups, navigation, brief description, and where to get more details.

Step	Applies To	Description	Navigation	Where to Get the Details
1	Both classic and Redwood user experience	Add the Manage Rollup Metrics privilege to a copy of the Sales Administrator job role (ORA_ZBS_SALES_ADMINISTRATOR_JOB). To the role, add users responsible for configuring and setting up rollups.	Navigator > Tools > Security Console > Roles	See the Edit Job or Abstract Roles topic in the Securing Sales and Fusion Service guide for more information.
2	Both classic and Redwood user experience	Verify that these scheduled processes appear on the Scheduled Process page: Rollup Full Refresh Rollup Account Hierarchy and Linked Records Refresh Rollup Incremental Refresh When you unpublish or delete a rollup, the Data Cleanup scheduled process prompts you to clear the data.	Navigator > Tools > Scheduled Processes	See the Run Scheduled Processes for Rollups topic in the Implementing Sales guide for more information. See also the Scheduled Processes chapter of the Understanding Scheduled Processes guide.
2	Both classic and Redwood user experience	After adding the privileges for the users, they get access to the Rollups setup page. Enable the Rollup Test Enabled profile option (ORA_ZCA_TEST_ROLLUPS), to display the Test tab on the Rollups setup page.	Setup and Maintenance > Sales > Sales Foundation > Manage Administrator Profile Values	See the Test and Publish the Rollups topic in the Implementing Sales guide for more information.
3	Both classic and Redwood user experience (optional)	When creating new rollups, you can reuse the rollup attributes of unpublished rollups or create custom attributes and publish them. The custom attributes will be available on the Rollups setup page.	Application Composer > Standard Objects > Account > Account Rollups > Fields Navigation is similar for contact rollups and other object rollups.	See the information on defining fields in the Configuring Applications Using the Application Composer guide.
4	Classic user experience (Preferred)	Use the formula fields instead of a regular field to create a custom attribute for rollups. Unlike regular fields, formula fields let you build a script with rules related to calculations.	Application Composer	See the Configure Custom Rollups Using the Formula Fields topic in the Implementing Sales guide for more information.
5	Classic user experience (Optional)	When creating rollups that depend on fiscal year periods, such as current quarter, use the accounting calendar periods. The accounting calendar defines the fiscal year and the time periods within it.	Related Object Filter on the Define Rollups setup page.	See the Use the Accounting Calendar Time Periods for Your Rollups topic in the Implementing Sales guide for more information.
6	Redwood user experience	Use the Visual Builder Studio to add custom rollups to Redwood user experience pages. You can also show the rollups on the panels in Redwood user experience.	Settings and Actions > Edit Page in Visual Builder	See these topics in the Extending Sales in the Redwood user experience guide: Add a Custom Field to the Edit Contact Page Configure the Rollups Region in a Panel To access this guide, contact your Oracle representative.
7	Classic user experience	Enable the Rollups subtab on object pages in the Classic user experience.	Application Composer	See the Show Rollup Attributes on the Object Pages topic in the Implementing Sales guide for more information.
8	Both classic and Redwood user experience (Optional)	Enable rollups for Adaptive Search. Let salespeople search accounts or contacts using rollups as search criteria.	Setup and Maintenance > Sales > Sales Foundation > Configure Adaptive Search	See the Enable Searching for Accounts and Contacts Using Rollups topic in the Implementing Sales guide for more information.
9	Redwood user experience (Optional)	Enable Rollups as group by options so that salespeople can use them to group accounts and contacts by common attributes.	Setup and Maintenance > Sales > Sales Foundation > Configure Adaptive Search	See the Enable Grouping by Rollups topic in the Implementing Sales guide for more information.

Here's the navigation to the Rollups setup page:

Go to Navigator > Configuration > Application Composer.
Under Advanced Setup, click Define Rollups.
Note: You don't need to be in a sandbox to access the Define Rollups page.

Here's a sample screenshot of the Define Rollups page:

The table below describes the components of the Define Rollups page.

Callout	Name	Description
1	Setup	Shows the entire list of rollups. The list includes all published and unpublished rollups, both predefined and custom You can sort the columns by name, type (Regular or Aging), source object (Account), related object of the rollup, published status, and the last refresh status of the rollup.
2	Actions	Create: Use this option to create a new rollup from scratch. Duplicate: Use this option to create a working copy of a predefined rollup. Edit: Use this option to change the parameters of a custom rollup. For predefined rollups, you can change two parameters: the hierarchy for, account rollups, and calculation frequency. Delete: Use this option to delete custom rollups. You can't delete predefined rollups; you can only unpublish them.
3	Monitor	Full Refresh: Run a full refresh every time you publish a rollup. Incremental Refresh: Schedule an incremental refresh so that published rollups are regularly updated with the latest values. You can set this process to run once hourly. Note: Full refresh is used only after the rollups are published for the first time. After that, Incremental Refresh takes care of recalculating and publishing the rollups periodically. Hierarchy Refresh: This process is applicable for account rollups only. Schedule or run a hierarchy refresh to recalculate account rollups if a hierarchy changes. Data Cleanup: Schedule a data cleanup so that whenever you delete or unpublish a rollup, the rollup engine runs this process and clears the calculations.
4	Test	Test the unpublished rollups to ensure that they're producing correct calculations.