Fusion Applications Financials Smart View reporting : Using a Function In Smart View Returns the cell value : "No Connection"

(Doc ID 2004813.1)

Last updated on MAY 29, 2015

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Fusion general ledger reporting - Hyperion Smartview shows unexpected result for a cell with a function

Unexpected behavior
-----------------------------
the last two columns which are titled 2013 and 2014 contain the string: "#No Connection" in every cell


Steps
---------------
Use SmartView to create a report

the excel spreadsheet shows shows 5 columns with 3 rows of data

certain columns contain dimension descriptions such as "[All ENTITY Values].[GGM]""

the last two columns which are titled 2013 and 2014 contain the string: "#No Connection" in every cell

when I click on a cell in this column , example function;

"='C:\Oracle\SmartView\Bin\HsTbar.xla'!HsGetValue("db","AccountingPeriod#"&$E$2&";Ledger#CONSOLIDATION_LEDGERSET;ENTITY#"&B3&";ACCOUNT#"&$C$3&";SUBACCOUNT#SUBACCOUNT;ORGANISATION#ORGANISATION;PARTNER#PARTNER;FLOW#FLOW;CUSTOMER#CUSTOMER;OFFER#OFFER;PROJECT#PROJECT;SITE#SITE;Scenario#Actual;"&"Balance Amount#Period Activity;Amount Type#Base;Currency#"&D3&";Currency Type#Total")"

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