Generating Periods

To run the script to generate periods:

  1. On the PPM Server, navigate to the directory that contains the script:

    cd <PPM_Home>/bin

    where <PPM_Home> represents the path where your PPM instance is installed.

  2. Run the following script:

    sh ./ -startYear <yr1> -endYear <yr2>

    where <yr1> and <yr2> are years specified with four digits.

    For example, if you want to add periods from fiscal year 2007 to fiscal year 2025, run the following script:

    sh ./ -startYear 2007 -endYear 2025

    Note: If part or all of the specified range of fiscal years exists, the existing range is not regenerated.

    If generating the specified range of periods would create a time gap between that range and the existing set of periods, the script also generates periods to fill that gap.

    The cumulative set of generated time periods cannot exceed 65 years (up to 15 years in the past and up to 50 years in the future).

    The script saves the generated periods in a preview file fiscal_periods_<time stamp>.csv in the <PPM_Home>/bin/fiscal/output directory for you to verify before you commit the periods to the database.

  3. Verify that the periods listed in the preview file are appropriate.
  4. When you are satisfied with the data in the preview file, run the script again for the desired range of years but add the commit option to add the periods to the database.

    Periods are added for the system default language and for all the other languages that have been configured using the script. For information about configuring languages so that the script generates periods in those languages, see Generating Periods in Additional Languages.