How do you test and validate EPM Cloud application performance before going to production?

Below is some general information about Performance Validation in EPM Cloud. (Note: this applies to PBCS, EPBCS, FCCS, and TRCS.)

Check out the documentation links and a presentation provided by Bill Fox, Consulting Product Manager for Oracle EPM Cloud, on this topic.

Performance Validation - EPM Automate Replay Command

• Generate Simulated Workload
  • EPM Automate “Replay” command
• Identify Application Performance Optimization Candidates
  • Review Activity Report

• EPM Automate Replay command - Documentation
• Sample Replay Session - Documentation
• Cloud Documentation
• Presentation - provided by Bill Fox, Consulting Product Manager

How do auditing and monitoring work in EPM cloud?

Below is some general information about Auditing, Monitoring and Logs with EPM cloud. Check out the documentation links and a presentation provided by Bill Fox, Consulting Product Manager for Oracle EPM Cloud, on this topic.

Activity Reports (all EPM Cloud except EPRCS)

• Generated every day
• Understand application usage - 5, 10, 30, 60 day windows
• Helps streamline application design
• Identifies calc scripts and user requests that impact performance
• Activity Reports provide the following:
  • Number of users who signed into the application each day
  • Percentage of requests that took more than 10 seconds to complete
  • Top seven requests that took the most time to complete
  • Top 30 worst performing actions that took over 10 seconds to complete
  • Number of users per hour
  • Number of users based on how long they were signed into the application
  • Top 10 users based on how long they were signed into the application
  • Application design changes that occurred over the reporting period
  • Smart View release

Access Logs

• Comma Separated Value (CSV)
• Generated daily
• Includes:
  • date and time
  • the resources that users accessed
  • duration of user activity
  • IP addresses from which users connected
  • the actions that users performed

System Audit

• Enterprise Performance Reporting Cloud
• Combines access logs and activities
• Downloadable CSV

• Viewing and Downloading Activity Reports and Access Logs - Documentation
• Administering Oracle Enterprise Performance Reporting Cloud - Creating a System Audit - Documentation
• Cloud Documentation
• Presentation - provided by Bill Fox, Consulting Product Manager

How can you automate the routine tasks of EPM Cloud?

Below is some general information about Automation and Scripting with EPM cloud. Check out the documentation links and a presentation provided by Bill Fox, Consulting Product Manager for Oracle EPM Cloud, on this topic.

File Transfer Utility

• Enterprise Performance Reporting Cloud
• Used for moving large files into and out of the system
  • Backup / Restore
  • Migrating artifacts
  • Performing data load and data extract
  • Uploading / downloading files
• Command-line utility, so jobs can be scripted / batched
  • Kicked off with Windows Scheduler

EPM Automate and REST API

• Planning and Budgeting, Enterprise Planning and Budgeting, Account Reconciliation, Financial Consolidation and Close, ax Reporting, Profitability and Cost Management
• Upload files into service instance (Upload file into the Planning inbox/outbox)
• Upload file into Data Management folders and import with a data load rule
• Manage backup files
• Download files from the inbox/outbox and from Data Management folders
• Export and import application and artifact snapshots using Application Management
• List the files and Delete files in the inbox/outbox
• Reset Service
• Provide Feedback
• Create User Provision and Audit reports

Perform maintenance tasks remotely

Create scripts that are capable of completing a wide array of tasks

• create local backups of artifacts and data
• restore the service to a known prior state

• Working with EPM Automate for Oracle Enterprise Performance Management Cloud - Documentation
• REST API for Oracle Enterprise Performance Management Cloud - Documentation
• Video overview of the EPM Automate utility
• EPRCS File Transfer Utility - Documentation
• Cloud Documentation
• Presentation - provided by Bill Fox, Consulting Product Manager

Do you have general questions about these topics in EPM Cloud?

Below is some general information related to Service Continuity, Disaster Recovery and Backup; along with documentation links and a presentation provided by Bill Fox, Consulting Product Manager for Oracle EPM Cloud, on this topic.

Disaster Recovery

• Provided for EPM Cloud
• Oracle works to meet the target service availability level, or target uptime, of 99.5%.
• Oracle will work to recover the service promptly, although the nature of the disaster may affect the time period at which the service can be recovered.

EPM Cloud Self-Serve Application Replication

• EPM Automate Commands
  • All EPM Cloud Services except EPRCS
  • exportsnapshot and downloadfile to download backup snapshots
  • uploadfile and importsnapshot to upload the backup snapshot into the Service and restore artifacts
• File Transfer Utility (eprcsctl)
  • Enterprise Performance Reporting
  • download_dbsnapshot to download backup snapshots
  • upload_dbsnapshot: upload the backup snapshot into the Service
  • Run Daily Maintenance

REFERENCES:

• Replicating an EPM Cloud instance
• Automating the cloning of instances
• Cloud Documentation
• Oracle Knowledgebase Article:
  • EPM Cloud Services Disaster Recovery (DR) and Backup Clarification (Doc ID 2165323.1)
• Presentation - provided by Bill Fox, Consulting Product Manager

Do you have general questions about User Management in EPM Cloud?

Below is some general information related to User Management; along with documentation links and a presentation provided by Bill Fox, Consulting Product Manager for Oracle EPM Cloud, on this topic.

Default Cloud Identity Management Configuration

EPM Cloud is provisioned with Oracle Cloud Identity Management.

Oracle Cloud Identity Management:

• Form-based User ID and password-based authentication
• SSO with other EPM Cloud Services in the same Identity Domain
• Passwords expire every 120 days
• Lockout after X (undocumented) unsuccessful attempts
• Passwords must:
  • be at least 8 character(s) long
  • contain at least 1 lowercase letter(s)
  • contain at least 1 numeric character(s)
  • contain at least 1 uppercase letter(s)

Federated Identity Management

• You can configure SSO with your SAML* 2.0 Identity Provider (IdP).
• Managing single sign-on - Documentation

Additional Access Controls

• Network Restricted Access
  • Whitelist: Access denied except to the configured IP addresses
  • Blacklist: Access granted except to the configured IP addresses
• Managing Internet Protocol Whitelist and Blacklist rules - Documentation

REFERENCES:

• Managing Users and Roles - Documentation
• Managing single sign-on - Documentation
• Managing Internet Protocol Whitelist and Blacklist rules - Documentation
• Presentation - provided by Bill Fox, Consulting Product Manager