EPM SYSTEMESSBASEFDMEEHFMPLANNING

Oracle EPM last patches

Oracle EPM last patches

Oracle regularly provides patches to fix bugs or add features.

This articles will list the latest EPM patches for each component as well as the prerequisite patches.

We will update this article for each new patch.

  • Shared Services (HSS)

Patch number
PSU 008 (28314691)
Defect
27920587, 27920609, 27920624, 27920627 Fixes to enhance Financial Reporting security.
Prerequisite patch
PSU 002 (21473221)
PSU 003 (22535737)
PSU 004 (23125779)
PSU 005 (24738130)
PSU 006 (26496794)
PSU 007 (26751072)
  • Report & Analysis Framework (RAF)

Patch number
PSU 006 (25753058)
Defect
25254015 Problem with special characters.
Prerequisite patch
None
  • Financial Reporting (FR)

Patch number
PSU 710 (28508169)
Defect
21756093 Remove User Name And Password Arguments From The Batch Command Line Scheduler.
25126783 FR Web Studio – Grid Row Column Is Not Shown While Editing A Report.
25585569 Random Blank Pages Are Appearing In FR PDF.
26180465 FR Web Studio –After Any Change To Format Of Cell The Grid Will Refresh And Jump To Start Of The Grid.
26843414 Expanding Grid Causes Grid Content To Appear Empty.
27185044 FR Web Studio – Prompting “Do You Want To Save The Changes You Made?” In Reports When No Changes Are Made.
27290325 Using Member Selection On A Report With A Prompt Choice Containing ‘And Not’ Receives Errors.
27356893 FR Web Studio Has A Pop Up Message, “OK”, When Clicked After Being Idle For 20-30 Minutes.
27447600 Add A New Format Option Called “Justify” For Text Values in FR Web Studio Report.
27502876 Select Members In FR Web Studio Is Not Working.
27504974 FR Header – Text Object Loses Its Position When Exported To Word.
27543660 The User POV Opens To The Second Page Of Member Selection And Only Shows That Page.
27547722 Receiving Errors In The User POV When Custom1 Dimension Uses [NONE].
27580097 FR Batch Scheduler Exporting To An External Drive Is Not Posting The PDF To The Specified Path.
27580360 Email Notification Only Contains Single PDF File.
27585341 FR Web Studio – Clicking On The Grid Properties Buttons Resets Member Labels For Rows And Columns.
27622068 Financial Reporting Web Studio Exit Button Is Not Easily Available.
27732182 Financial Reporting Cannot Execute A Report, Receives An Essbase Syntax Error.
27848149 In Reporting Schedule Batch Sav
Prerequisite patch
Package redistribuable Microsoft Visual C++ 2005 (x86)
Package redistribuable Microsoft Visual C++ 2005 (x64)
  • Financial Management (HFM)

Patch number
PSU 208 (28511735)
Defect
28950275 In 11.1.2.4.208, the hierarchy indentation is different for [Base] memberlist in Smart View
28680173 Smart View HSGetText displaying NULL on spreadsheets with high number of HSGetText functions
28665974 Close a time window where it is possible to get at the parent entity with OK status while having child entity with CN or CH status
28625254 Clear data not working if more than half of accounts are selected
28494900 Delete data audit based on the current filter settings does not work correctly
28430521 Entity details are not displaying correctly in data form
28399138 Drill through is not visible after a successful data load
28373491 Allow choice on deleting inactive entities or not when running clear data
28363260 Multiple entities cannot be selected in “process management actions” of task flow
28359207 Import application does not copy data tables when filters are used
28285104 Error when calling req_EnumChildren with a member without children in Smart View
28267183 [Ancestors] view not available in process control 11.1.2.4.207
28200907 Scheduled start time incorrect in running task
28150657 Currency grid with invalid cells after application upgrade
28041386 Load security incorrectly enabled for admin users in EPMA applications
28021381 On demand rule execution were incorrectly allowed when user does not have write access
27972605 UI and extracted profile show additional characters for dimension alias
27918116 IC reports document type is missing in load document when ICT module is disabled
27866478 Dataform cell with override string doesn’t display in Smart View
27858534 Member description with ‘ changes to ” in data extract to database for Essbase and Data warehouse format
27853669 Add logging messages to show the correct number of database connections used by HFM on multi server environment
27845641 ADFC-10001: cannot instantiate class error when editing / running journal report upgraded from old HFM version
27707454 Task audit not showing after 100 records
26906463 Process management security is not enforced when running IC matching report
26594015 Task audit records are not properly displayed for “Include All” option
26422285 In Smart View, unable to zoom in all level due to incorrect indents in hierarchy when entities have multiple parents
25772172 Scaling and decimal values are wrong when entering the values in Smart View ad-hoc grid the first time
24412735 HSGetValue function is not giving informative metadata error
Prerequisite patch
Oracle Application Development Framework patch 25113405
FMW patch 13866584
FMW patch 16810628
  • Calculation Manager (CM)

