In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar

                In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar

Steps to resolve this issue:

1. Stop FoundationServices and RA Framework webapps, and RA Agent services.

2. Execute the following query against the Shared Services registry database:

select application_id from css_provisioning_info where lower(application_id) like 'hava%'; 

note this application id, e.g. HAVA:0000012b3072bf63-0000-6717-0acc1bac

3. Using the epmsys_registry tool, execute:

epmsys_registry updateproperty RA_FRAMEWORK/@applicationId <the application Id returned from the query above> 

Example using ID above:

epmsys_registry updateproperty RA_FRAMEWORK/@applicationId HAVA:0000012b3072bf63-0000-6717-0acc1bac

4. Restart the services.

Reference: 

In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar (Doc ID 1325933.1)

Thanks, 

Mady

How to change admin password in Hyperion Shared services

                                 Admin password change in Hyperion Shared services


Situation and Goal:
we have installed and configured Hyperion worksapce, shared services and other components in cloud servers. Then we have started migration from client LCM dump, first we did HSS migration. In this case, the admin password (which has given at the time of configuration time) is overwritten.

So, we need to reset password to some known with encrypted with in the CSS users table.

Steps:
1. Login to Shared Services Schema ( The user you used during the shares services configuration) with SQL developer or any other tools and look for “CSS_USERS” table.

2. Run the below command:

update CSS_USERS
set PASSWORD= '{SSH2}mpQoG4jU00otFocLZM6CWWUzpk9ZmSY5In3l3ZzFCH5byRhkG6ow7z4KxXmXWXSo'
where name='admin';

This will setup the admin users password to ‘password'

OR

Run the below command:

update CSS_USERS
set PASSWORD= ‘{SSH2}FvSZVSvSmzvjT/02Nn1TrJyQk8SqNus4Fw4m2cNxa3zkSLe8HFiJy7cT8zUDGiWi’
where name='admin';

Commit the changes

Note: Take backup of CCS_USERS table before do any changes.

Reference:
http://epmcult.blogspot.in/2014/06/resetting-hyperion-workspace-admin.html

Thanks,
Mady

Hyperion Url's

                                                          Hyperion Url's

Example URLs to Check
EXAMPLE ORACLE EPM 11 (11.1.2.1) ENVIRONMENT CHECKS AND MONITORING

Layer1 – Load Balancer URL Check:
https://LoadBalancerURL.local/hfm
https://LoadBalancerURL.local/aps/APS
https://LoadBalancerURL.local/calcmgr/index.htm
https://LoadBalancerURL.local/raframework/index.jsp
https://LoadBalancerURL.local/easconsole/console.html
https://LoadBalancerURL.local/awb/conf/AwbConfig.xml
https://LoadBalancerURL.local/hr/status.jsp
https://LoadBalancerURL.local/interop/index.jsp
https://LoadBalancerURL.local/hfmofficeprovider/HFMOfficeProvider.aspx
https://LoadBalancerURL.local/hfmlcmservice/LCMWS.asmx
https://LoadBalancerURL.local/workspace/status
https://LoadBalancerURL.local/HyperionFDM/AuthorizedPages/LogonPage.asp
https://LoadBalancerURL.local/hyperion-bpma-server/Applications.asmx
https://LoadBalancerURL.local/DataSync/

Layer2 – Oracle HTTP Server Redirection Check:
http://Foundation1.local:19000/hfm
http://Foundation1.local:19000/aps/APS
http://Foundation1.local:19000/calcmgr/index.htm
http://Foundation1.local:19000/raframework/index.jsp
http://Foundation1.local:19000/easconsole/console.html
http://Foundation1.local:19000/awb/conf/AwbConfig.xml
http://Foundation1.local:19000/hr/status.jsp
http://Foundation1.local:19000/interop/index.jsp
http://Foundation1.local:19000/hfmofficeprovider/HFMOfficeProvider.aspx
http://Foundation1.local:19000/hfmlcmservice/LCMWS.asmx
http://Foundation1.local:19000/workspace/status
http://Foundation1.local:19000/HyperionFDM/AuthorizedPages/LogonPage.asp
http://Foundation1.local:19000/hyperion-bpma-server/Applications.asmx
http://Foundation1.local:19000/DataSync/

Layer3 Individual Web Application Server Check:
FOUNDATION1.LOCAL Web/Web App
http://Foundation1.local:80/HyperionFDM/AuthorizedPages/LogonPage.asp
http://Foundation1.local:80/hfm
http://Foundation1.local:80/hfmapplicationservice/application.asmx
http://Foundation1.local:80/hfmlcmservice/LCMWS.asmx
http://Foundation1.local:80/hfmofficeprovider/HFMOfficeProvider.aspx
http://Foundation1.local:28080/interop/index.jsp
http://Foundation1.local:28080/workspace/status
http://Foundation1.local:45000/raframework/index.jsp
http://Foundation1.local:8200/hr
http://Foundation1.local:8500/calcmgr/index.htm

PLANNING1.LOCAL Planning
http://Planning1.local:8300/HyperionPlanning

EAS1.LOCAL Essbase Tools
http://EAS1.local:10080/eas
http://EAS1.local:13080/aps

EPMA1.LOCAL EPMA
http://EPMA1.local/hyperion-bpma-server/folders.asmx
http://EPMA1.local:19091/awb

Workspace:
Layer1 - LB Device
https://LoadBalancerURL.local/workspace/index.jsp

Layer2 – Oracle HTTP Server
http://Foundation1.local:19000/workspace/index.jsp

Layer3 – WebLogic Web
http://Foundation1.local:28080/workspace/index.jsp

FDM:
Layer1 – LB Device
https://LoadBalancerURL.local/HyperionFDM

Layer2 – Oracle HTTP Server
http://Foundation1.local:19000/HyperionFDM

Layer3 – IIS Web
http://Foundation1.local:80/HyperionFDM


HFM app creation:
http://10.177.17.195:19000/hfm/CreateApp/createapp.asp?iscontained=Yes

Source: http://www.openepm.com/epm-monitoring/example-urls-to-check

Thanks,
Mady