Oracle Data Integrator (ODI) offers many benefits to users extracting, loading, and transforming data in their data intelligence systems. It offers a practical GUI to the user so that they can effectively manage this data. A small setback, however, appears during troubleshooting: mismatched timestamps.
Financial Management server clusters are an efficient way to push specific job types (such as consolidations or reports) to servers best suited to handle them. Clusters can also be used to separate user groups, like standard users and administrators. An issue arises when HFM clusters are mixed with task flows.
A key functionality of HFM allows several consolidations, data loads, extracts, emails, etc. to be scheduled and automated via a highly customizable operation called a task flow. These task flows allow for jobs to be completed without manual input between each step which can be a serious time saver, but they also present the opportunity for unforeseen HFM failures which can set you back further than if you simply did it manually.
Happy New Year – 2018!
Over the years we have featured numerous posts on technical how-tos, tips & tricks and insights from our consultants out in the field. Going into 2018 we are looking forward to expanding on our topics and will include more business-process articles, client successes, event presentations and more! And in case you missed some of these, we thought you might like to see what the most popular technical posts have been to date:
Oracle bundles an installer for WebLogic with their Oracle EPM suite of products, that ‘phones home’ to Oracle for more information. Many of us deal with clients who have firewalls that may block all attempts to communicate from the installation server to Oracle.com or other outside Internet addresses. In these cases, the installer for Oracle EPM informs us of the communication error and asks us to provide proxy information for the installer to communicate with Oracle.com. Refusal to grant the proxy information results in another nag screen after which we can move on with our installation.
Maintain Custom Account Structure Requirements in Planning via Oracle DRM Sourcing: The Oracle Data Relationship Management (DRM) product has always offered impressive flexibility when it comes to meeting the metadata requirements of subscribing target systems. This flexibility extends across numerous products and systems and is not limited to just the EPM stack. This core strength goes back to the origins of the product and has been key to its evolution from its inception with Razza, on to Hyperion MDM, and now within Oracle DRM.
New Financial Reporting Web Studio and end of life for Web Analysis
Since the release of HFM 220.127.116.11, and its change in architecture, many of the utilities that HFM administrators had come to know and love were deprecated from the product. One of the most popular of these utilities was the standalone Copy Application utility. This utility allowed you to do a direct, DB level copy of an HFM application from one environment to another, regardless of the version (you could upgrade the application after the copy) and DB type (in the most recent versions of the utility). It copied all application table contents between the environments, without a need to reload or re-consolidate data. All you needed were two UDLs created on the server that contained the utility, one pointing to the source HFM DB server and one pointing to the destination HFM DB server.