Oracle Essbase remains a cornerstone in enterprise analytics, enabling businesses to streamline data analysis, forecasting, and financial planning. With the release of Patch 21.6.0 in August 2024, Oracle has introduced enhancements that bolster performance, scalability, and usability. This update addresses critical functionality improvements and introduces new features aimed at enhancing the user experience across finance, IT, and operations teams alike. In this post, we will explore what defects have been fixed in the version (Please note, the latest Oracle EPM On-Premise version 11.2.19.0 (Released October 2024) has included Essbase version 21.6.0:
Oracle Essbase Product Version | Latest Patch Set, Patch Set Update or Maintenance Release | Patch Release Date |
---|---|---|
Essbase 21.6.0.0 | Patch 35426547 Binaries Patch 35426541 Scripts | August 2024 |
Defect Number | Defect Fixed |
---|---|
36023596 | ONPREM: ESSBASE 21C HOW TO MIGRATE ASSIGNED ROLES FROM OLD AD TO NEW AD IN ESSBASE |
35809682 | ESSBASE MARKETPLACE: HOW TO UPGRADE THE INSTANCE TO ORACLE LINUX 8 |
35781801 | MP-ESSBASE : ALLOW OPTION TO EXPORT ASO DATA IN COLUMN FORMAT |
35766180 | HIDDEN BOM CHARACTERS IN DATA EXPORT USING REPORT SCRIPT |
35453655 | ESSBASE 21C JET UI (ALTA): NEED OPTION TO DIRECTLY CHOOSE LOAD FILE FROM FILE SYSTEM |
35223982 | MP:ESSBASE 19.3: TD BYOK REQUIREMENT FOR ESSBASE (PAAS/SAAS) |
34745800 | ESSBASE MARKETPLACE : IMPORT AND EXPORT THE LIST OF TEXTUAL MEASURE (REDWOOD UI) |
34400114 | NEED DATA IN PARENT.CHILD FORMAT FOR THE DATA EXTRACTS VIA DM |
34325274 | MP:ESSBASE 19.3: TD BYOK REQUIREMENT FOR ESSBASE (PAAS/SAAS) |
33508315 | ESSBASE: REST API CALL TO START/STOP APPLICATION WITH "NO_FORCE" OPTION |
31619687 | SMART VIEW ISSUES WITH ALTERNATE HIERARCHY |
33553397 | DYNAMIC CALC VALUE ARE MISSING IN FORM |
36401539 | CHINESE NAME OF "CUBE DESIGNER" CAN'T SHOWN CORRECTLY IN EXCEL |
34187870 | ONPREM: ESSBASE 21C: ESSBASE ERROR(1350005):ODBC ORACLE WIRE PROTOCOL DRIVER][ORACLE]ORA-01017: INVALID USERNAME/PASSWORD |
35474752 | Y-T-D FUNCTION RETURNS EMPTY DATA VIA ANOTHER WORKS FINE. |
35708028 | UNABLE TO SAVE LOCALLY SAVED OUTLINE FILES IN EAS LITE IN 21.5 |
34130019 | FOLLOW UP TO 34048727 - MP : COLLECT DIAGNOSTICS DOES NOT COMPLETE |
34961808 | 21C ON-PREM: RULE FILE WHICH VALIDATES IN EAS DOES NOT VALIDATE IN WEB UI |
35555821 | WHEN HAS 4 COLUMNS, LEFT 2 COLUMNS HAVE DATA, WHEN DELETE RIGHT 2 COLUMNS, CAUSED LEFT 2 COLUMNS DATA CHANGED |
35259416 | CUSTOM CALC SCRIPT WITH NONEMPTYTUPLE NOT RESULTING INTO DATA WHEREAS WITHOUT NONEMPTYTUPLE PRODUCING CELLS |
36318059 | SMARTVIEW ERROR: REQUESTED OPERATION FAILED. ERROR: JAVA.LANG.NULLPOINTEREXCEPTION |
36038456 | MP: ESSBASE 21.5.3 - ESSBASE SERVICES DOESNOT START AUTOMATICALLY |
35500310 | ESSBASE RETURNS DIFFERENT DATA VALUE WHEN ADDED ANOTHER MEMBER ON COLUMN |
35796681 | MERGE TO MAIN: 34138369 - ESSBASE ERROR(1260060): THE CUBE NAME DIMENSION DOES NOT MATCH |
35343195 | ONPREM: ESSBASE 21.4 TLSTOOLS FAILS |
32926524 | BSO: FCCS - EXTRACT BY FIX INCLUDES FULLY QUALIFIED ENTITIES WHILE MDX DOES NOT |
35355306 | WHEN ADDING MORE MEMBERS ON THE ROW, CAUSED PREVIOUS MEMBER DATA VALUE CHANGED |
35973728 | 21C: DRILL-THROUGH REPORT FAILS WHEN MEMBER ALIAS HAS NON-US CHARACTERS |
35544092 | FCCS - INCONSISTENT REPORT BEHAVIOR WHEN USING ZOOM ON COLUMNS |
35186516 | MERGE TO MAIN: 35087664 - DEMO SERVICES : ESSBASE AGENT FAILED TO START AFTER NON-HA TO HA REFRESH ON FAAAS POD |
35460464 | POST JOURNALS FOR SINGLE LEDGER IS GETTING STUCK IN RUNNING STATUS |
35627861 | ESSBASE 21C - DATA LOAD ERROR WHEN LOADING DATA FROM LOCAL FILE |
35763090 | FA: 23.04: EPHT: FIX ESSBASE CRASH ISSUE OBSERVED DURING GL POSTING WORKFLOW |
35369995 | ONPREM: ESSBASE 21C - SELF-SIGNED CERTIFICATES NOT BEING REPLACED |
36238050 | MP: ESSBASE 21.4 APPS CONNECTION SLOWNESS |
35411687 | USING QUERY DESIGNER, MEMBER CHANGES TO DIMENSION NAME UPON "APPLY QUERY" |
35591789 | WHEN ADDED ANOTHER MEMBER ON THE ROW, PREVIOUS MEMBER'S DATA VALUE CHANGED |
34656749 | ALLOCATION RULE FAILS WITH ERROR(1013295) - SERVER REQUEST FAILS WITH ERROR CODE 1200762 |
33741907 | CRASH ON CONCURRENT DRILL-THROUGH UPDATES |
36341444 | FA:23D: ALLOCATION ERROR ESSBASE ERROR(1042017): NETWORK ERROR - ALLOCATION CRASHED ESSSVR WHEN OUT OF BOUNDS |
36167604 | FAIL TO SUBMIT BLANK DATA TO ESSBASE VIA "HYPSUBMITSELECTEDRANGEWITHOUTREFRESH()" AFTER UPGRADE FROM EPM 11.2.14 TO 11.2.15 |
34628144 | SMART VIEW: ESSBASE REFRESH PROBLEM IN SMART VIEW |
34127564 | ESSBASE MARKETPLACE : ISSUES WITH TEXT MEASURERS |
36230032 | 21.5.2 MP: QUERY PERFORMANCE ISSUES WITH ONE APPLICATION AFTER MIGRATION FROM OAC TO MP |
36318105 | DATABASE REFRESH FAILS AFTER 11.2.15 IF ARBOR PATH IS SHARED LOCATION |
35343656 | NO DATA FILES WHEN USING FILEGOVPATH |
35209744 | A LOAD DATA JOB FROM THE WEB UI, IF ERRORS ARE RETURNED, A ROW # ADDED TO ROW |
35207304 | MP ESSBASE - WEB CONSOLE LCM JOB IMPORT TASK ENHANCEMENT |
36441165 | MDX QUERIES TAKES 60 PLUS MINUTES TO COMPLETE |
36353859 | ESSBASE 21.5.4 - SECURITY FILTER ROLES ARE NOT INCLUDED IN LCM MIGRATION |
35615685 | MP: ESSBASE 21.4 MDX MEMBER FORMULA FOR A ASO CUBE IS NOT WORKING AS EXPECTED IN ESSBASE 21C |
36200943 | MP: FILTER MSAD / IDCS USER PROVISIONING LOST AFTER LCM IMPORT |
36088252 | MP: UNABLE TO EXPORT ALL USERS AUDIT DATA WITH LCM EXPORT |
35629007 | MP: ESSBASE 21.4 SERVICE UNAVAILABLE ERROR WHEN CONNECTING VIA JET CONNECTION |
34887216 | ONPREM: ESSBASE 21C ASO QUERY AGAINST FORMULA MEMBERS TAKING LONGER VS 11G |
34229251 | ON PREM: ESSBASE 21C - PARTITION SECURITY NOT WORKING LIKE 11.1.2.4 |
33993353 | UNABLE TO VIEW PARTITION IN ORDER TO FIX THE PASSWORD - IF PARTITION USER PASSWORD WAS CHANGED |
35554964 | APPLYING ESSBASE PATCH 21.5.0 REQUIRES ROLLBACK OF ALL PATCHES TO 21.3.0 |
35619309 | ASO OUTLINE EXPORT TO XML NOT SHOWING ATTRIBUTE ASSOCIATIONS FOR FEW MEMBERS |
35294968 | Upstream Language testing coverage for critical flows / Unicode symbols not included in ASCII / Garbage chars |
33041962 | EPM 11.2.X: ACCESS ONLINE HELP FROM EAS CONSOLE GIVES ERROR 404--NOT FOUND |
36067740 | MP: ESSBASE 21.5.3 THE USER NAMES DOESNT DISPLAY NAMES AND EMAILS |
35477791 | ESSBASE 21C - ASO CUBE DOES NOT RETURN VALUES FOR MTD PY |
35930028 | INCREMENTAL BUILD FAILING WITH ESSBASE ERROR(1007119): LOADING NEW OUTLINE FOR DATABASE [PROJPERF] FAILED MESSAGE |
35734872 | ON-PREM EPM 11.2.5/ESSBASE 11.1.2.4.040: NETWORK ERROR WHILE RESTRUCTURING ESSBASE OUTLINE IF OUTLINECHANGELOG IS SET TO TRUE |
35724688 | HSSETVALUE DOES NOT OVERWRITE VALUES WITH #MISSING |
36433035 | MP-ESSBASE: STOP.SH ERRORS OUT: STOPNODEMANAGER : PROBLEM STOPPING THE NODE MANAGER |
35006498 | POC FOR FEDERATED PARTITION. ESSBASE USAGE WITH ADW AND 21C |
34304655 | OAS GENERATED MDX CRASHES ESSBASE 21C, ISSUE ALSO OCCURS WITH SMART VIEW |
36271174 | ESSBASE CUBES HANG WHEN SECURITY SCANS TOUCHES A LISTENING PORT OF THE CUBE |
35586483 | LARGE MDX USING WITH LEAVES ENDS UP IN ERROR(1200762) WIDE INTEGER OVERFLOW |
36354531 | MERGE TO MAIN: 36333336 - RESETTING OF JAVA PROPERTY JAVA.PROTOCOL.HANDLER.PKGS TO COM.SUN.NET.SSL.INTERNAL.WWW.PROTOCOL IS CAUSING FAILURES IN FA FLOWS |
33937497 | WHEN ADDING A MEMBER "JAN" ON ROW, "FEB" DATA WILL BE CHANGED |
35112485 | MERGE TO MAIN: 34939061 - POSTING FAILS ESSBASE AGENT IS NOT ACTIVE ON BOTH PRIMARY AND HA NODES |
35212789 | DATA IMPORT FAILS WITH INVALID DATE TEXT MEASURE |
36264504 | ONPREM: ESSBASE 21.4X PRODUCTION SERVERS HANGING |
36135772 | ONPREM: ESSBASE 21.4X THREADS NOT BEHAVING AS EXPECTED |
35464124 | MP: ESSBASE 21.4 ERROR: CANNOT COPY DATABASES BETWEEN APPLICATIONS THAT ARE ENCRYPTED USING DIFFERENT KEYS |
34488154 | __QPDF_SIMU: OPTION IS CAUSING THE WRONG RESULT ON HIERARCHIES BUT NEEDED FOR PERFORMANCE |
35504951 | MP: ESSBASE 21.4 LOAD DATA JOB GENERATING MISLEADING JOB DETAILS |
35323838 | ESSBASE 21.4.3: LCM IMPORT FAILS ERROR [/DATASOURCES,DATASOURCES.XML]:STRING INDEX OUT OF RANGE] |
35250154 | WHEN ADDING MEMBER "BEGBALANCE" AS A GRID COLUMN, THE NEXT RETRIEVED DTS DATA CHANGES |
36267747 | NEW FIX ON 21.6 FOR BACK OUT OF 21.6: 34615250 - ESSBASE21C: DT REPORT ONLY WORKS AFTER OPENING/CLOSING THE DT DATA SOURCE |
35846650 | ESSBASE 21C : ESSBASE CRASHES AT EXECURION OF AN CALC SCRIPT |
36182588 | ENHANCEMENT FOR XMLA REQUESTS WITH CONTENT OPTION SCHEMA |
36134751 | EAS LOADBALANCER : COOKIE HANDLING ISSUE IN FILE FRAMEWORK_COMMON.JAR |
36191188 | FEDPART (FP) DB DOESN'T SHOW VALUES FOR REPORT SCRIPT |
36694345 | MAXL ENCRYPTION IS NOT WORKING AFTER APPLYING ESSBASE 21.5.5 |
35514895 | MP: JAGENT - EFFICIENT FILTERS IS NOT WORKING WHEN USER IS ASSOCIATED WITH MORE THAN ONE GROUP/ROLE |
35200054 | MP: ESSBASE 21.4 ASO APPLICATION CRASH WHILE RETRIEVING IN SMARTVIEW |
34001760 | OPEN A SIMPLE FORM TAKES TOO LONG TIME (130 SECONDS) |
35740993 | ESSBASE 21.5 - ERROR OCCURRED WHILE EXTRACTING 'DATA'. FILE SIZE IS NOT VALID, IT SHOULD BE POSITIVE NUMBER |
36063061 | MP: ERROR LOADING DATA FROM CATALOG ON FEDERATED PARTITION ASO CUBE |