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.

1. Click Schedule New Process.

2. Search the process name.

3. Enter the parameters.

4. Enter the process options and schedule.

5. Click Submit.