≡ Menu

RDC updated

Remote Desktop Connection (RDC) 8.1 client update … lets you use the new Remote Desktop Services features. These features were introduced in Windows 8.1 and Windows Server 2012 R2, and they are now available for computers that are running Windows 7 Service Pack 1 (SP1).


HFM Taskflows inaccessible to regular users

Access to HFM Taskflows is restricted to users provisioned for Consolidation Administration

tested through PSU

The README for Patch 17740222: Patch Set Update: for Oracle Hyperion Financial Management indicates Defect fixed in this patch (“17328388: The Consolidation Administration menu is not available for users with the Run Taskflows role.”) Testing to follow…

Oracle Enterprise Performance Management Documentation for indicates on page 232

Run Taskflows – Permits users to only run and view taskflows. Users with this role cannot create new taskflows or edit existing taskflows

As implemented, the placement of the Taskflows interface within Consolidation Administration effectively blocks all but HFM administrators from viewing or managing Taskflows. Until the application design catches up with the documentation one would need to provide access to Taskflows via EPMA rather than HFM.


If you would like assistance with Taskflows in HFM please let me know as I can help you with your HFM-Planning automation processes.


None at this time

external links

None at this time


replication help message

net helpmsg 4006


HFM 306 PSU now available

Release Patch Set Update (PSU): Readme

Nice job Oracle!


FoundationServices Workspace could not resolve role

The EPM Foundation Services in Workspace could not resolve role


Examination of LCM export of all provisioning as well as Users, Groups and Roles indicates this role is not in Shared Services.

Oracle Support indicates:

There is no problem with the user provisioning. Everything is working correctly. In a future release we will address this so that no error message is logged.
This bug won’t not cause any functional problems.


Error messages that repetitively appear in FoundationServices0, the Workspace.log, like:
[2013-08-16T20:51:47.921-04:00] [FoundationServices0] [ERROR] [01301] [oracle.bi.bifndnepm.workspace.security.RoleChecker] [tid: 14] [userId: ] [ecid: 123414233212341234123412340000e,0] [SRC_CLASS: com.oracle.workspace.security.RoleChecker] [APP: WORKSPACE#] [SRC_METHOD: initializeRoleCache:187] Could not resolve role: native://DN=cn=HUB:23,ou=HUB,ou=Roles,dc=css,dc=hyperion,dc=com?ROLE


Taskflows Add Link fails with 404 not found


When creating a Taskflow in Consolidation Administration, “Add Link” fails, and may open a 404 page not found. The Taskflow will not become visible in Workspace > Consolidation Administration. You will be unable to create Taskflows. You will likely be unable LCM Export or LCM Import Taskflows.


The source of the issue is a missing library; The solution is to add commons-dbcp-1.2.2.jar (‘D:\Oracle\Middleware\EPMSystem11R1\common\JakartaCommons\commons-dbcp-1.2.2.jar;’) to the end of
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\FoundationServices0\HyS9FoundationServices key in Windows Registry that starts with -Djava.class.path=
Restart the HSS Server after adding the reference to the class path.

[click to continue…]


Taskflows scheduler fails in with SOA


In verified on multiple client environments the scheduler in Taskflows does not work in an EPM installation that includes SOA. There are additional bugs to work through which will get written up as time permits. Furthermore, once the problem is identified using SQL Server trace files a solution creates downstream issues that are interesting to diagnose and resolve.


The source of the issue is a conflict in the version of quartz used by HFM and FCM. An EPM system that includes SOA will create [D:\Oracle\Middleware\Oracle_SOA1\soa\modules\quartz-all-1.6.5.jar] in the Windows Registry FoundationServices classpath during installation.
Manually changing the value in -Djava.class.path [D:\Oracle\Middleware\Oracle_SOA1\soa\modules\quartz-all-1.6.5.jar] replacing it with [D:\Oracle\Middleware\EPMSystem11R1\common\SharedServices\\lib\quartz.jar] Windows Registry for Foundation Services will cause deployed automated integrations to fail.
using script or starting from command line made no difference

After restart all SysInt*composites in SOA went to a conflicted state, started throwing null pointer exceptions and could not be undeployed, redeployed or retired. Cound not import any of the Integration Types that are automated via Workspace. These issues are related.
work through undeploy in Enterprise Manager, ignoring errors, for all SysInt* composites
Restart the EPMSystem (using the usual script)
Not all SysInt*composites had been removed, however, import HFM integration types succeeded. Null pointer errors in logs stopped.

The integration of so many EPM System products + SOA creates interesting challenges. This one is listed as an unpublished bug on Oracle Support.


The specified DSN contains an architecture mismatch


Code............................................. -2147467259
Description...................................... [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
At line: 90
Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
Component........................................ upsWObjectsDM
Version.......................................... 1112
Thread........................................... 78068


In Windows, for FDM, use the correct architecture to create a 32-bit DSN


Prerequisite: Fully functional 64-bit Windows server (e.g., Windows Server 2008 R2).
Create a 32-bit DSN by launching a 32-bit version of the Data Source Administrator.


Either of SQL Native Client or 32-bit POracle database ODBC drivers are required


[click to continue…]


Next Generation Essbase Outline Extractor Released!

Tim Tow’s Outline Extractor Released

On Saturday, July 13, 2013, an outline extractor which only works with 11.1.2.x and higher and provides XML output was released. For those of us who used the old Visual Basic extractor provided by Olap Underground and maintained by Tim Tow’s organization, this is good news.

Developing Essbase Applications

Joe Aultman presents the importance of being automated in chapter 9 “System Automation The Groovy Way” which jump-starts automation techniques for finance and IT professionals with an example of building an outline extractor in 7 steps.

As Tim noted, “You still have to do something with the XML format for it to be useful.”

via Tim Tows Hyperion Blog: Next Generation Essbase Outline Extractor Released!.


Oracle Support provides responsive documentation

Documentation Feedback

Send feedback on Oracle EPM product documentation to the email address and follow EPM Information Development on these social media sites: