About Me

Anjum Ara I am a technology enthusiast, an ardent reader. My latest interest is virtualization. In my free time, I love understanding child nutrition, child holistic development. I bake, read, paint, and do whatever it takes to improve myself every day.

Friday, January 29, 2021

EPM 11.1.2.4 SUPPORTED WITH ORACLE 19C

 Oracle 19c is supported with EPM 11.1.2.4 but there is an unpublished bug which can be mitigated with a setting on the database. 

The following entries need to be added to the Oracle Database SQLNET.ORA file and the client SQLNET.ORA 


SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Restart the DB.

Ref Doc ID 2320228.1

Share:

Tuesday, June 23, 2020

Changing User PoV for all users in Financial Reports

We migrated applications from one server to another and noticed that in FR, the POV setting is not migrated via LCM.

If the change needs to be done for just one user this can be done from the Workspace. 
Go to Workspace > File > Preferences > Financial Reports and toggle the POV setting


This is cumbersome for hundreds of users. In order to change it for all users to follow the below steps
1. Go to E:\Oracle\Middleware\EPMSystem11R1\products\financialreporting\bin on the FR server or wherever you have installed the software
2. Edit the setInstance.cmd and set the EPM Instance home correctly



3. Launch the FRConfig.cmd > Mbeans >com.hyperion.reporting.HRprefs.previewuserpov and change the value to TRUE.





Restart the FR services. Validate if the POV setting has changed. 

In my case, it is done. 
Share: