How Allocations Are Audited

You create allocations in the Enterprise Performance Management workspace using Calculation Manager and then you deploy them to Oracle General Ledger for use.

Allocation definitions are contained in General Ledger tables and Calculation Manager tables. When you enable audit for allocations using the Manage Audit Policies task in the Setup and Maintenance work area, the allocation definitions contained only in the General Ledger tables are audited.

This table shows how the tasks that you perform in Calculation Manager impact the General Ledger tables and appear on the audit report.

Allocation Tasks and Impacts

Task Impact on General Ledger Tables Audit Report
Create an allocation rule or rule set and deploy it. New rows inserted. Appears as inserts.
Update an allocation rule or rule set and deploy it. Existing rows deleted and new rows inserted. Appears as deletions and inserts.
Delete an allocation rule or rule set. No impact on General Ledger tables until cube level deployment. Since only General Ledger tables are audited, deletions won’t appear.
Deploy a cube with allocation rules or rule sets. All rows deleted and new rows inserted only for allocations that currently exist in Calculation Manager. Rules and rule sets that were deleted appear as deletions.
Here’s how you sync all allocation definitions between the General Ledger and Calculation Manager tables for a cube.
  1. From the System View tab in Calculation Manager, right-click the cube name.
  2. Select Deploy. This action deletes all the allocations in the General Ledger tables for the selected cube and then recreates the allocations that exist in Calculation Manager.