EPRCS Series: Tips & Tricks: Does your doclet generate overlapped preview?

 Working on Narrative Reporting Tool with word format can be tricky. Does your preview overlap and look like this?

It is merging two doclets due to incorrect formatting. Let us fix this:

1. Open the doclet > Check Out

2. Simple trick is to insert a textbox to easily move the content around the doclet.

3. Format the textbox as shown below to make it invisible and appear as a part of the doclet

4. Layout for the textbox:

 

5. Embed the content/table/referenced ranges inside the textbox

6. Check-in

7. Preview the report again:

Read More

EPRCS Series : Uploading Additional Fonts

 Oracle recommends uploading any custom fonts or additional fonts to the EPRCS cloud instance to generate a pixel-perfect 'preview'. 

On the reference doclet click on "Valdiate Fonts" and view the warning.

Only .ttf are supported. You can upload as follows

1. Go to Library > Fonts

2. You can create a separate folder to organize it

3. Select the TTF file or zip file and upload.

If there are any duplicates it will warn and import the rest of the fonts. 

Read More

What's new with EPM 11.2.6 ?

As promised Oracle has released a new version of EPM this July and here is a quick summary of the fixes.

New Release:

• MS SQL Server 2019 supported
• Essbase Studio removed from EPM Installer 
• Automation of the process of uninstalling or updating Fusion Middleware patches as needed during Apply Update.
• Premier Support is provided through at least 2030
• Updated Oracle HTTP Server
• Support for any identity management product that supports header-based authentication
• Certification of Oracle Hyperion Planning Release 11.2.x with OGNL 3.2.18.
• Install and configure all the WebLogic instances on the same OS except for Essbase which can be on a different OS
• Documentation of database password change procedure in the Oracle Enterprise Performance Management System Deployment Options Guide .

 

Install and configure all the WebLogic instances on the same OS except for Essbase which can be on a different OS. 

 

Supported Upgrade Paths:

 

 EPM 11.1.2.4 to EPM 11.2.X

 

 

 What's in store for EPM 11.2.7?

·       Support for Visual Basic will be removed for all FDMEE customers in Release 11.2.7. Customers should migrate to Jython as the scripting language

·       FDMEE-SAP adapter, SAP adapter will be certified

 

 

 

Read More

Starting OHS with stored nodemanager password EPM 11.2.5

 

The password can be saved in a key file to avoid the password prompt each time on starting the OHS. 

                  

                           startComponent.cmd OHS_component StoreUserConfig

Java Version

 D:\Oracle\Middleware\jdk\bin>java -version

java version "1.8.0_251"

Java(TM) SE Runtime Environment (build 1.8.0_251-b08)

Java HotSpot(TM) 64-Bit Server VM (build 25.251-b08, mixed mode)

Read More

First Light - EPM 11.2.4 to EPM 11.2.5 Maintenance Update

The EPM 11.2.X application can be upgraded to the latest version EPM 11.2.5 running the installer and selecting  "Apply Update" option and then running the configurator.

The update was straightforward but I found a few experiences worth sharing. 

1. Weblogic Admin server and the managed servers did not start.  

The FAN (Fast Application Notification) is auto-enabled encountered the following error 

A MultiException has 2 exceptions. They are:

1. java.lang.IllegalArgumentException: ONS configuration failed

2. java.lang.IllegalStateException: Unable to perform operation: post construct on oracle.security.jps.wls.JpsDefaultService

to resolve this add below option to the setDomainEnv.cmd

set JAVA_OPTIONS=%JAVA_OPTIONS% -Doracle.jdbc.fanEnabled=false

and restart the Admin server.

This was strange as we have 2 environments, PROD & DEV both are on Oracle DB cluster with GRID infrastructure enabled but it occurred in only one environment. In the recent Weblogic the auto-ONS is enabled for FAN, unless you need to explicitly configure the option is not required.

Read more on this Oracle blog : ONS Configuration in Weblogic

2. FDMEE - ODI related artifacts vanished

If you have created custom ODI objects like packages they are deleted. The best solution is to backup the FDMEE schema before applying the update or take a smart export of the ODI objects.

3. Managed servers did not start via the service panel

• Missing JRF path in registry needs to be fixed

                    Follow these steps to fix it JRF & ONS/FAN 

• Create logs folder manually in the managed server location for the first time to start the services via the start.bat script or through the service panel

4. Java folder no longer comes with version details

• The java folder is not numbered unlike before it comes with a generic 'jdk' folder which I believe is great for all future Java updates

                  New folder             D:\Oracle\Middleware\jdk

• The version of Java is Java 1.8.0_251

                  

5. ODI studio packaged with this EPM version work directly 

The ODI studio packaged with the EPM 11.2.5 works straight out of the box  

        Location        D:\Oracle\Middleware\odi\studio

6. The script startManagedWeblogic.cmd points to incorrect Weblogic Admin Server Hostname

The script picks up the incorrect hostname instead of the Admin Server hostname 

             set ADMIN_URL=http://<adminserver>:<adminserverPort>

7. The status of the managed servers deployed on distributed environment shows "UNKNOWN" in Enterprise Manager

Read More