Saturday, July 11, 2020

Budgetary control cubes available in Fusion General Ledger are not visible in EPM Cloud Data management

In EPM Cloud Data management, users might have configured the Fusion General Ledger as the source system.
After initialization, users might see the Chart Of Accounts visible under the target application page but not the Budgetary cubes.

CAUSE

The source type of the control budget was not defined correctly.
 

SOLUTION

Budgetary Control Balance cubes and their underlying control budgets are eligible for integration with the Oracle Enterprise Performance Management Cloud when the control budget in Budgetary Control:
  • has a "Planning" Source Budget Type.
  • does not have Project Portfolio Management keys as a budget segment
  • is associated with a Budgetary Control Balances cube

To begin integrating the Budgetary Control with the EPM Cloud, create and register the source system with the source system type "Oracle ERP Cloud".
Select the check-box, Fusion Budgetary Control.
When Budgetary Control is enabled, only Budgetary Control applications, as indicated by an "XCC _" prefix, are imported.
After the source system and connection information are specified, initialize the source system to copy the Budgetary Control information to EPM Cloud as one of many Essbase target applications.

Note : Make sure the source system name does not include any spaces. For example, use FinCloudBC rather than Fin Cloud BC.

To find whether the budgetary cubes are created refer the document below,
Fusion Applications BI Publisher How Can I Use BI Publisher to Run SQL Against the Fusion Applications Database (Doc ID 1910762.1)

After confirming that the cube is visible in ERP, 
  • Go to Fusion GL
  • From the home page > select Budgetary control - it will lead to the Budgetary  control dashboard
  • Select the tasks icon, which will be in the top right corner
  • Select Manage Control Budgets
  • Select the respective control  budget and click on Edit 
  • Set the source budget type to "Hyperion Planning"
  • Click Save 
  • Then re-initialize the Fusion GL source system in Data management 
  • The Budgetary cubes should be visible under Target application page

Other posts

How is the data size calculated for a EPM Cloud service instance?

The total size of data used by your EPM Cloud service instance is the sum of the following: Application data stored in Essbase Artifact...