Patch number
PSU 013 (27780138)
Defect
26242858 Validation of Financial Management rules may be slower than the previous version
26281384 Using a rule with a RTP dimension type variable, when the name of the dimension is different than the type, the variable prompt may show: “No dimensions are available from which to select member(s).”
27754365 In a rule set containing rules with RTP variables, the rule set may not save the default values entered for these RTP variables.
27789898 When using RUNJAVA com.hyperion.calcmgr.common.cdf.MDXDataCopy in a rule, the log file may be appended each time the rule is launched.
Prerequisite patch
Planning PSU 002 (20937926)
  • Planning (HP)

Patch number
PSU 008 (28103100)
PSE 28549776
Defect
PSU
27469130, 27251187, 27251107, 26975661, 26030958, 26022451, 25311192, 25160981, 24790191, 20161532, 25163511, 24334951 If a recurring taskflow is scheduled, the execution of taskflow may not be guaranteed.

Note: 1. Please note the fix for this issue will disable Planning job scheduler. So, if you have not scheduled any jobs in Planning by accessing Planning in simplified user interface, this change should be fine. A comprehensive implementation for this behaviour is planned for future.

2. Administrators need to define the below Planning System Property by navigating to Administration->Application->Properties->System Properties in Planning web and set the value to true.

DISABLE_PLANNING_JOB_SCHEDULER

26832758, 26612670, 25924905, 24930638, 23747067, 26736644, 23105473 The email notification sent as part of workflow process may have a blank status check URL.
25559167, 24662637, 23534435 Running a Financial Report from Planning Simplified Interface may fail with 404 error.
24623582, 27475726, 27136966 Opening Planning data form in Planning Simplified interface may not display alias for all the members in the data form
27497589 Launching a business rule from SmartView in ad-hoc mode may fail with an error when alias table for display is changed.
27221415, 21660925 If email notification is enabled for jobs, users may get an email for every RTP in a business rule after the business rule execution is complete.
26564294 If a Financial Report is defined to display supporting details, running the report may not display the supporting details correctly.
25884666 When a user is removed from Planning application, all the cell comments and cell attachments entered by the user are removed from Planning application when a bulk security refresh is run.
24609172 Composite forms may not be displayed correctly after collapsing and expanding of sub-forms.
PSE
27669618 Running database refresh from Planning may run into errors if Essbase server or Essbase RTC is upgraded to 11.1.2.4.025 Patch SetUpdate (PSU).
Prerequisite patch
PSU
FDMEE PSU 200 (22452414)
Essbase Server PSU 018 (26007120)
Essbase RTC PSU 018 (26007112)
Calculation Manager PSU 006 (22806363)
Financial Reporting PSU 006 (22462544)
Smart View 11.1.2.5.520
ADF MLR Patch 25113405
Weblogic Server PSU 171017
PSE
Planning PSU 002 (28103100)
Essbase Server PSU 025 (27797131)
Essbase RTC PSU 025 (27797123)
  • Essbase Server

Patch number
PSU 028 (28626597)
Defect
28652520 A Custom Calculation that produced results in Patchset Update 11.1.2.4.022 no longer produces results in Patchset Update 11.1.2.4.025.
28579092 In some cases, export files are produced without header records when FIXPARALLEL/ENDFIXPARALLEL is used.
28435788 Trying to open an Oracle Essbase outline in Oracle Essbase Administration Services can cause the Administration Services console to become unresponsive.
28205614 In some cases, an MDX query with TIMEBALANCE option of FIRST and LAST is not returning expected results.
27919059 In some cases, when a user adds new members and changes the hierarchy of a cube results in an error and doesn’t save:

Error(1013132): Cannot build dimensions. There are other active users on database [db]

26551449 In some cases, when exporting an outline using MAXL that would result in a file that exceeds 2 GB can result in an XML file that is not properly formatted.
27964757 An Allocation is not producing values as is expected in some cases.
28144580, 28200467 An Allocation against a partition can result in an error when there are looping multiple dimensions.
24375619 When running a Trial Balance report with a drill down can result in an error:

