Issues with 11.2.x LCM and Financial Reports? Try This!
Blog > Issues with 11.2.x LCM and Financial Reports? Try This!
Date: January 22, 2021
Article by: Jeff Henkel
So apparently there is a bug with Financial Reporting LCM in 11.2.3 EPM. This is caused by the FR product randomly storing a DB call in the Financial Reporting product registry.
You can see this by running FRconfig.cmd, found at: \Oracle\Middleware\EPMSystem11R1\products\financialreporting\bin
Once launched, you can select the MBeans tab and then navigate to com.hyperion | Financial Reporting | Attributes
Examine the various values for the database, as the exact location of the issue will vary from SQL to Oracle DB Server. In my case, the value dbUserName was the culprit, but other options include: dbName, dbProductName and DbJdbcUrl.
In the entry you will see that my Financial Reporting configuration magically pointed itself to my Planning System db…which was never intentionally configured this way.
To resolve this, and not have to resort to the command-line LCM utility, which seems to ignore this value, you can update the server registry as follows:
Navigate to the registry entries for both Foundation Services and Financial Reporting
Add a new JVMOption#. This will be the next available JVMOption not used, and mine was 37 in the below example.
Set the value for this entry to: -Dweblogic.oif.serialFilterMode=disable
Increase the JVMOptionCount registry entry to match the new number above
Restart Foundation and FR and LCM should resume functioning.
OWSM Blog Part 3 – Installation and Configuration of DRM Web Services API with Oracle EPM 11.2
Blog > OWSM Blog Part 3 – Installation and Configuration of DRM Web Services API with Oracle EPM 11.2
Date: January 21, 2021
Article by: Brad Spelman
Many of the guides for setting up DRM Web Services API deal with configuration of older versions of WebLogic than what comes with Oracle EPM 11.2 . The EPM 11.2 documentation ‘Deployment Options Guide’ is a fine document but has no screen shots. The other DRM documents out there either say ‘look at these other documents’ (many of which were not yet updated to show WebLogic 12c navigation) or are written for the WebLogic 11 server menus. This document generally follows the Oracle EPM 11.2 DOG.
Part 3, Pass-through Configuration and Testing
In Part 1, we showed the installation configuration and deployment of OWSM to the Foundation Services server. In Part 2, we showed how to get the DRM Webservices API up and running, also on the Foundation Services server.
Continuing the series, we will create and provision a user for connecting to DRM API, as well as test the pass-through functionality of the API. This guide assumes you have already set up your DRM application and Hyperion’s Foundation Services and WebLogic Admin Server console are running.
We will begin by ensuring your Shared Services has the required roles for DRM by running drm_roles_oracle.sql (or equivalent if using MSSQL) against the Shared Services database schema. The scripts may be found in your product’s $EPM_ORACLE_HOME\products\DataRelationshipManagement\server\config directory.
Execute the script and commit the changes to the schema.
Next, add the pass-through user to WebLogic. The idea in our implementation is that a product (BPM in our case) will pass credentials through a SOAP to WebLogic, Shared Services and DRM. This requires a user be created with the same credentials in each of those three products.
In your browser, navigate to your WebLogic Console at :7001/console, log in with your ‘epm_admin’ username and password.
Navigate Security Realms > myrealm > Users and Groups
Click ‘New’Name: proddrmbpm – whatever you want your account named is fine Provider: DefaultAuthenticator Password: <Not included in this documentation> Confirm Password: <Not included in this documentation>
Click ‘OK’ Click new user ‘proddrmbpm’ in the Users list Click on the ‘Groups’ tab Select ‘Administrators’ from the left column Click the single right-pointing blue arrow
Click ‘Save’
Now, we create the Shared Services Native User.
Log in to EPM Workspace as a user with Admin rights
Navigate > Administer > Shared Services ConsoleExpand User Directories > Native Directory Right-click ‘Users’ and select ‘New User’
User Name: proddrmbpm – must be the same as the one you created in the WebLogic step!
Password: <Not included in this documentation> – ALSO MUST BE THE SAME! Confirm Password: <Not included in this documentation>
Click ‘Finish’ – No provisioning is necessary
Finally, we add the user to the DRM application security.Log in to DRM Web Client as an Administrator user Navigate to Administer > Security > Users (existing names redacted to protect the innocent)
Click ‘New’ from the drop-down menu and select ‘User’
User Name: proddrmbpm Full Name: proddrmbpm Under Authentication, select ‘CSS (External)’ – We assume you have configured DRM to connect to HSS in a previous step?Check Option ‘Password does not expire’
Click the ‘Roles’ tab and select ‘Data Manager’ from left side and move it to right column with the single right-facing arrow
Click ‘Node Access Groups’ tab and select the following:
Custom.Account Hierarchy Read Only Group Custom.HFM Read Only Group Custom.Entity Hierarchy Read Only Group Custom.Other Hierarchies Read Only Group Custom.Market Hierarchy Read Only Group Custom.Org Hierarchy Add Access Group Custom.Org Hierarchy Read Only Group Custom.Product Hierarchy Read Only Group
NOTE: Your actual permission requirements may be different. This is unique to the example environment I tested these steps against! Use the right-facing single arrow to bring these to the right column.
Click ‘Property Categories’ tab and ensure all items are moved to the right column EXCEPT ‘Shared Info’
Click the ‘Save’ icon at the top left
Open Oracle Enterprise Manager Fusion Middleware Control 12c: http://yourWLservername:7001/em and log in as an admin user.Using the left-side drop down for WebLogic Domain, select Web Services > Test Web Service
For this activity, we will need to pick a test option from the list as pictured below. We use getSysPrefs for our test. If the pass-through is working properly, the SOAP string will get us the results we are looking for. One caution – the list below appears to be in a random order each time we open it, so be warned, you will have to search carefully to find the option you need!
From the Operation drop-down, select ‘getSysPrefs’ from the list
On the Request tab, under Security, select the security option ‘OWSM Security Policies’
Select the policy ‘oracle/wss_username_token_client_policy’ and check the box to the left of it
Enter the DRM batch account that was created in DRM, HSS and WebLogic
Username: proddrmbpm Password: <Not included in this documentation>
In the Input Arguments section, select ‘XML View’ from the drop-down and check the ‘Enable Validation’ box
In the text field below, remove the existing text and add the following:
If successful, the Response tab will show ‘Test Status Request successfully received’
You can see the response with the information is displayed in the Response tab, which you can then copy/paste into a text viewer of your choice to review.
Further application of the DRM API is out of the scope of this series, as this is focused on showing the ‘new’ Oracle WebLogic 12c screens. Please remember to follow your Oracle Documentation for DRM API as well, and use this series’ screenshots as a reference as needed. Thank you for reading! If you found this series useful, please feel free to drop a comment below.
OWSM Blog Part 2 – Installation and Configuration of DRM Web Services API with Oracle EPM 11.2
Blog > OWSM Blog Part 2 – Installation and Configuration of DRM Web Services API with Oracle EPM 11.2
Date: January 6, 2021
Article by: Brad Spelman
Many of the guides for setting up DRM Web Services API deal with configuration of older versions of WebLogic than what comes with Oracle EPM 11.2 . The EPM 11.2 documentation ‘Deployment Options Guide’ is a fine document but has no screen shots. The other DRM documents out there either say ‘look at these other documents’ (many of which were not yet updated to show WebLogic 12c navigation) or are written for the WebLogic 11 server menus. This document generally follows the Oracle EPM 11.2 DOG.
Part 2, DRM API Deployment
In Part 1, we showed the installation configuration and deployment of OWSM to the Foundation Services server. Continuing the series, we will get the DRM Webservices API up and running, also on the Foundation Services server. This guide assumes you have already set up your DRM application and Hyperion’s Foundation Services and WebLogic Admin Server console are running.
In the server where you installed DRM, you will find a file ‘oracle-epm-drm-webservices.ear’ . Copy this file to a location accessible by your WebLogic Admin Server. Sign in to the WebLogic Administrator Console port 7001/console. Click ‘Lock & Edit’ .
Now sign in to Oracle Enterprise Manager Fusion Middleware Control 12c port 7001/em
You may note this version of EM looks different from that which was included in previous versions of Oracle EPM. The steps pictured below are for the 12c version shipped with Oracle EPM 11.2.x.
On the left-hand side, click the WebLogic Domain drop-down menu and select ‘Deployments’
Click on the Deployment drop-down and select ‘Deploy’
Select ‘Archive or exploded directory is on the server where Enterprise Manager is running’ and click ‘Browse’
Find the location where you copied the oracle-epm-drm-webservices.ear file to, click ‘OK’
Set the remainder of the options on the page:
Deployment Plan: Select ‘Create a new deployment plan when deployment configuration is done’ Deployment Type: Select ‘Deploy this archive or exploded directory as an application’
Now you will be asked where you would deploy the DRM API application to. Select Target:
Expand ‘FoundationServices’ Select ‘Partial configured servers in this cluster’ Select ‘FoundationServices0’
NOTE: It is acceptable to target the FoundationServices Cluster instead of an individual Server in the Cluster if there is a high-availability requirement for the application
Click ‘Next’
You will next be asked about Application Attributes. In our case, it is acceptable to keep the defaults and click Next:
Review the Deployment Settings, and click the ‘Deploy’ button on the upper-right
When successfully deployed, review the messages and click ‘Close’
Switch back to the WebLogic Administration web page and click the ‘Activate Changes’ button on the left
Follow instructions as required to ensure the changes are activated. In this case, no restart of FoundationServices0 was necessary.
In Enterprise Manager, ensure the status of oracle-epm-drm-webservices is green, active and OK
For testing, open a browser tab to your Foundation Services0 server’s URL, using the direct port 28080 like so: