Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Forecast Fields

The forecast revenue related fields (quota, closed revenue, quota %, forecast, pipeline, and expected revenue) are calculated. See the following table for more information about the fields.

Field

Description

Best Case

(Optional) This field represents a best-case estimate of the revenue that will be produced by all opportunity or product revenue.

This field is not applicable to account or contact revenue forecasts.

Closed Revenue

Read-only. This field is calculated. If your company bases its forecasts on opportunities, then the closed revenue is the total of all eligible opportunities with a sales stage of Closed-Won.

If your company bases its forecasts on products, then the closed revenue is the total of all eligible product revenue records during that period, with the sales stage of Closed-Won.

If your company bases its forecasts on account or contact revenues, then the closed revenue is the total of all eligible revenue records with a status of Closed.

Expected Revenue

Read-only. This field is a weighted average. The value is calculated based on the Potential Revenue field multiplied by the value in the Opportunity Probability field.

This field is not applicable to account or contact revenue forecasts.

Forecast

The value in this field is calculated when the forecast is generated. However, you can adjust the value in this field manually to make sure that the forecast reflects values based on your professional judgment.

If the Forecast check box is selected in the Opportunity record, the forecast is the total of all opportunities during the forecast period. If the Forecast check box is selected in the Revenue record, the forecast is the total of all revenue records during the forecast period.

Owner

Indicates the person who owns or is responsible for this forecast. Oracle CRM On Demand generates this information.

Last Updated

The date when the team member’s forecast record was last updated. The forecast date is displayed by default. If a user performs an edit, rollup, submit, or unsubmit for a forecast, this field shows the date the record was changed. Oracle CRM On Demand generates this information.

Pipeline

Read-only. This field is calculated. The pipeline is the total of all opportunity or product revenue records for the forecast period, regardless of the setting of the Forecast check box or sales stage on the individual records.

This field is not applicable to account or contact revenue forecasts.

Quota

Read-only. The sales revenue target for the forecast period. The quota can be set up by the individual user or the administrator. Only active quotas are used when creating forecasts.

Quota %

This field is calculated. The quota percent is the closed revenue value divided by the quota value.

Status

Oracle CRM On Demand generates the forecast status. The forecast status can be one of the following:

  • Active. Oracle CRM On Demand sets this status when forecast generation is complete.
  • Submitted. Oracle CRM On Demand sets this status when you click Submit Forecast. The record is locked unless your manager or a company administrator unlocks (unsubmits) it.
  • In Progress. Oracle CRM On Demand sets this status while the forecast is being generated.
  • Incomplete. Oracle CRM On Demand sets this status if there is an error while reading, associating, or rolling up revenue. An incomplete forecast can sometimes occur due to a user error, such as a hierarchy issue, or other data-related problems.
  • Pending. Oracle CRM On Demand sets this status if an issue occurs while processing your company's forecast. If your company administrator did not receive an email notification describing the forecast issue, contact Customer Care.
  • Archived. Oracle CRM On Demand sets this status 1 hour before it runs a new forecast. After this status has been set, the forecast becomes read-only, and you cannot unlock it.


Published 7/3/2018 Copyright © 2005, 2018, Oracle. All rights reserved. Legal Notices.