Showing posts with label Admin guide. Show all posts
Showing posts with label Admin guide. Show all posts

Monday, April 25, 2022

Cloning Applications between environments using Clone Environment option in Oracle EPM Cloud

 Cloning Applications between environments using Clone Environment option in Oracle EPM Cloud  

Click on Navigate > Under Tools section > Click on Clone Environment  


Enter the details of your Target environment where you need to clone this application

Target environment URL, Target environment Username, Target environment Password

Roles Required

You must have either a Service Administrator or a Service Administrator with Identity Domain Administrator predefined role.

For Oracle Cloud Classic to OCI cloning, you must sign in as a Service Administrator, who also has the Identity Domain Administrator predefined role to ensure that users and their roles are cloned to the OCI environment.


For cloning artifacts, you can choose the options as per your requirements



  1. Optional: Select the Users and Predefined Roles check box to clone users and their predefined role assignments.

If you are performing an Oracle Cloud Classic to OCI migration, you must select this check box.

  1. Optional: for environments other than Oracle Enterprise Data Management Cloud and Narrative Reporting only: Deselect the Data Management check box if you do not want to clone Data Management records. Cloning of Data Management records may take a long time if the staging tables contain a very large number of records.

Clone Data Management records only if both the source and target environments are on the same monthly update or the target environment is one update newer than the source environment. For example, you can clone 22.01 Data Management records to another 22.01 environment or to a 22.02 environment only.

  1. Optional: for Planning, Planning Modules, Free Form, Financial Consolidation and Close, and Tax Reporting only: Deselect the Job Console check box if you do not want to clone Job Console records.
  2. Optional: for Planning, Planning Modules, and Free Form only: Deselect the Application Audit check box if you do not want to clone application audit records.

Note: Application audit data of Financial Consolidation and Close, and Tax Reporting is, by default, included in the snapshot.

  1. Optional: Select the Stored Snapshots and Files check box if you want to clone the contents of inbox and outbox, and stored snapshots. This process may take a long time depending on the number and size of stored snapshots and files in inbox and outbox.
  2. Click Clone to initiate the process.

Tasks to Perform After Cloning Environments

1.       Daily Maintenance Start Time

The daily maintenance start time of the target environment is automatically reset to that of the source environment from which the snapshot was cloned, ensure to change the time in the target environment accordingly.

2.       Update EPM Automate Scripts

If you have written any script to perform an activity, ensure the script is updated with the target environment URL with identity domain name updated.

Also, if you are using native accounts then ensure password is updated In the scripts.

3.       Smart View URLs

Modify the public and private connection Smart View URLs so that they point to the cloned environment. Also, update connection URLS as needed.

4.       Integrated Business Process

a.       Single Sign On

If you are moving multiple instances in an integrated business process to a new domain, SSO between instances will not work until all instances are migrated.

If you had setup SSO to authenticate the users and the migration resulted in a change in the identity domain being used, for example, after Oracle Cloud Classic to OCI migration, you must reconfigure SSO.

While cloning between same domains SSO need not be reconfigured, instead update the PROD application in the list.

b.      Updating Integrations and Connections details

There are places where you need to update the connection details, like updating data management target application connections, source system connections, ensure the URL`s, Usernames and password are updated accordingly.


Thursday, March 10, 2022

EPM Cloud Data management / FDMEE / Troubleshooting steps

 


Required Roles for Loading Data

If you have an issue with loading data to Oracle Enterprise Performance Management Cloud using Data Integration, Data Management, EPM Automate or REST APIs, make sure that the user loading the data has one of the following roles:

  • Service Administrator predefined role
  • Power User predefined role and Run Integration application role

How to trace issues  using ERROR log

  • The process details log in data management is the key log to trace any issues
  • Ensure the Log level is set to 5 under System Settings tab > select Profile type to ALL
  • Open the process details log in Notepad / Notepad++
  • Find (Ctrl+F) for the key word "error"

How to determine the load status from DATA LOAD  WORKBENCH

In the Workflow tab > Data load workbench > there are four icons (fish icon) > Import , Validate , Export , Check

If the Import fish is grey, then the import step is failed the source system level 

  • Ensure the source system connection is setup correctly 
  • Ensure the file name is defined correctly in the data load rule 
  • Ensure the data is available in the source combination in which it is extracting 
  • Ensure the source filters are defined properly 

If the Import fish is Orange and Validate fish is Grey

  • Go the Data load workbench > click on Validation errors 
  • You will find the details of the missing mapping members 
  • Ensure the mappings are defined correctly for those members and re-run the validate step

If the Import fish is Green, Validate fish is Green but the Export fish is Grey

  • Ensure the connection is available and the properties of the target system is defined properly for the target system
  • In the error log you will find an error code "Error: 3303", "Error: 3335" - it describes that the member is not available in the target 
  • In those scenarios we need to manually create the members in the target system if it valid

Known error codes and solution

3303 Member not found in database.

3304 Insufficient access to store data.

3333 Bad data value supplied.

3335 Record rejected because of duplicate member names.

3336 Member/Data unknown.

3337 Record rejected because of dimension conflicts with Header Name


Thursday, March 3, 2022

Configuring SSO : Other sources with Oracle (Oracle Fusion General Ledger)

 Quick links


OPC IDP File Gneration  -  

https://<POD NAME>.login.<DC>.oraclecloud.com/fed/IDP/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

Eg : 

https://EGUP-DEV5.login.us2.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256


OCI SP File Generation  -  

https://login-<POD Name>-saasfaprod1.fa.ocs.oraclecloud.com/fed/sp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

Eg  :  

https://login-esax-test-saasfaprod1.fa.ocs.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256


OCI IDP File Generation  -  

https://login-<POD Name>-saasfaprod1.fa.ocs.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256

Eg  :  

https://login-esax-test-saasfaprod1.fa.ocs.oraclecloud.com/fed/idp/metadata?signid=osts_signing_sha256&encid=osts_encryption_sha256&sigalgm=SHA-256



Sunday, February 9, 2020

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.

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