Overview of Allocations and Periodic Entries

In Oracle General Ledger, use the Calculation Manager to create allocations and other formula journal templates for generating periodic journal entries automatically.

Allocations are defined and generated from preaggregated balances in the GL Balances cubes, which provide the following benefits:

  • Immediate real-time access to financial balances for allocations and periodic entries.

  • Accelerated performance for complex allocations.

You can base formulas on multiple criteria. For example:

  • Use account balances or statistical amounts to allocate shared revenue or costs across multiple organizational units and ledgers.

  • Define complex computations based on variables from different charts of accounts.

  • Group journal formulas together and run sequentially to update account balances in a step-by-step process.

Note: You can't create allocations for average daily balances cubes. Average balances are used for reporting.

The Calculation Manager provides flexibility, automation, intelligence, and control in distributing costs and revenues across the enterprise. In addition, the Calculation Manager:

  • Includes runtime variables, rules, formulas, and rule sets stored in Oracle Essbase.

  • Distributes revenues or costs with recursive allocation rules.

  • Creates complex formula rules using formula components.

  • Contains an Allocation Wizard to define allocation and formula rules.

  • Uses real-time checking of rule definitions to validate correctness of rules.

  • Minimizes setup and maintenance time with reusable components.

  • Simplifies allocation generation mechanism by integrating with enterprise schedule.

  • Groups rules together in rule sets and cascading allocations for efficient processing.

  • Creates primary, statistical, or foreign currency allocation and formula rules.

Access the Calculation Manager from the Tasks pane of the General Accounting dashboard or Journals work area by clicking the:

  • Define Allocation Rules link to define or modify allocation definitions

  • Generate Allocations link to run the allocation process