Not sure for which version is your requirement, I assumed being the latest version please find below the documentation link which will be of help to you, version 18.104.22.168
Hope this helps,
Charles Babu J
Thanks for the reply, And we are using HFM 22.214.171.124 vr.
Only Oracle d/b is going to migrated, And there is no change in HFM. I would like to know the necessary validation checklist/templates need to be performed in HFM application before/after migrating the Oracle database.
Unless and until your database schema names and database servers do not change, there is nothing to be done in HFM.
However it is better to check with Oracle Support of any known issues that were reported while upgrading the Oracle databases based on your source and target Oracle database versions.
Also Oracle does not test each and every patches applied to the third party tools. Eventhough HFM is a Oracle Product, Oracle Databases are really third party for HFM.
So it is recommended to back up your current database and apply the patch in a test environment and then proceed with the other environments after confirming.
You are definitely safe unless and until you have a back up database.
There is no re-configurations needed from Hyperion side but a reboot should be done after the Oracle database upgrade.
I believe, there are no much validations or checklists to be performed when you are migrating the Oracle Database as you are dealing only with Database and not included HFM.
How are you migrating Oracle Database?
Where are you migrating from?
One template that you would need to take a look at is at the "Compatibility Matrix" before you install or migrate your Database to find out if it is compatible with your HFM Version.
Hyperion Version 126.96.36.199 is supported with below.
Oracle Database (Repository):
Oracle 188.8.131.52 through Oracle 184.108.40.206.0, 220.127.116.11+
18.104.22.168+ means successive releases 11.2.0.n, where n>=1.
Exceptions and Additional Information:
1. EXCEPTION: Data Relationship Management and FDM do not support Oracle Access Manager, Oracle Application Server Single Sign-On, and Oracle Identity Manager.
2. NOT SUPPORTED FOR: Production Reporting Teradata Engine.
3. Oracle database 22.214.171.124.0 is supported only for: Calculation Manager, EPM Workspace, ERP Integrator, FDM, Financial Management, Financial Reporting (requires 126.96.36.199.28), Performance Management Architect, Shared Services (requires 188.8.131.52.11). To use Oracle database 184.108.40.206.0 for any product, you must apply the EPM System Installer patch 220.127.116.11.05.
We are copying HFM App from DEV Environment to the UAT Environment with help of HFM COPY APPLICATION UTILITY and by seeing Log, come to know that Application and Data has been copied successfully. But do we have any other list of checks, To check whether App & Data has been migrated successfully?
HFM App Name: App1
HFM App NAme: App2
The following knowledge article gives the complete reference for running the copy application utility. It speaks about the pre-requisites and also known issues.
Financial Management Application Copy Utility (Doc ID 968956.1)
Hope this helps.