I'd like to share a few thoughts about what's currently in this matrix.
Christmas Eve 2019 update: Stay tuned! New information has come in from Oracle and I will update this post after I finish a few plates of Christmas Day ham. First and foremost, Windows Server 2016 is NOT certified by Oracle for EPM 11.2 at this time. Please upgrade your sandboxes to Windows Server 2019. Use Oracle 12 or SQL Server 2016 as your RDBMS until further guidance.
New Years Day Update January 1 2020: Answers to my questions below have been addressed by a senior person in Oracle. I posted the answers in red text immediately after the relevant question. If you are color blind, fear not as I prefixed the text with "ORACLE'S ANSWER". I offered to provide accreditation to the Oracle person who was kind enough to read through this post thoroughly and provided a thoughtful response, but the person asked not to be named. Again, a big THANK YOU to the person at Oracle who provided these answers! We now have more clarity, as you will see in the red text below! As the Oracle person asked not to be identified, I paraphrased the answers in my own words.
- Why isn't Windows Server 2016 listed? ORACLE'S ANSWER: Windows Server 2019 was the focus of Q&A testing because it has the "longest runway" from a Microsoft Extended Support perspective. It might work on 2016 and 2012, but your mileage will vary and is not guaranteed.
- Yes, Windows Server 2012 R2 is coming out of Microsoft Extended Support in a few years, but will it work there? ORACLE'S ANSWER: As above, not worth the R&D / Quality Assurance time as Server 2012 has a limited shelf-life from a Microsoft perspective. DATAVAIL ANSWER: Ping me in LinkedIn if you couldn't attend my ODTUG webinar on this topic and I can quickly debrief you.
- The only version of MS SQL Server listed is 2016. (One person told me they tried it on 2019 and it didn't work, so he's downgrading to 2016). ORACLE'S ANSWER: From a Microsoft perspective, SQL Server 2016 is the version certified for Oracle Fusion Middleware 12c.
- The Firefox ESR version numbers are not listed. In EPM 220.127.116.11, certain EPM screens stopped working once you surpassed a certain Firefox version. Has this been fixed in 11.2? PERSONAL ANSWER: Once the 2020 New Year champagne wears off I need to go back and check if this was answered.
- Windows 10 is the only supported Windows OS listed. What about 8.1? Not everyone has finished their migration to 10 yet. ORACLE'S ANSWER: 8.1 is coming out of Microsoft Extended Support soon, so testing/QA emphasis was spent on Windows 10 from a desktop perspective. DATAVAIL'S ANSWER: Windows 7 is close to end-of-life and a desktop upgrade to Windows 10 is recommended.
- Why is Windows Server 2012 listed as a certified client OS, but not as a certified server OS? ORACLE'S ANSWER: As above. Server testing was focused on MS Server 2019 due to the predicted shelf life. PERSONAL ANSWER: Server 2012 is essentially the same technology as Desktop 10, so this kind of makes sense.
- JRE 8 is the only client Java plug-in supported? Is the EPM system not backward-compatible for organizations who haven't completed their client desktop updates yet? ORACLE AND PERSONAL JOINT ANSWER: Java 6 came out of Oracle Extended Support on Jan 1 2019. Java 7 has a limited shelf life and the security updates for it are only available to paying customers; the general public doesn't have access to those updates. Java 8 has the longest shelf life until a subsequent patch is issued for EPM 11.2 that certifies newer versions.
- Certification Matrices for 18.104.22.168 and prior listed Microsoft Office versions. Microsoft Office is conspicuously missing here. We know 365 Cloud won't be certified until a newer version of SmartView is released, but could we get some details in the meantime. ORACLE'S ANSWER: Oracle SmartView for Office is the only desktop client remaining that cares about the version of MS Office. A conscious decision was made to remove Office from the matrix so as to reduce confusion.
Speaking for myself, I've got a secret underground bunker / mad scientist lab with a 6-month Trial Edition of MS Windows Server 2016 and MS SQL Server 2016 Developer Edition. I've gotten through the EPM 22.214.171.124 install and config, and everything works fine except for Oracle HTTP Server 12. I'll write a separate post on that once I complete the troubleshooting process and can actually login.
The certification matrix is widely considered to be a "one stop shop"on these types of questions, rather than having to wade through a variety of readmes, installation and admin guides. I'd love to see the matrix tightened up and improved.
Did I miss any of your questions? Post them in the comments below!