Wednesday 26 February 2020

Oracle OpenWorld Europe 2020 Summary

The following are some of my notes from the Oracle OpenWorld Europe 2020 conference.

There was some news on the support dates for 11.1.2.4:
  • Hyperion 11.1.2.4 Premier Support extended through to December, 2021 - this replaces Extended Support.
Basically it will be Premier Support until December 2021 and then straight into Sustaining Support. I posted the definitions of each support level in a previous blog post.

The roadmap for 11.2 patches has been released - I have copied it below:

.100 .200 .xxx
Scheduled for March Scheduled for mid year Scheduled for end of year
3rd party Certification
+ Chrome
+ Edge Chromium
+ Windows 2016
3rd party Certification
+ OEL 7 (UL 0+)
+ Red Hat 7 (UL 0+)
+ Solaris 11 update 2+
+ AIX 7.1 TL 1+, 7.2 TLO+
3rd party Certification
+ SQL Server 2017
+ SQL Server 2019

FMW 12.2.1.4
Defect Fixing Defect Fixing Defect Fixing

Apart from that there was just some information on migration. I would recommend downloading the session slides here:
https://events.rainfocus.com/widget/oracle/owlonglobal2020/cataloglondonow20

EPM 11.2: Explore Button Not Appearing

This is a post about an issue we had in our environment, it seems likely an Oracle Support document will be created for this problem but I just wanted to post it here as well. The fix wasn't actually discovered by me, but by a colleague.

The problem is that in Workspace on EPM 11.2 the Explore button simply does not appear. Inspecting the configtool logs shows errors like this:

...
[2020-01-02T16:23:04.675+00:00] [EPMCFG] [ERROR] [EPMCFG-07211] [oracle.EPMCFG] [tid: 65] [ecid: 7eeb9fd7-2d0f-4d3f-a525-322664eb6983-00000006,0:2:3:3:3:4:3:2] [SRC_CLASS: com.hyperion.avalanche.config.DocRepHubRegistration] Error registering instance file: Product not found.

...
[2020-01-02T16:23:04.706+00:00] [EPMCFG] [ERROR] [EPMCFG-07164] [oracle.EPMCFG] [tid: 65] [ecid: 7eeb9fd7-2d0f-4d3f-a525-322664eb6983-00000006,0:2:3:3:3:4:3:2] [SRC_CLASS: com.hyperion.avalanche.config.DocRepHubRegistration] Exception generated when calling CSS API: EPMCSS-20570: Failed to provision identity native://DN=cn=911,ou=People,dc=css,dc=hyperion,dc=com?USER. Application DOCREP:DocRepApp not found in system. Provide valid application id to provision user/group.
...

The issue here is that the application was created in the Shared Services registry but it is not linked to the Default Application Group. This was validated by checking the HSS registry report:




The roles for the document repository did exist in HSS:


So all that was required was to use the epmsys_registry utility to link the application to the project, using the project's object ID:

cd /d e:\Oracle\Middleware\user_projects\FND1\bin
epmsys_registry.bat createlink #e6811d83f677e6702c765b8316f6702f84S7ffb #DocRepApp.DOCREP

The validation that the link was successful can be taken from the HSS registry report:



After these changes the Explore button appeared in Workspace: