Thursday, June 25, 2020

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.


Thursday, February 13, 2020

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,

Sunday, February 9, 2020

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"

Saturday, February 8, 2020

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.

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 Snapshot created by the daily maintenance window
  • All snapshots that you have exported via EPM Automate or the Migration user interface
  • All snapshots that you have uploaded via EPM Automate or the Migration user interface
  • All data files that you have uploaded via EPM Automate or the FDMEE user interface

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...