Accounting Calendar Options

Define an accounting calendar to create your accounting year and the periods it contains. Specify common calendar options that the application uses to automatically generate a calendar with its periods.

Specifying all the options makes defining a correct calendar easier and more intuitive with fewer errors.

Caution: The choices you make when specifying the following options are critical, because it's difficult to change your accounting calendar after a period status is set to open or future enterable.

• Budgetary control only

• Start Date

• Period Frequency

• Adjusting Period Frequency

• Period Name Format

Note: To help create and maintain accounting calendars, the common calendar types of monthly, weekly, 4-4-5, 4-5-4, 5-4-4, 4-week, quarterly, and yearly, are automatically generated. By using the period frequency option, you no longer have to go through the tedious task of defining each period manually.

Budgetary Control Only Check Box

Select the check box for Budgetary control only to use the calendar for budgetary control only. Budgetary Control refers to the group of system options and the validation process of determining which transactions are subject to validation against budgets and budget consumption to prevent overspending.

Start Date

If you plan to run translation, specify a calendar start date that's a full year before the start date of the year of the first translation period for your ledger. Translation can't be run in the first period of a calendar. Consider how many years of history you're going to load from your previous application and back up the start date for those years plus one more. You can't add previous years once the first calendar period has been opened.

Period Frequency

Use the period frequency to set the interval for each subsequent period to occur, for example, monthly, quarterly, or yearly. If you select the period frequency of Other, by default, the application generates the period names, year, and quarter number. You specify the start and end dates. You must manually enter the period information. For example, select the period frequency of Other and enter 52 as the number of periods when you want to define a weekly calendar. For manually entered calendars, when you click the Add Year button, the application creates a blank year. Then, you must manually enter the periods for the new year. The online validation helps prevent erroneous entries.

If the year has been defined and validated, use the Add Year button to add the next year quickly. Accept or change the new rows as required. For example, with the Other frequency type calendar, dates may differ from what the application generates.

Note: A calendar can have only one period frequency and period type. Therefore, if you have an existing calendar with more than one period type associated with it, during the upgrade from Oracle E-Business Suite, separate calendars are created based on each calendar name and period type combination.

Adjusting Period Frequency

Use the adjusting period frequency to control when the application creates adjusting periods. For example, some of the frequencies you select add one adjusting period at year end, two at year end, or one at the end of each quarter. The default is None which adds no adjusting periods. If you select the frequency of Other, the Number of Adjusting Periods field is displayed. Enter the number of adjusting periods you want, and then manually define them.

Period Name Format Region

In the Period Name Format section, enter the following fields:

• User-Defined Prefix: An optional feature that lets you enter your own prefix. For example, define a weekly calendar and then enter a prefix of Week, - as the separator, and the period name format of Period numberYY fiscal year. The application creates the names of Week1-11, Week2-11, through Week52-11.

• Format: A predefined list of values filtered on the selected separator, only displaying the options that match the selected separator.

• Year: The year displayed in the period names is based on the selected period name format and the dates the period covers or if the period crosses years, on the year of the start date of the period.

  • For example, April 10, 2016 to May 9, 2016 has the period name of Apr-16 and December 10, 2016 to January 9, 2017 has the name of Dec-16.

  • If period frequency is Other, then the period format section is hidden. The application generates a temporary period name for calendars with period frequency of Other, using a fixed format of Period numberYY. You can override this format with your own period names.

Note: For an accounting calendar that's associated with a ledger, changing period names or adding a year updates the accounting period dimension in the balances cubes.