tested through PSU 11.1.2.2.305
3/4/2014

The README for Patch 17740222: Patch Set Update: 11.1.2.2.306 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 11.1.2.2 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.

steps

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

description

None at this time

external links

None at this time

When creating a Taskflow in 11.1.2.2 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.

steps

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.

Error messages will appear in the logs in several places:
D:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\logs\SharedServices_TaskFlow.log
[2013-06-29T20:05:23.807-04:00] [FoundationServices0] [ERROR] [EPMCES-61014] [oracle.EPMCES.CES] [tid: 12] [userId: user] [ecid: asdfasfdasdfasdfasfdasfd,0] [SRC_CLASS: com.hyperion.ces.ui.SaveTaskFlow] [APP: SHAREDSERVICES#11.1.2.0] [SRC_METHOD: execute] Inside SaveTaskFlow execute method null

FoundationServices0.log has the useful one:
#### <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1213412341324> ]]> http://epm.jonhwilliams.com/taskflows-add-link-fails-404-not-found/feed/ 0 http://epm.jonhwilliams.com/taskflows-scheduler-fails-hfm-soa/ http://epm.jonhwilliams.com/taskflows-scheduler-fails-hfm-soa/#respond Mon, 14 Oct 2013 05:55:36 +0000 http://epm.jonhwilliams.com/?p=226 symptoms

In 11.1.2.2.305 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.

steps

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\11.1.2.0\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.

steps

Prerequisite: Fully functional Financial Consolidation application to which to connect.
Select Tools > Clear Error Log
Logoff
Logon
Begin by selecting Metadata > Control Tables
Click Ok on any messages
Click in a cell under Target Year; If values are returned, the connection to an HFM application is active.
Otherwise select Tools > View Error Log
Use the output to identify the issue.
The number of active custom dimensions in the FDM Adapter must match the number of custom dimensions in the HFM application
Connect to Oracle Hyperion FDM Workbench
Expand the Dimensions of the Target System Adapter
Right-Click Custom1 and check Active
Repeat for Custom2, Custom3, Custom4
Set the System Code and Save

description

For a Release 11.1.2.2 Financial Data Quality Management application, an error may occur like Unable to retrieve target System Data. The error log often facilitates identification of the connectivity issue. For example, “ActiveX component can’t create object: ‘fdmFM11xG5B.clsFMAdapter'” might indicate the System Code should be changed from FM11x-G5-B to FM11x-G6-A for HFM connectivity.
An error like Adapter function [fConnect] failed might indicate the number of dimensions Active in the adapter does not match the number of custom dimensions in the HFM application.
The OTN Community for FDM is well established and supportive of properly crafted requests:

external links

Additional thanks for the post: by Nicholas King.