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

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):

1. Log into the Planning application with the application owner
2. Administration > Application > Settings
3. 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.

1. Before making any manual changes to the relational repository please ensure that you have a working backup of the database.
2. Look at the contents of the HSP_USERS table. The owner has a ROLE value of 3. Ordinary administrators have a ROLE of 0.
3. Make a note of the USER_ID of the user with a ROLE of 3.
4. Look in the HSP_OBJECT table for a record with an OBJECT_ID that matches the USER_ID recorded in the previous step.
5. 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

How to edit or remove SmartView URLs in Excel SmartView

We do have to connect with multiple environments or clients as part of our daily job. 

We may add URLs also in SmartView to connect. But how to remove those URLs if you are overloaded in that place. 

 Follow the below steps to remove list of those URLs. 

 In the below Path, check Properties.xml file. 

C:\Users\\AppData\Roaming\Oracle\SmartView 

Note: Appdata will be hidden folder in every user profile. If you check show hidden files, you can see that folder. Or you can directly above Url with replacing with your username in the Url. 

Open Properties.xml file Two sections will be there. 

One is OverrideWorkspaceURL tab, another one is PreviousUrlList  tag. Override Workspace URL is about URL which will be highlighting in dropdown box, I mean we can see immediately when we open. 

Previous Url List is about Previously used URLs. 

You can remove Previous used URLs in that file and save it. 

Thanks, 

Mady

Hyperion Logging Level Increase

How to increase logging level for Hyperion Components. 

  How to Change the Logging Levels for Hyperion EPM Products in Release 11.1.2.x (Doc ID 1158016.1) 

Navigate to MIDDLEWARE_HOME/user_projects/domains/domain name/config/fmwconfig/servers/ Ex.: Oracle_Home\Middleware\user_projects\domains\EPMSystem\config\fmwconfig\servers 

For the Product, select the corresponding managed server name: 

Shared Services and EPM Workspace -> FoundationServices 

Essbase Administration Services -> EssbaseAdminServices 

Provider Services -> AnalyticProviderServices 

Reporting and Analysis Framework -> RaFramework Financial Reporting -> FinancialReporting Financial Management -> FMWebServices 

Planning -> Planning 

Open logging.xml file in a text editor. 

Scroll down to the section starting with Change NOTIFICATION to any of the following logging levels: 

Message Type Level Description INCIDENT_ERROR 1 A serious problem that may be caused by a bug in the product and that should be reported to Oracle Support. Examples are errors from which you cannot recover or serious problems. 

 ERROR 1 A serious problem that requires immediate attention from the administrator and is not caused by a bug in the product. 

 An example is if Oracle Fusion Middleware cannot process a log file, but you can correct the problem by fixing the permissions on the document. 

 WARNING 1 A potential problem that should be reviewed by the administrator. Examples are invalid parameter values or a specified file does not exist. 

 NOTIFICATION 1 A major lifecycle event such as the activation or deactivation of a primary sub-component or feature. This is the default level for NOTIFICATION. NOTIFICATION 16 A finer level of granularity for reporting normal events. 

 TRACE 1 Trace or debug information for events that are meaningful to administrators, such as public API entry or exit points. 

 TRACE 16 Detailed trace or debug information that can help Oracle Support diagnose problems with a particular subsystem. 

 TRACE 32 Very detailed trace or debug information that can help Oracle Support diagnose problems with a particular subsystem. Save the logging.xml file and restart the service(s) for the corresponding Product. 

 More information about changing logging levels and management of log files can be found in Oracle Enterprise Performance Management System Installation and Configuration Troubleshooting Guide, available for download from EPM Documentation Library. 

 Thanks,

Mady

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

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

Hyperion Weblogic Patching

 Patching must be go through Readme steps, but here we will see high level steps.

Download and copy weblogic patch into cache dir in below path: D:\Oracle\Middleware\utils\bsu\cache_dir

Go to path using cmd D:\Oracle\Middleware\utils\bsu and execute below command.

bsu.cmd -install -patch_download_dir=D:\Oracle\Middleware\utils\bsu\cache_dir -patchlist=FMJJ -prod_dir=D:\Oracle\Middleware\wlserver_10.3

We need to install this patch in all server, wherever we have domain deployed. 

Note: Stop all services before this patching. Check any WebLogic installed already in the system. If yes, remove that patch and then install above patch.

Thanks,

Mady