Get Involved. Join the Conversation.


    Mark Rinaldi
    What's New in 19.02?
    Topic posted January 31, 2019 by Mark RinaldiSilver Crown: 22,500+ Points, last edited February 1, 2019, tagged Integration, PBCS, Planning, Tip, Workforce 
    180 Views, 16 Comments
    What's New in 19.02?
    A lot!

    I'm sure you haven't slept well awaiting my "What's New" post, so here it is!  ;-)

    As always, please read the latest What's New document for full details.  Without further delay:

    1. Migration Snapshots now display file Size and Last Modified Time
    2. Calc Manager team keeps pumping out new functions.  The @LIST(Argument) Aggregate Storage (ASO) function has now been added for us in Point of VIew ASO custom calculations or allocations.
    3. Any time the provided Oracle HCM extract gets updated with new functionality or definitions, a new file is created and made available to customers.  A release version number is added to the new file name to identify it as a new template file.   This new approach allows customers to take the latest update and, at the same time, retain all existing mappings and definitions for the target application in Data Management (DM).  Prior to this release in Oracle HCM Cloud, the extract definitions could not be updated once they had been executed.
    4. Data Integration has been updated with new source expression types for the import format.  Expressions operate on the value that is read from the import file.  They are used to transform and augment values for source dimensions.  In addition to the existing Rpad, Lpad, and Constant source expression types, the following ones are now available for the non-Amount source dimensions:  Default, Prefix, Replace, Split, Suffix, Substring, Ltrim, Rtrim, and Conditional.  The source expressions for Amount source dimensions have not changed from the previous release.  As with target expression types, you can specify when to process expressions.  You can process them during the import step or during the actual data load.  Expressions processed at the import stage may improve load performance when working with large data sets.  Wow!  These new expressions should cover all your data integration needs.  Who doesn't like a good Ltrim, Rtrim, Substring, Split, or Conditional expression?
    5. Starting with this release, you can now delete an entire integration including the name, import format, location, mappings, and data rules created in Data Integration.  The process to delete the integration is under System Maintenance Tasks in Data Management.
    6. More REST APIs for your enjoyment!  Administrators can now use these new REST APIs to optimize the performance of an application:  Set admin mode for an app, compact the outline file for an ASO cube, perform a full restructure of a Block Storage (BSO) cube to eliminate or reduce fragmentation, merge incremental data slices of an ASO cube to improve performance, and Optimize aggregation to improve the performance of ASO cubes.
    7. Incremental Data Loads for Workforce have arrived!  Leveraging the DM Incremental Load adapter, we strongly recommend loading all source Workforce data via DM rather than direct imports.  The process is to load the source file through DM and run the appropriate Process Loaded Data rule as normal.  However, all subsequent loads via DM will now compare to a previous load (of your choosing) to generate a data load file with only the changes from the source file (AKA Delta Load file).  Also new are several Groovy-based rules that will create a focused FIX statement to only calculate on the data intersections in the "Delta Load file."  So rather than re-running the Process Loaded Data for the world after subsequent loads, using this new DM load process will significantly reduce the processing time of the data import and subsequent calculations.  I'll post more on this separately and will schedule a Customer Connect Webinar on this topic.
    8. Related to the Incremental Data Load process via DM, Workforce is now shipping with additional forms to make it easier to make changes to existing data directly via a form.  The appropriate Groovy-based rules are associated with these forms to generate a focused FIX on only the data that has changed, again, to execute the calculations only on the intersections of data that have changed.

    Upcoming Changes:

    1. Removal of support for Transport Layer Security (TLS) Protocol 1.0 and 1.1.  Starting with the May 2019 update (i.e. release 19.05), Oracle will only support TLS 1.2 to communicate with the Cloud.  This is a good thing.  You shouldn't be using the outdated versions of TLS at this point.  Most modern operating systems and browsers support TLS 1.2 already, so you shouldn't notice any issues.
    2. As we have been documenting for several months, we expect to remove the ability to create NEW Composite Forms in a future update in 2019.  Existing Composite Forms will still work and can be edited but no NEW Composite Forms will be allowed after this change is implemented.
    3. Classic Dimension Editor will also be removed in a future update in 2019 as we continue to enhance the Simplified User Interface Dimension Editor (SUIDE).  As previously discussed on this forum, please log bugs and enhancement requests for the SUIDE via My Oracle Support and ensure Oracle Support puts "SUIDE" in the name of the enhancement or bug.

    I'm really excited about the Workforce Incremental Data Load process, as mentioned, you will be seeing more from me in this space on this topic.  It is critical that all partners and customers begin using this process for loading data for EPBCS Workforce planning as soon as possible to leverage significant performance improvements for subsequent data loads.

    Whew!  Stay tuned for more information and happy planning!



    • Chris Badenhorst

      Thank you.

      Are we now able to import macro enabled excel files to the Explore Repository? Support promised that this will be resolved for 19.02?


      • Mark Rinaldi

        I still show that as a pending Enhancement Request.  You may want to follow-up with Support.

        • Chris Badenhorst

          Followed up with support. They are aiming for 19.04. This can’t be a complex development? and it is causing lots of frustration. With on prem we could set any file type for upload.

    • Matt Treml

      Looking forward to the Workforce Incremental Data Load process follow up!

    • Robert Angel

      Hi Mark,


      curious as to the why on 4. when the sql functionality provides all of that and more with only a little sql knowledge required?!

      Any chance that a future release will facilitate creation of multiple import mappings linked by location, if you have a lot of imports keeping the logic working for all can be a challenge on one data import transformation, as the same thing might need different treatments dependent on the source of the data?


      Really useful though, the standard monthly release notes should be this detailed!!



      Thank you,



      • Mark Rinaldi

        I've forwarded this question to the Data Management (DM) Product Manager.

        • Robert Angel

          Thanks again - sincerely appreciated, and can I also say that I am also finding Cloud Customer Connect a vast improvement on the old MOSC / Groundbreakers formats and content.

          • Mark Rinaldi

            It pleases me to hear you comment in a positive fashion on this forum.  I think Customer Connect is a great way to share information and ideas for the products.  Also, be sure to attend KScope 2019 run by ODTUG as this is the premier user conference run by and for Oracle/Hyperion users.

    • Brian Barnes

      Looking forward to webinar on the incremental loads... will be very helpful


    • Brian Barnes

      good stuff !

    • Kevin Whalen

      Do you have an update when we will see the MCM (formerly Entity Change Management in HSF) functionality in Strategic Modeling?  I heard it was planned for the 19.02 but don't see it referenced in the update.


      Kevin Whalen

    • Robert Angel

      One more question, is there any intention from Oracle to provide any cloud based alternatives around back up processes.

      I for one do not find it credible that the solution for an enterprise system is to download offline backups.

      What I have in mind is being able to configure "Save daily backups up to XGB or X days", naturally there would be an additional incremental (memory based) cost for this service.


      And before you say EPMAUTOMATE, yes it is useful for moving backups / renaming backups on Cloud, but despite following best advice the download part of epmautomate fails consistently on larger snapshots with a slower download speed, the latter of which on client site you have no control over.


    • Luis Autrique

      Hi Mark, 


      Is it possible to rename a member in the SUIDE? It seems like it adds a member with the new name, instead of renaming it, so you end up with the old and new member, as opposed to a re-name.