Error: Query is allocating too large memory (> 4GB)

28737257, 26712051, 28761943 SQL dataload performance degraded from Patchset 11.1.2.3 to 11.1.2.4.
28719603 In some cases, when running a Custom Calculation and Allocation script generates incorrect cells updated and data generated.
28515810 In some cases, trying to pivot a dimension on the Smart View Client can result in an error

Essbase Error (10020056): Your pivot option cannot be performed on this report.

Prerequisite patch
None
  • Essbase RTC

Patch number
PSU 028 (28626616)
Defect
28652520 A Custom Calculation that produced results in Patchset Update 11.1.2.4.022 no longer produces results in Patchset Update 11.1.2.4.025.
28579092 In some cases, export files are produced without header records when FIXPARALLEL/ENDFIXPARALLEL is used.
28435788 Trying to open an Oracle Essbase outline in Oracle Essbase Administration Services can cause the Administration Services console to become unresponsive.
28205614 In some cases, an MDX query with TIMEBALANCE option of FIRST and LAST is not returning expected results.
27919059 In some cases, when a user adds new members and changes the hierarchy of a cube results in an error and doesn’t save:

Error(1013132): Cannot build dimensions. There are other active users on database [db]

26551449 In some cases, when exporting an outline using MAXL that would result in a file that exceeds 2 GB can result in an XML file that is not properly formatted.
27964757 An Allocation is not producing values as is expected in some cases.
28144580, 28200467 An Allocation against a partition can result in an error when there are looping multiple dimensions.
24375619 When running a Trial Balance report with a drill down can result in an error:

Error: Query is allocating too large memory (> 4GB)

28737257, 26712051, 28761943 SQL dataload performance degraded from Patchset 11.1.2.3 to 11.1.2.4.
28719603 In some cases, when running a Custom Calculation and Allocation script generates incorrect cells updated and data generated.
28515810 In some cases, trying to pivot a dimension on the Smart View Client can result in an error

Essbase Error (10020056): Your pivot option cannot be performed on this report.

Prerequisite patch
None
  • Analytics Provider Services (APS)

Patch number
PSU 028 (28626591)
Defect
None None
Prerequisite patch
None
  • Essbase Administration Services (EAS)

Patch number
PSU 025 (28285151)
Defect
N/A N/A
Prerequisite patch
Package redistribuable Microsoft Visual C++ 2005 (x86)
Package redistribuable Microsoft Visual C++ 2005 (x64)
  • Essbase Studio

Patch number
PSU 027 (28625084)
Defect
27992462 Oracle Essbase Studio is not able to connect to Teradata using 16.x JDBC Drivers. The following error message is returned:

Unable to establish a connection. Ensure that the server is running, the username and password are correct, and the other data fields match the server’s configuration.

Prerequisite patch
None
  • Financial Data Management Enterprise Edition (FDMEE)

