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

How to overcome Blank page issue during Drill-through via Smartview in EPM Cloud

In EPM Cloud, (PBCS,EPBCS) users might face an issue while doing a drill-through to data management or drill-through to source values.
Users might get a Blank page during the process.

The Smart View extension (add-in) for the browser would have not been installed.

To install the add-ins, refer the steps below

Chrome: 

Download the Smart View for Office extension from the Chrome web store.

Firefox:


Information about the Firefox add-in -
https://docs.oracle.com/applications/smartview/720/SVNST/firefox_extension_100x0867c8ee.htm#SVNST-GUID-DA412821-E7CD-40E4-9CA0-9739D8CAC0D8

For, IE11 - The following settings changes have to be completed -


Go to Tools > Internet Options > General > Tabs

Choose Open links from other programs : The current tab or window


Thursday, February 6, 2020

New and missing features in Cloud Data Management in comparison to FDMEE on-premise

New and missing features in Cloud Data Management in comparison to FDMEE on-premise


Significance of Data Management in Cloud



Significance of Data Management in Cloud 

Cloud Data Management is intended to allow an organization to adopt a pure Cloud solution for Oracle EPM deployments.

  • Cloud Data Management is a module within the Oracle EPM Cloud Services.
  • It is built using the same code line as on-premises FDMEE.
  • Cloud Data Management can integrate flat files.
  • It includes all the on-premises FDMEE transformation capabilities including SQL mapping which can accommodate complex transformations.
  • It includes the prebuilt logic to natively load data to each of the Oracle EPM Cloud
  • Service offerings.
  • Cloud Data Management can integrate with other Oracle Cloud Service offerings
  • including the ability to source data from and load data back to Fusion G/L Cloud.
  • As well, it can source data from other Oracle EPM Cloud Services.

Monday, December 16, 2019

Error "Active Time Limit Exceeded - Call Aborted" When Exporting Data to PBCS Application Through Data Management

In Data Management, Load method was not set properly for Oracle Planning and Budgeting Cloud Service(PBCS) application especially for multi-period loads.

Kindly refer the steps below,
  • Click on Navigate and go to Data management
  • In Target Application, select the application and click on Application options
  • Define the Load Method as "All data types with security" and save the changes.
  • Goto Data Load Rule -> Target Options -> Ensure Load Method is also set to "All data types with security" and save the changes
  • Re-run the export task for multiple periods and it should work fine.
Note :
The above steps are applicable for the loads with less number of rows.
If the file size is huge(i.e have millions of rows), then above steps would not help to fix the issue.
There is an Enhancement request already raised with the development but fix is not yet available:

Enh 26834089 - PBCS: UNABLE TO IMPORT LARGE DATA FILES DUE TO DB RESOURCE CONSTRAINTS

Error "IndexError: index out of range: 1" while executing a batch process in FDMEE

Error "IndexError: index out of range: 1" while executing a batch process in FDMEE

Three major aspects of this issue are:
  1. Insufficient Batch timeout value defined in the System settings / Application settings in the FDMEE application
  2. Stuck thread timeout setting needs to be increased in the ErpIntegrator0 managed server (weblogic)
  3. Increase the Connection Pool - Maximum Capacity range for EPM in the weblogic console
1. To increase the batch timeout setting in the FDMEE application
  • Navigate to Data Management from EPM workspace
  • From the Setup tab, and then under Configure, select System Settings
  • In System Settings, from Profile Type, select Other
  • Define a timeout value for the “Batch timeout in minutes”
            Note : In this the maximum batch timeout value can be 30000
2. To increase the Stuck Thread timeout setting in the ErpIntegrator0 managed server in weblogic
  • Navigate to weblogic admin console
  • Under domain structure, expand Environment and choose servers
  • Choose ErpIntegrator0 from the servers list
  • Under configuration, choose tuning
  • Choose Lock & Edit to modify the setting value
  • Increase the Stuck Thread Max time value, set the value to 9600
  • Note : The value is in seconds. By default it will be 600 seconds
  • Choose activate configuration so that the settings take effect
  • Restart the FDMEE services.
3. To increase the Connection Pool - Maximum Capacity range for EPM in the weblogic console
  • Navigate to weblogic admin console
  • Under domain structure, expand Services and choose Data Sources
  • Click on the 'Connection Pool' tab
  • Click the 'Lock and Edit' button in the left pane
  • Increase the ‘Maximum Capacity’ value from 30 to 300
  • Click the 'Activate Changes' button in the left pane
  • Restart the FDMEE services

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