Generate Sales Forecast Metrics

After enabling Sales Forecasting for Redwood UX, the Generate Sales Forecast Metrics process is automatically run without parameters. This process performs the initial calculation of all sales forecasting metrics used throughout your Redwood UX application.

In addition, you can also run this process to recalculate metrics in case of data corruption or when there’s several changes to resources, resource hierarchy, territories, territory hierarchy or products.

The process completes the following:

• Creates the forecast periods starting from the current period to the available periods defined in the GL_PERIODS table.

Note: The GL_PERIODS table contains the value retrieved from the profile option ZCA_COMMON_CALENDAR. If this value is changed, forecast periods and metrics must be recreated. This is a read only parameter and might not be set in the setup REST or UI.

• Uses the default calendar specified by the ZCA_COMMON_CALENDAR profile option.
• Generates the forecast metrics based on the following:
  • Best Case (BESTCASE)
  • Committed (COMMIT)
  • Pipeline (PIPELINE)
  • Won (WON)
  • Omitted (OMIT)

If you're using the default Forecast by Opportunity Owner method, then the Generate Sales Forecast Metrics process is used to update resources and the resource hierarchy. If using the Forecast by Opportunity Revenue method, then the process is used to update territories and the territory hierarchy, and products and the product hierarchy.

Note: Sales Forecasting for Redwood UX uses the corporate currency as defined in the ZCA_COMMON_CORPORATE_CURRENCY profile option.

Schedule the Generate Sales Forecast Metrics Process

Typically, you run the Generate Sales Forecast Metrics process once for each forecasting period. You can run this process more than once.

Run this process:

• At least 2 weeks before the next active period + 1 start date
• Regularly. For example, run daily to refresh the sales forecast information when there’s many resources, resource hierarchy, territory, territory hierarchy or product changes

The processing time varies based on the number of opportunities and territories or resources. The period name is optional.

Name	Description	Sample Value	Optional or Mandatory	Notes
Period name	The name of the period.	Q2-2023	Optional	If no period is specified, then this process runs for the current active period and next period (assuming the active period parameter is set to 2) Typically, this process is run once for each period. When a period is specified, it runs only for that period.