Patch number
PSU 220 (27357256)
PSE 27357256
Defect
PSU
27057886 An incorrect parameter is set in the schedules for System Maintenance Tasks.
27048279 Essbase sessions are not closing during the data export.
26934122 Support archiving for the TDATAMAPSEG table and retain the view map.
26791692 The data load fails because import mapping does not skip Byte Order Mark (BOM) characters.
26674309 Check Rule Group and Check Entity Group are enabled erroneously for a hybrid application.
26591196 The 11.1.2.4 210 patch does not include the required Account Reconciliation Manager (ARM) scenario: ARM_PREMAPPED_BALANCES.
26559544 Attribute, description, and currency rows disappear from import format mappings.
26496624 FDMEE is inaccessible to users during a large data load.
26403186 The data load process shows a failed status when the Hyperion Financial Management data load option is set to “No.” (The load status should not appear in process details because it was not enabled.)
26395917 The batch scheduler does not work when the process is scheduled at a later time.
26322934 Script registration fails due to the length of the query definition name.
26234429 When running a data load rule to load to Hyperion Financial Management and the consolidation process fails, the Status of the Consolidation Process step still runs even though the data load rule status is updated to a failed status.
26202259 Account dimension member names that use a comma cause the Check Report to fail.
26165643 User can click the execute option on the Custom Script page when the Execute button is disabled.
26146537 Unable to refresh the metadata option in FDMEE when the target is Essbase.
26117447 Duplicate query definitions occur in FDMEE.
26117429 When loading multi-period data, all entities are not included in the calc parameter
26081218 Error occurs when exporting data from Planning to PeopleSoft KK (Commitment Control).
25980368 Can’t launch popup after selecting the Setup tab, then Target Application (Planning target application), and then Calculation script.
25977081 When setting up Batch Security, the second role permission must be assigned before the Setup tab is displayed.
25933495 When customer executes LOADDATA.BAT scripts, they fail with the following error message: “Failed. Some Error Occurred.”
25905459 Generic fields show up as validation errors.
25876263 Source period mappings do not show for EPMA applications when Classic Planning applications are removed as target applications.
25812446 Data load rule for Universal Data Adapter fails when an IN parameter has a long text value.
25765020 Journals are not loaded to a single period.
25740932 Data load rule shows a running status when multiple rules in the same location execute at same time.
25723830 Trial Balance report in FDMEE does not sum correctly.
25695576 Support multi-period write-back when some periods have no data.
25689514 Unable to run Peoplesoft data load rules in parallel mode that have an account entity group.
25689152 Batch load does not use the POV period from the User settings.
25658753 FDMEE allows duplicate explicit data load mappings in release 11.1.2.4.210.
25616928 Minimize calls to the Hyperion Financial Management metadata API during the intersection validation.
25601193 FDMEE schedules are removed after applying the FDMEE 11.1.2.4.210 patch.
25565745 Cannot open a PDF file to view validation errors when the browser language is Portuguese.
25564740 An exported Excel (.XLS) file cannot be imported “as is” if it has not been saved in an .XLS format previously.
25546039 When reports using the POVPERIOD parameters are executed in offline mode, a PDF with 0 kilobytes is returned.
25543768 A shell script to launch the DRM adapter was not shipped in release 11.1.2.4.210.
25534805 In release 11.1.2.4.210, the LOADDATA.BAT command skips the Hyperion Financial Management consolidation process.
25533574 Source Period Mapping page for EPM does not show EPMA applications.
25526421 In release 11.1.2 4.210, the data load mappings for account dimensions show “equal” instead of “explicit.”
25525032 After applying release 11.1.2.4.210, the import format delimited tab is not working.
25524787 Unable to import data when the period name has leading/trailing spaces in the period mapping.
25507499 When exporting to Hyperion Financial Management, the following error occurs: “EPMHFM-832: The session has become invalid, a logoff is needed.”
25476665 DRM tabs are missing from the Application Details page after applying the 11.1.2.4.210 patch.
25394088 An ADF_FACES error occurs when an Oracle Real Application Clusters (RAC) URL is used in an ODI Repository URL.
25314660 When a customer using a universal adapter for integration with PeopleSoft added a View dimension in the import format and then saved it, the View dimension did not display.
25245051 The mapping validation button fails all source values for explicit mappings.
25204666 Check report throws a lookup error when a European amount format is used.
25203088 When loading metadata, FDMEE is not importing Employees with multiple jobs.
24299055 When adding a logic group to a location, the following error message occurs: “ora-01790 error: Expression must have the same data type as corresponding expression.”
22909588 ODI customizations in the FDMEE repository (db) are lost after the schema password is changed.
22843655 Hyperion Financial Management cell text is not protected by the data protection option in FDMEE.
21944586 In Location, increase the length of Integration Option (1-4) fields to 256 characters.
21286145 The customer is unable to create a new source accounting group, or add entries to an existing group in FDMEE.
PSE
27371480 INCORRECT DIR IN THE CREATEODIREPOS SCRIPT
27355921 FDMCONTEXT[FILENAME] RETURNS NULL IN 11.1.2.4.220
27310637 LCM IMPORT OF ESSBASE APP IS FAILING ON SQL WITH INCORRECT SYNTAX NEAR ‘|’
27310371 LCM EXPORT OF APP WITH OPEN INTERFACE SOURCE IS FAILING
Prerequisite patch
Package redistribuable Microsoft Visual C++ 2005 (x86)
Package redistribuable Microsoft Visual C++ 2005 (x64)
  • Weblogic Server (WLS)

