Documented Issues which I faced in my daily work on Oracle EPM(On-Premise and Cloud), and also on OneStream
Followers
Friday, June 17, 2022
Privacy Policy
Thursday, May 19, 2022
Hyperion Planning Migration but Target app name wants different?
Some times we will get request to migrate Hyperion planning application but wants to import it with new name. We can do that with below steps. This is not oracle recommended method, but we can do this for testing apps.
Change application name in below files
1. Update application name and data source name in Application definition in below path.
resource/Configuration/Properties/Application Defination.xpad
2. Update application name in import.xml files. change in all import.xml files.
Then zip the folders again and upload to shared services.
While importing, in the popup it should show new application name. We must create data source for new application.
Thanks,
Mady
Monday, April 11, 2022
How to change Planning Application Owner in 11.1.2.4
Only one user can be the owner of a Planning application. That user has all the ordinary rights of an administrator user, plus the additional rights to delete the application.
The user who created the application originally (or deployed it from EPMA originally) is the initial owner. Only that user can hand over ownership to another administrator user. To hand over the ownership (assuming you know who the owner is):
- Log into the Planning application with the application owner
- Administration > Application > Settings
- At the bottom of this page is a menu that allows the owner to hand over the ownership to any other provisioned administrator for this application. Only the owner can see this menu.
If you do not know who the owner is, the easiest way to determine this is by looking in the Planning application database schema. You can also change ownership directly in the tables, although we recommend that it is changed via the user interface, as above.
- Before making any manual changes to the relational repository please ensure that you have a working backup of the database.
- Look at the contents of the HSP_USERS table. The owner has a ROLE value of 3. Ordinary administrators have a ROLE of 0.
- Make a note of the USER_ID of the user with a ROLE of 3.
- Look in the HSP_OBJECT table for a record with an OBJECT_ID that matches the USER_ID recorded in the previous step.
- This record's OBJECT_NAME is the user name of your application owner.
If you want to reset ownership you can change the ROLE of an existing administrator to 3, and set the current owner's role to 0. As above, you will need to look at the HSP_OBJECT table to work out which user corresponds to which USER_ID.
Restart the Planning service after modifying the database in order for the changes to take effect
Reference: How to View or Change a Hyperion Planning Application Owner (Doc ID 1327618.1)
Thanks,
Mady
Wednesday, October 20, 2021
How to edit or remove SmartView URLs in Excel SmartView
Tuesday, October 5, 2021
Hyperion Logging Level Increase
Wednesday, June 30, 2021
DRM URL not working in any browser after upgrading to 11.1.2.4.350
Recently, I came across one issue while upgrading DRM from 11.1.2.4.346 version to 11.1.2.4.350.
DRM 11.1.2.4.350 version needs .Net Framework 4.7.2 as a pre-requisite for upgrade.
We have installed 4.7.2 version and tried to setup DRM 11.1.2.4.350 version.
Everything went well, but URL notworking at all in any browser even in IE. We will through Event logs, settings, Compared with Other systems. Nothing major we found. In Event logs, it's showing .Net framework setup not done properly. So, we removed .net and updated again after restarting Server. But same issue.
We tried below: DRM Uninstalled, and restarted server, then installed DRM again, still issue persist.
Tried with same as above with .net framework also, same results. same issue.
Now, after spending some more time, we found one error in Event viewer.
Error is referring that web.config file is having temp folder path which doesn't exist. I have removed that path and saved web.config file.
Now URL is working fine in all browsers.
Thanks,
Mady
Wednesday, June 9, 2021
IE supports Hyperion 11.1.2.4 ??
IE supports Hyperion 11.1.2.4 ??
Yes, Microsoft going to stop IE support and pushing Microsoft Edge to all clients for better usage.
What about Hyperion? Yes, Hyperion Workspace URL doesn't work on Microsoft Edge or Google Chrome.
So, Our Next option is Patching....!!! ONE MORE OPTION IS THERE, WE CAN USE FIREFOX...!
For this update Oracle released patches, by applying below patches Hyperion Workspace URLs we can access using Microsoft Edge, Chrome also.
Customer Recommended Browser Support Added for Google Chrome and Microsoft Edge with EPM System Releases Beginning with Release 11.1.2.4 (Doc ID 2675883.1)
DETAILS
Please be advised that Oracle Hyperion Enterprise Performance Management System release 11.1.2.4 added browser support for Google Chrome and Microsoft Edge. You must update to the following supported releases:
Hyperion Shared Services 11.1.2.4.100+ (Patch 31319089. Use Patch 31574562 for release 11.1.2.4.9xx)
Hyperion Planning, Hyperion Capital Asset Planning, Hyperion Workforce Planning, Hyperion Project Financial Planning 11.1.2.4.009+ (Patch 29889455)
Hyperion Calculation Manager 11.1.2.4.014+ (Patch 28557058)
Hyperion Financial Reporting 11.1.2.4.712+ (Patch 30670918. Use Patch 30671119 for release 11.1.2.4.9xx)
Hyperion Financial Management 11.1.2.4.208+ (Patch 28511735)
Hyperion Financial Close Management and Hyperion Tax Governance 11.1.2.4.253+ (Patch 29060830)
Hyperion Tax Provision 11.1.2.4.202+ (Patch 25316913)
Hyperion Financial Data Management 11.1.2.4.220+ (Patch 25312033)
Hyperion Profitability and Cost Management 11.1.2.4.130+ (Patch 29461894)
Hyperion Workspace 11.1.2.4.825+ (Patch 31124100. Use Patch 31486872 for release 11.1.2.4.9xx)
Hyperion Data Relationship Management 11.1.2.4.350+ (Patch 31420887)
Additionally, you must also update Oracle JDeveloper / Application Development Framework 11.1.1.7.1 (Patch 31246831).
Workspace started support for Chrome and Edge browsers from PSU 11.1.2.4.825
- 31124100. This patch was made available from JUN-01-2020.
HFM PSU 11.1.2.4.208 was made available from JAN-07-2019.
HFM PSU 11.1.2.4.209 was made available from APR-09-2020.
Change the PSU accordingly in this document
EXCEPTIONS
Oracle JDeveloper / Application Development Framework does not apply to Hyperion Data Relationship Management or Hyperion Workspace.
Please see the Supported Platforms Matrix for a complete list of certified platforms.
Thanks,
Mady