HFM Upgrade Issue from all prior release to 11.1.2.4 - HFM Process History
"Do you have already signed off you HFM migration from earlier release to 11.1.2.4?
If yes, this is time to add one more Test Case in your upgrade UTP on process history for already signed off period."
I am assuming you have taken maintenance release approach
while upgrading, unless you are John Goodwin.
In both upgrade approach check the HFM Process History for
all Signed Off period. I am sorry to make you unhappy.
Old:
11.1.2.4:
What happened internally is , oracle has not done (at least in my case, if you disagree) the table partitioning for old <HFM Application Name> _ PFLOW table into the modified " <HFM Application Name> _
_ PFLOWH_ <SCENARIO_ID> _ <YEAR>" tables.
In any of the Oracle Application schema upgrade script I
have not yet seen that (Default Path : C:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Server\conf)
select distinct ' HFMAPPNAME _PFLOWH_'||f.lscenario||'_'||f.lyear
as TABLE_NAME
from HFMAPPNAME_PFLOW f;
1. Change HFMAPPNAME to your HFM Aplication name and then create all of the table that is coming out of the script.
2. Use the same table structure that is there for HFMAPPNAME_PFLOW except the first two column.
3. Insert the data back to the individual newly created table from the HFMAPPNAME_PFLOW table based on scenario and year filter.
I hope now you can continue to enjoy new year.
May be in some good day, oracle will copy this solution in their patch.
