Tuesday, November 28, 2017

Friday, November 24, 2017

Hyperion Smartview Journals Extension in 11.1.2.4

Good day,
Recently we upgraded our HFM apps to 11.1.2.4 and discovered new Smartview + Journals Extension.  With this, you can Manage your HFM Journals within Smartview.

Goto your Smartview, Options, Extension and then click on "Check for Updates, New Installs, and Uninstalls".  This will download the New Extension for you in your Local drive.  The file will have an extension of SVEXT or EXE. 

Below are the steps to enable the Journals Extension.

Installing from the Smart View Installation Folder
Before you install the Oracle Journals extension, you must install Oracle Smart View for Office.
You do not have to close Office (Excel, Word, or PowerPoint) to install the Oracle Journals extension using this method.
To install the Oracle Journals for Financial Management directly from your Smart View installation:
  1. Navigate to the folder where you installed Smart View and open the extensions folder.
  2. For example, navigate to:
C:\Oracle\SmartView\extensions
  1. Double-click SVFMJournalInstaller.svext.
  2. If an Office product is running, follow the prompts to restart Office; for example, if Excel is open, restart Excel.

If no Office products were open, then start Excel.

Thursday, November 16, 2017

Hyperion Financial Reporting Studio client update for 11.1.2.4.707 patch

Hyperion Financial Reporting 11.1.2.4.707 patch and FR Studio support update

Oracle is committed to providing a simple and intuitive experience to Financial Reporting users of the service. To achieve this goal, Financial Reporting Web Studio, a component available since the 11.1.2.4.701 release, will be established as the only tool for designing and building reports. As a result, Financial Reporting Studio desktop client support will be fully transitioned to Financial Reporting Web Studio, tentatively in mid-2017. With a planned mid-2017 update, Financial Reporting Studio desktop client is planned to no longer be distributed.
Starting with the 11.1.2.4.704 release, Financial Reporting Web Studio will achieve functional parity with most of the capabilities provided with Financial Reporting Studio desktop client. You will be able to create new reports and modify existing reports using Financial Reporting Web Studio.
Oracle recommends that you transition to using Financial Reporting Web Studio at the earliest opportunity.

Monday, November 13, 2017

HFM 11.1.2.4 and Timeout settings

Recently we had issues where users were getting Timeout message in HFM 11.1.2.4

Came across this article and thought would share in my blog.....

On OHS Server, add the following attributes to the mod_wl_ohs.config file. The WLIOTimeoutSecs setting to 6000 will allow a server process to run for 100 minutes without a timeout error in the browser. The complete description of these settings can be found here: http://docs.oracle.com/cd/E14571_01/web.1111/e16435/plugin_params.htm

Steps:
  1. On the EPM Foundation Web server go to folder
    \Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component 
  2. Take a back up of mod_wl_ohs.conf
  3. Open mod_wl_ohs.conf. Locate the below section in the file:
    <LocationMatch ^/hfmadf>
       SetHandler weblogic-handler
       WeblogicCluster <cluster>:<port>
    </LocationMatch>
    By default there are no timeout settings defined here.
  4. Add the below 3 lines inside LocationMatch tag:
    WLIOTimeoutSecs 6000
    Idempotent OFF
    WLSocketTimeoutSecs 750
  5. After adding the above lines the section will look like this:
    <LocationMatch ^/hfmadf>
        SetHandler weblogic-handler
        WeblogicCluster <cluster>:<port>
        WLIOTimeoutSecs 6000
        Idempotent OFF
        WLSocketTimeoutSecs 750
    </LocationMatch> 
  6. Save the changes
  7. Restart the OHS service (OracleProcessManager_ohsInstance)
  8. The above settings will allow the users to perform any HFM tasks that takes more that 5 minutes without any timeout errors.