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

FCCS - IMPORT METADATA ASSIGNING NEW PLUG ACCOUNT TO ICP ACCOUNT AT SECOND ATTEMPT

FCCS - IMPORT METADATA ASSIGNING NEW PLUG ACCOUNT TO ICP ACCOUNT AT SECOND ATTEMPT 

While importing new plug accounts and tagging the new plug accounts to the existing intercompany accounts, users might get into a situation where the import metadata process fails at the first attempt and gets success in the second attempt...

Users might the below error as well 

ERROR MESSAGE
java.lang.RuntimeException: Attribute value: AC_XXX062 invalid for attribute
dimension: Plug Account
java.lang.RuntimeException: Attribute value: AC_XXX062 invalid for attribute
dimension: Plug Account

SOLUTION

This is the expected behavior with FCCS.

The first pass (first import) is when the accounts that are tagged as plug accounts are created. In the second pass, you will be able to assign those accounts as plug accounts.

How to restrict users from viewing load files from other locations in FDMEE

Create two locations in the names (example) "ForlocationA" and "ForlocationB"
Created two new users "USER A" and "USER B"
In Data Management enable "Location security" under Setup > Security settings
Click on "Maintain User groups" with prefix A and suffix K (anything)

Now new groups "A_ForlocationA_K" and A_ForlocationB_K" will be created

Assign those two groups with either Create Integration, Run Integration or any Intermediate roles.

Then in Shared services, assign USER A as a member of Group "A_ForlocationA_K"
Then in Shared services, assign user B as a member of Group "A_ForlocationB_K"

Then grant both the users USERA and USERB with the roles Create Integration, Run Integration roles

Then login to the workspace with userA - navigate to select Inbox and you will be able to see the folder ForlocationA alone
Then login in to the workspace with userB - navigate to select Inbox and you will be able to see the folder ForlocationB alone

You will not be able to see other locations created by other users when that respective user is logged in,

Where to find the EPM Logs and its location - Hyperion

EPM Registry Report

a. On Foundation server go to the location \Oracle\Middleware\user_projects\epmsystem1\bin
b. Run the batch epmsys_registry.bat.
c. This will generate the Registry.html file under the location \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports

EPM Deployment report

a. On Foundation server go to the location \Oracle\Middleware\user_projects\epmsystem1\bin from the COMMAND PROMPT.
b. Run the command 'epmsys_registry.bat report deployment'
c. This will generate the deployment_report.html file under the location \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports

Ziplogs

a. On the Server go to the location \Oracle\Middleware\user_projects\epmsystem1\bin.
b. Run ZipLogs.bat
c. The output of this is generated in \Oracle\Middleware\user_projects\epmsystem1\diagnostics\ziplogs\EPM_logs__11.1.2.x.0.zip

Submitting an UDR from EPM cloud Environment along with snapshot to Oracle Support

From the Simplified Interface - open Setting and Actions by clicking your username (displayed at the right top corner of the screen) -> Select Provide Feedback -> Enter a brief description -> Click the Submit button -> Click the Confirm Application Snapshot Submission > ON ->Click on Submit button again.

How to restart the services of an EPM Cloud Environment

How to restart the services of an EPM Cloud Environment 

Using the EPM Automate feature users can do a restart of their EPM Cloud environment.

The command to be used is as follows,

Ex: epmautomate resetservice "Users experience unacceptably slow connections"

Working with EPM Automate

1. Download the latest version of EPM Automate
    Login to your EPM Cloud Service
    Tools -> Install -> EPM Automate

2. Install EPM Automate
    Run the EPM Automate.exe downloaded in step 1

3. Use EPM Automate using a command prompt

    - Open Command Prompt
    - Navigate to the install Location

Example: CD :\Oracle\"EPM Automate"

- Login to EPM Automate

epmautomate login / identitydomain

Example: epmautomate login https://.pbcs.us2.oraclecloud.com mydomain

- Run reset Service Command

epmautomate resetservice "Users experience unacceptably slow connections"

Is it Possible to Disable EPM Cloud Passwords from Expiring

This is not possible as it is a violation of password policies,

The only workaround is to enable SSO with their own Identity Provider (IdP) and customer can manage their own password policies.

Please see the documentation for the same below :
https://docs.oracle.com/en/cloud/paas/process-cloud/cprcw/configuring-federated-sso-and-authentication.html

An Enhancement was raised with regard to this and it was rejected.