≡ Menu

Patch 17529887 successfully applied or NOT

Fun with whether or not Patch 17529887 successfully applied

tested with file V44215-01
The README for Patch 17529887: (Release Patch Set Update (PSU): 17529887)  indicates you can apply to and that there are no prerequisites beyond the usual Visual C++ 2005 Redistributable Package.

This is not exactly the case, as various Windows OS prerequisites impact whether the patch is applied successfully.

As others have noted, the ADF patches often do not truly apply. I have applied the superpatch on nearly a dozen systems without having any issues so was surprised to finally see the ADF patch deployment failure today.

A new interesting quirk came up as well, when installing the patch with local accounts on a multi-node system. The Microsoft (R) Windows Script Host will fail to process vbscripts like:

D:\software\17529887\custom\scripts\create_version_history.vbs(32, 1) Microsoft VBScript runtime error: Path not found

The intrepid Windows administrators had not set up Windows with cohesive Region and Language settings.


Rollback the patch

D:\Oracle\Middleware\EPMSystem11R1\OPatch\opatch rollback -id 17529887 -oh D:\Oracle\Middleware\EPMSystem11R1 -jre D:\Oracle\Middleware\jrockit_160_37

Check that Region and Language settings match the System Locale. This was corrected by changing the Region and Language setting from “English (United Kingdom)” to “English (United States)“.

Reapply the patch.

Verify after restart that the expected versions are picked up and showing in Workspace > About.



external links

None at this time


Smart View hits .400

Release, Patch 20327649 is now available. Readme

Oracle Hyperion Smart View for Office Release PSU. Readme


Oracle Help Center and EPM

Oracle Enterprise Performance Management System Documentation

The documentation for Oracle EPM Release is widely available from Oracle Help Center.

You may be familiar with Oracle Help Center as the new documentation portal. The old documentation portal is OTN technetwork.

The majority of this content summarizes notes from an Oracle presentation of what is new and what is coming.


Some of the good news is:

  • commitment to existing applications
  • innovation with new offerings
  • more cloud
  • more mobile – “Managing the close on the run”

This translates as:

  • FDMEE – complete parity with legacy FDM
  • FDMEE – data synch between EPM applications
    • DRM integrations
    • Sub-ledger transactions for ARM
    • HFM journal write-back
    • Import from any relational with simple UI mapping
    • SAP BW metadata load
    • Integration with FCM
  • Supplemental Data Manager (new product)
  • FM (HFM) reborn with some platform independence, pre-built dashboards, application creation wizards (a.k.a. Web Profile Editor), and stellar performance claims, especially in consolidation times
  • FM User Interface gets some love as formats and layouts are more controllable
    • Disable modules for an entire application
    • Security role fixes for Task and Data Audit
    • Audit log on metadata difference after load, a.k.a., metadata merge utility
    • UDAs are 256 characters
    • Support for on-demand rules
    • DCOM replaced with TCP communications
    • Web control of system settings
    • Multi-file select for load actions
  • Platform independent (with limitations, notably to Exalytics–long live Big Iron!)
  • Ongoing commitment to deployment simplicity
  • FCM:  a well-supported product receives continued investment
    • Close Manager
    • Account Reconciliation Manager
    • Supplemental Data Manager
    • TAX
  • …more to be discovered

Extended Support

Extending support for EPM 11.1.2.x releases is the sleeper announcement that deserves applause! Oracle extended Premier Support to April 2018 and Extended Support to April 2021.
[click to continue…]


Do not patch EPM System servers with Essbase Client .104-106

tested PSU,~.105, ~.106
After installation of the Essbase Client via exe file p17608120_111220_MSWIN-x86-64.zip a number of source files will be over-written and corrupted. For example, epmsys_registry.bat, validate.bat, and ziplogs.bat will no longer work. The applications will still start from Windows Services.msc but will no longer communicate with each other nor with the Admin Server.


The general format I use in this publication is to provide steps to replicate the issue.

You should not replicate this issue.

If you insist on replicating the issue, install the client in a vanilla server, then back-track any mismatch between target files and the files installed by the Essbase Client using a nice diff utility. Here is one for Mac OS X.
[click to continue…]


PDF Preview fails in Workspace

Switching to PDF Preview in Workspace on a report generated by Financial Reporting fails with the message “Unable to process request.”

tested through PSU
Unable to process request occurs with some but not all FR reports.


For each FR server, update to TRACE:32 the logging levels in


for three loggers:

<logger name=’oracle.EPMFR’ level=’TRACE:32′ useParentHandlers=’false’>
<handler name=’epmfr-handler’/>
<logger name=’oracle.EPMFR.access’ level=’TRACE:32′ useParentHandlers=’false’>
<handler name=’epmfr.access-handler’/>
<logger name=’oracle.EPMFR.jsp’ level=’TRACE:32′ useParentHandlers=’false’>
<handler name=’epmfr-handler-jsp’/>

Restart the FR servers
Replicate the issue
Check these logs for details of the problem:

[click to continue…]


TB v TiB

There is something annoying about plugging in six 4 TB hard drives and having only 3.68 TiB available.

When is a terabyte (TB) not a terabyte? It has been going on for years, and everyone accepts it as the way it is, but 91% of what was promised seems like less…than. Let’s have a name for it.


The 91%-ers over-promise and under-deliver.

The 91%-ers get you almost to where they  said they would.

Imagine going to the moon with these people. 34,596 km away and they are popping the “one small step for man” speech.

Mastery is required to differentiate from the 91%-ers.

Sometimes it seems 91% of total effort is required to pull a project to 100% or better.



Dell PERC H700 does not recognize Seagate NAS HDD 4TB SATA 6GB NCQ 64 MB Cache Bare Drive ST4000VN000

tested through PERC H700 Adapter BIOS Configuration Utility 2.02-0025.1
Update 5/25/2014: If the drive cage is properly seated in the backplane both Seagate NAS HDD 4TB SATA 6GB NCQ 64 MB Cache Bare Drive ST4000VN000 and Western Digital WD40EFRX 4 TB WD Red, 3.5 inch, SATA III 5400 RPM 64 MB Cache Bulk/OEM NAS Hard Drive 4TB NAS drives are recognized.

The PERC H700 controller from Dell™ is in the third generation of Dell SAS RAID Cards and provides support for SAS, SATA and SSD (specifically SATA SSDs) drives.

The drives that might work are $900 each (Dell 4 TB 7200 RPM Near Line Serial Attached SCSI Hard Drive for Select Dell Poweredge Servers / PowerVault Storage) or $319 each from Amazon (Dell – 4TB 7.2K 6Gb/s 3.5″ SAS HD -Mfg # DTK38 (Comes with drive and tray))




None at this time

external links

None at this time


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