Oracle Essbase Patch Update 21.6.0: What’s New in August 2024

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:

Patches to download for Essbase 21.6.0

Oracle Essbase Product VersionLatest Patch Set, Patch Set Update or Maintenance ReleasePatch Release Date
Essbase 21.6.0.0Patch 35426547 Binaries
Patch 35426541 Scripts
 August 2024

The Full List

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

Related Post