In Smartview HsGetTexT Function Returns NULL Instead of #MISSING Value
Last updated on MARCH 14, 2018
Applies to:Hyperion Financial Management - Version: 126.96.36.199.00 to 188.8.131.52.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
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