Dayalan Punniyamoorthy Blog

Sunday, April 16, 2017

What does EPM Automate Utility offer - Part 2

Continuing with the EPM automate commands as part 2 after Part 1


The Replay Command

The replay command replays the Oracle Smart View for Office load on a service instance to enable performance testing under heavy load to verify that user experience is acceptable when the service is under specified load.


For example, you can test the user experience on a test instance under heavy load to ensure that the service will perform well after you migrate the application from the test instance to the production instance.



  • Identify forms that require major processing on the service instance. Forms that deal with large amounts of data, or forms that include complex calculations are good candidates. For example, forms that are used to submit forecast, processes involved in creating ad-hoc and static reports may exert heavy loads on the service.

I will be focusing on the 5 data forms present on my OPBCS Test instance






  • Install Fiddler if necessary. EPM Automate Utility requires an HTTP Archive format (HAR) 1.1 file that contains the log of your web browser's interaction with Oracle Smart View for Office. You use Fiddler to create this file. 


  • Run the major activities that you identified previously on a number of forms. You use Smart View to run the activities and Fiddler to capture activity details and to export them to HAR files. See Creating HAR Files for details.
Creating HAR Files

The HAR file captures traces of Oracle Smart View for Office processes that are run against the service instance. Because Fiddler captures information on all HTTP(S) traffic, while creating the HAR files, refrain from activities that may add unnecessary trace to Fiddler.


Enable the “Decrypt HTTPS traffic” if it is not selected.



Start Smart View and access the service instance for which you want to capture trace.

In Smart View, open the forms or run the activities that exert heavy processing load on the service instance.

Fiddler records the Smart View processes that you initiated.


Select File, then Export Sessions, and then either All Sessions or Selected Sessions. If you were connected to other web sites while running Fiddler, select Selected Sessions to choose the sessions relevant to the service instance.


In Select Export Format, select HTTPArchive v1.1 as the export format.






Creating Replay Files

A replay file is a CSV file that lists the credentials (user name and password) and the name of the HAR files that are to be run to load the system using the replay EPM Automate Utility command. Ensure that the user name and password that you specify has the rights to run the activities included in the HAR file.




On executing the replay command, the EPM Automate Utility runs each row in the replay file in parallel to exert load on the service. For example, if your replay file contains 10 rows, the utility replays 10 sessions so that you can perform tests to verify that user experience is acceptable when the service is under specified load. Each activity included in the HAR file is run serially.

The user whose credentials are specified in a row to run a HAR file need not be the user who ran the Smart View session that was used to create the HAR file. However, this user should have the rights to run these activities on the service instance.
When you execute the command using a replay file, the EPM Automate Utility runs each row in the replay file in parallel to exert load on the service so that you can perform tests to verify that user experience is acceptable when the service is under load.



epmautomate replay " C:\Users\DPunniamoorthy\Desktop\Blogs\EPM-Auto\part2\Replay.csv" duration=1 trace=true


The utility displays replay information in the console and ends processing after the specified duration (1 minutes in the preceding example). It also creates trace folders and files because the preceding command includes the trace=true parameter. The following illustration depicts the information displayed for a sample session:



Will cover the rest of the commands in the next serious.

2 comments:

  1. I found a more detailed blog on this command
    http://john-goodwin.blogspot.com/2016/08/load-testing-with-epm-automate-replay.html
    http://john-goodwin.blogspot.com/2016/08/load-testing-with-epm-automate-replay_14.html

    ReplyDelete