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.
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
No comments:
Post a Comment