How to start OHS in Hyperion/EPM 11.2.x Version

                 However, when we try to start Oracle HTTP Server service up to 11.1.2.4 version, We can just go to services and start service. Just right click and start.

But 11.2.x, version is different in starting OHS http server, first we have to Oracle Weblogic http Server in server, then go to below path and execute command using command below:

Path : EPM_ORACLE_INSTANCE\httpConfig\ohs\bin

StartComponent ohs_component

Thanks,

Mady

Privacy Policy

 

Website Privacy Policy

Cookies and Web Beacons:

We do use cookies to store information, such as your personal preferences when you visit our site. This could include only showing you a popup once in your visit, or the ability to login to some of our features, such as forums.

We also use third party advertisements on www.telugulolyrics.com to support our site. Some of these advertisers may use technology such as cookies and web beacons when they advertise on our site, which will also send these advertisers (such as Google through the Google AdSense program) information including your IP address, your ISP, the browser you used to visit our site, and in some cases, whether you have Flash installed. This is generally used for geo targeting purposes (showing New York real estate ads to someone in New York, for example) or showing certain ads based on specific sites visited (such as showing cooking ads to someone who frequents cooking sites). 

You can chose to disable or selectively turn off our cookies or third-party cookies in your browser settings, or by managing preferences in programs such as Norton Internet Security. However, this can affect how you are able to interact with our site as well as other websites. This could include the inability to login to services or programs, such as logging into forums or accounts.

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