9Setting Up the Accounting Calendar

This chapter contains the following:

About Setting Up the Accounting Calendar for Oracle Sales Cloud

The accounting calendar defines time periods including the exact dates for each period. These defined periods, often called enterprise periods, are used for many purposes in Oracle Sales Cloud. Examples include:

  • Reports that provide amounts by enterprise period, such as a sales pipeline analysis

  • Metrics calculations by period for territory analysis

  • The ability to adjust forecast amounts by time period

  • Distribution of quota amounts by time period

The period frequency set in your fiscal calendar is the shortest period you can use. Therefore, if you set the period frequency to yearly, then your reports and activities can be for each year, but can't be broken down by month. If you set the period frequency to monthly, then you can break down activities and reports by month and summarize by quarter and year. However, if you set the period frequency to weekly, then you can perform activities and reports by week, quarter, and year, but not by month because the number of weeks per month varies.

Setup Overview

Setting up your accounting calendar requires two steps:

  1. Create the calendar. For Oracle Sales Cloud you create only one calendar.

    For details, see Creating the Accounting Calendar.

  2. Designate the calendar you just created as the calendar you will use by setting the Accounting Calendar Default profile option.

    For details, see Enabling the Accounting Calendar You Created.

Creating the Accounting Calendar

Use this procedure to create the accounting calendar, which sets the exact start and end dates for each period, for each year.

Creating the Calendar

  1. Sign in as a setup user.

  2. In Setup and Maintenance, search for the Manage Accounting Calendars task.

  3. Click Go To Task.

  4. On the Create Accounting Calendars page, click Create.

    Calendar Options Screen
  5. Name your calendar, for example, Sales Calendar.

  6. Leave the Adjusting Period Frequency set to None.

  7. For Start Date, Vision is using 1/1/10.

    You cannot change the settings after you start using the application, so consider setting the date to the first date that your company was created. Then you can upload historical data later, if necessary.

  8. For Period Frequency, select the shortest time period you want to use for reports and activities. For Vision Corporation, we choose Monthly. The period starts on the first of the month and ends on the last day of the month, regardless of the number of days or weeks in each month. Another choice, for example, is where the first two months consist of four weeks, and the third month contains 5 weeks.

  9. For Vision Corporation, choose None for the Separator.

  10. Select the format to use for period names.

    Period Name Format Region
  11. Click Next. The application generates the periods, with start and end dates, for the first year (2010 for Vision Corporation).

    Period Details Table
  12. If needed, you can manually change the details for each period. Click Save and Close.

  13. Now you need to generate the periods for each additional year, including the current, or coming year. Open the calendar.

  14. Click Add Year.

  15. Click Save and Close.

  16. Repeat the last three steps for each year you want to add.

  17. Click Done.

Restriction

You cannot change your calendar options after you start using the calendar, such as by generating forecasts.

Enabling the Accounting Calendar You Created

You enable the calendar you created by selecting it to be the default calendar. Many features of Oracle Sales Cloud use the common calendar, so changing the selected calendar in the future can result in the loss of data.

Enabling the Calendar

  1. Sign in as a setup user or sales administrator.

  2. Search for the Manage Calendar Profile Option task.

  3. Click the Go To Task icon.

  4. On the Manage Calendar Profile Option page, select the Accounting Calendar Default profile option.

  5. In the Profile Values table, click New.

  6. For Profile Value, select Site.

  7. Click the Profile Value list, and select the name of the calendar you created.

    Manage Calendar Profile Option
  8. Click Save and Close.