Patch number
PSU 181016 (28343311)
Defect
10169939 10.3.3 – [MENTORING] – CONNECTION DESTROY HANGS IN THE RESERVE TEST
11781863 SEND CLOSE MESSAGE IMMEDIATELY ON SOCKET IN CONNECTIONMANAGER
11781879 STRESS:FA:SCM ILLEGALSTATEEXCEPTION: HTTPSESSION IS INVALID
11787233 NODEMANAGER IS RESTARTED AND DO THE SERVER MIGRATION,THER IS DUPLICATE IP MAPPED
11818904 ENHANCEMENT REQUEST TO CONTROL INITIAL STATE(START/STOP) OF A MDB.
11820051 JAXRPC CLIENT CANNOT INVOKE SOA SERVICE.
11926347 WHITESPACE AFTER SOAPBODY CAUSES JAXWS SERVICE WITH SAML POLICY SIGNATURE ERROR
12333627 [WLS10.3.4] WLSIFCONFIG.SH SCRIPT DOES NOT WORK ON SOLARIS X86_64 AND SPARC
12661992 E2E: WHOLE SERVER MIGRATION ON EL SOL-ZONES WORKS BUT NOT ON THE PREFERRED NODE
12698743 ISSUE WITH BUG 10207456 REOCCURS IF WE UPDATE APPLICATION INSTEAD OF REDEPLOY
Prerequisite patch
None
  • Oracle Http Server (OHS)

Patch number
PSE 18423831
Defect
18173179 Security fix
18230264 Security fix
Prerequisite patch
None
  • Smart View (SV)

Patch number
PSU 11.1.2.5.810 (28782572)
Defect
General
21607945 An invalid row height or column width error no longer occurs when performing a Refresh All on certain workbooks.
28050180, 28270312 There is no error posted when refreshing a sheet with cell references to an empty cell.
28387284, 28415659, 28427883, 28701924 Printer selection in Office applications, such as Excel, now works correctly (printer selection is no longer disabled).
28527992 You can now refresh data in templates that use formulas for the dimension without getting an error when using Windows 10 Patches 1709 and 1803.
28503327 Excel no longer lags or freezes in response to using the arrow keys to navigate around a sheet.
Essbase
27822198 If you select a range of cells in a grid in a multiple-grid sheet, and you then do a refresh, the grid layout is now correctly changed to the selected range. When you select a range of cells, the starting point must be the first cell of the grid, so that the grid will update to the newer range. This feature is mainly for expanding the grid layout. If you select only a part of the grid and then refresh, the remaining grid layout will be ignored.
28291751 You no longer receive an “Old Smart View grid format detected” message when you click Set Active Connection on a worksheet that was converted from Oracle Essbase Spreadsheet Add-in to a newer version of Oracle Smart View for Office.
28678378 When removing a private connection using the VBA function, HypRemoveConnection, the error message, ‘Failed to instantiate Planning Offline Provider -%x’, is no longer displayed and the connection is removed correctly.
Financial Management
21526607 When creating a Oracle Smart View for Office data source connection in Private Connections, the connection is authenticated the first time, and you are not prompted to log in twice.
Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud
28198572 You are now able to see cell comments in an Oracle Tax Reporting Cloud form in Oracle Smart View for Office and when using the HsGetText function.
28360285 Forms now open correctly when using the Open in Smart View command in the web application.
28436253 Navigating between cells in Excel using arrow keys is now faster.
28438962 When using Smart View in Word, the Member Selection option in the POV Manager now works correctly.
28810780 In Office 2016, there is overall improvement in the time to open large forms and to refresh ad hoc sheets.
Oracle BI EE
27605205 Cells are no longer merged when inserting a pivot table into Excel using casting to a number data type like INT. Each individual cell now displays the correct data.
28063473, 28074432 In Oracle Smart View for Office 11.1.2.5.810, you can use the new VBA function, Retrieve, to refresh. When you use this VBA funtion, the refresh does not trigger a pop-up dialog box or an empty response box.

See New VBA Function: Retrieve for more information.

28087156 The now() function now returns the correct timestamp in Smart View when now() is on the column of a pivot table.
28175078 When using Smart View to open an Oracle Business Intelligence Enterprise Edition Answer that contains sections, you no longer get an “Invalid Cell Type” error.
28377643 When you set “Scale and Layout” to 150% for the size of text, applications, and other items on Windows 10 with 1080 resolution, then insert a table view, and then click Refresh, the OK button is now visible.
28705350 Individual views in a compound view on a single sheet no longer overlap after responding to prompts in one view that result in an increased size of that view.
Prerequisite patch
None
Next article EPM 11.1.2.4.900: what's new?
Previous article EPM CLOUD Migration Accelerator Overview

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Comment

Your data will be safe! Your e-mail address will not be published. Also other data will not be shared with third person. Required fields marked as *

14 − 11 =