Unable To Access Financial Reporting (FR) Reports When Smart View Connects On Port 80 (Doc ID 1645159.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version 11.1.2.2.300 and later
Information in this document applies to any platform.
10.7.15

Symptoms

Your EPM system is configured with 80 as the OHS (Oracle HTTP Server) port instead of the default 19000.  You launch Microsoft Excel and connect via Smart View's Shared Connections to Reporting And Analysis.  The connection to the R&A server is established, but the '+' icon, which should appear to the left of the server name and allow you to drill down into its folders and reports, disappears and no content is shown.  No error appears.

A sample affected URL would be:

https://hfm.hfmserver.com/raframework/browse/listXML  (i.e., no port number is included in the URL, as 80 is being used)

If the same system is reconfigured to use port 19000 for OHS, the '+' icon will properly display the folders and reports in the Smart View panel.

If you connect to Reporting And Analysis using a Smart View Private Connection instead (e.g., http://hfmserver.com:45000/raframework/browse/listXML), the plus icon is present, but attempts to expand it and access the content result in an error: "Cannot connect to the provider. Make sure it is running in the specified host/port.Error (404)".

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms