Understanding Level of Rollup (Release 9.2 Update)

When you are creating a forecast, the system copies in account information from the F0901 into your forecast. The records include the level of detail (LD) for each account. If your accounts are at a very detailed level (for example, level 8 or 9), you might want to summarize those detailed accounts under a lower level account for forecasting purposes.

For example, you might have several labor accounts such as overtime labor, regular labor, or premium labor. However, you might want to forecast labor under the lower level labor account.

To do this, you can roll up detailed accounts under their lower-level account. First, you use the processing option to specify whether you are allowing forecasters to roll up accounts at a level of detail of 8 and 9 under accounts at a level of detail of 7, or whether you allow them to roll up only accounts at level of detail 9 under accounts at a level of detail of 8, which is the default setting. Note that the level of detail is retrieved from the F0901, and cannot be changed on the forecast.

To roll amounts up into a lower level, or "rollup" account, you:

  1. Set the method of computation on the rollup account to W, Y, or Z.

  2. Set the method of computation for all accounts that you want to roll up into the rollup account to I (inclusion).

    Note that these accounts must have a higher value in the LD column than their associated rollup account.

  3. Click OK to save your changes and then exit the form. When you return to the form, you will see your accounts are now displayed differently, with the summarized current and prior actual amounts and units.

    Note: After you click OK, the account rollup data is processed asynchronously. Therefore, clicking Find might not display complete results, as it could return your results before the process is complete. Therefore, Oracle recommends that you exit the form and then return to the form to ensure your view is accurate.