In Smartview HsGetTexT Function Returns NULL Instead of #MISSING Value
(Doc ID 1066902.1)
Last updated on MARCH 14, 2018
Applies to:Hyperion Financial Management - Version: 18.104.22.168.00 to 22.214.171.124.00 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Example with the sample application Statutory on Oracle Database.
1. In FM, Create the Statutory sample application.
2. In SmartView, create a connection which connects to Statutory then name it "Stat".
3. In Excel, connect to "Stat" and insert the HsGetText into Cell A1 as follows:
=HsGetText("Stat","Scenario#Actual;Year#2001;Period#January;View#<Scenario View>;Entity#[None];Value#<Entity Currency>;Account#[None];ICP#[ICP None];Custom1#[None];Custom2#[None];Custom3#[None];Custom4#[None]")
4. After executing Refresh, the function returns "NULL" instead of such keywords as "#Missing". Besides this, an error entry that includes "ORA-00942: table or view does not exist" is inserted into Windows Application Event Log by Financial Management
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document