GL Balance Cube Processes Run from Scheduled Processes Work Area
On the Scheduled Processes page, you can run the processes to create, rebuild, publish, and maintain Oracle General Ledger balances cubes.
The Create Cube process creates or rebuilds a balances cube based on a combination of chart of accounts and accounting calendar. The process automatically runs child processes for standard and average daily balance (ADB) cubes, if enabled.
The following table describes the child processes for creating a cube and also indicates the type of cube the process creates, whether standard or ADB.
Child Process |
Description |
Cube Type |
---|---|---|
Create Cube: Initialize Cube |
Starts the process to import data into the balances cube. |
Standard |
Create Cube: Create Calendar Dimension Members and Hierarchies |
Creates the calendar dimension members and hierarchies for a balances cube. |
Standard |
Create Cube: Create Ledger Dimension Members |
Creates the ledger dimension members for a balances cube. |
Standard |
Create Cube: Publish Chart of Accounts Dimension Members and Hierarchies |
Publishes chart of accounts and hierarchy changes to balances cubes and updates dimension members for any new or changed segment values. |
Standard |
Create Average Daily Balance Cube |
Determines the amount required to manually adjust general ledger account average balances to reflect the differences between the original and revalued customer open items. |
ADB |
Create Cube: Initialize Average Balances Cube |
Begins the process to import average balances into the balances cube. |
ADB |
Create Cube: Create Daily Dimension Members and Hierarchies |
Creates the daily calendar dimension members and hierarchies for a balances cube. |
ADB |
Create Cube: Create Ledger Dimension Members |
Creates the ledger dimension members for a balances cube. |
ADB |
Create Cube: Publish Chart of Accounts Dimension Members and Hierarchies |
Publishes chart of accounts and hierarchy changes to balances cubes and updates dimension members for any new or changed segment values. |
ADB |
Create Cube: Transfer General Ledger Balances to Essbase |
Transfer balances to balances cubes. |
Standard and ADB, if enabled, in same request |
The Publish Chart of Accounts Dimension Members and Hierarchies process publishes chart of accounts dimension member and hierarchy changes to balances cubes and updates dimension members for any new or changed segment values. The process affects both standard and ADB cubes in the same request, if ADB cubes are enabled. The process submits the child process Update Chart of Accounts Dimension Members and Hierarchies, which updates chart of accounts dimension member and hierarchy changes to Essbase.
The Transfer General Ledger Balances to Essbase process refreshes standard cube, and average balances cube if enabled, in the General Ledger balances cube.
The following table describes other cube processes that are run in the Enterprise Scheduler Service, and indicates the type of cube affected.
Parent Process |
Description |
Cube Type |
---|---|---|
Create Accounting Period Dimension for Standard Cube |
Creates the accounting period dimension members. |
Standard |
Create Ledger Dimension Members |
Creates and updates ledger dimension members including primary ledgers, secondary ledgers, reporting currencies, and ledger sets in the balances cubes. |
Standard and ADB, if enabled, in same request |
Create Currency Dimension Members |
Creates and updates all currencies in every balances cube. |
Standard and ADB, if enabled, in same request |
Create Scenario Dimension Members |
Creates and updates all scenario dimension members when new scenarios are created or existing scenarios are changed. |
Standard and ADB, if enabled, in same request |
Create Accounting Period Dimension for Average Daily Balances Cube |
Creates the accounting period dimension members in the average daily balances cube. |
ADB |
Create Rules XML File for BI Extender Automation |
Creates rules XML file for a specific Essbase cube, used for BI extender automation. |
Standard and ADB, if enabled, in same request |
To run the cube process, use the following steps in the Scheduled Processes work area from the Navigator menu.
-
Click Schedule New Process.
-
Search the process name.
-
Enter the parameters.
-
Enter the process options and schedule.
-
Click Submit.