...loading APP files in HFM

I have not posted any thoughts recently because I am working on an amazing migration to the Cloud project and I spend most of my time there. However, recently I got in a situation which reminded me of a discussion that I had a few months ago in OTN. The discussion was related with issues that users had with loading APP files in their upgraded applications.

In my case, we were working on upgrading the applications from 11.1.2.1 to 11.1.2.4. We followed the process suggested by Oracle and we upgraded 11.1.2.1 to 11.1.2.3 and then moved the applications to 11.1.2.4. When I started testing the upgraded applications I found that in one out of the three applications it was not possible to extract and reload the extracted metadata without corrupting the application.

...the consolidation functionality

It is two days before the end of the year-end reporting period and at 4:50 pm the helpdesk receives a new ticket with title “Consolidation of subsidiaries and NCI query”.

Silence in front of my screen… the subject of the ticket is quite worrying for such a week and as I read further down the situation becomes even worst.  The request of the user was to explain how the system calculates the NCI for specific subsidiaries, why the closing balance was 150.000$ and what the movement consolidation movement represents. A lot of questions….

Proem

Until today, I have seen four approaches in consolidating the values of an entity to the parent entity.

• The first approach is to create manual journals at "Entity Curr Adjs". This journal will be posted both at the subsidiary and at the consolidation entity of the group.
• The second approach is to use the Sub Calculate and the function HS.Exp in order to populate specific members or consolidation accounts at the value dimension members "Entity Currency" / "Entity Curr Adjs".
• The third approach is to use the Sub Calculate and the function HS.Exp in order to populate specific members or consolidation accounts at the value dimension members [Proportion] / [Elimination].

..synchronising HFM applications

Hi all,
 

It’s been a long time since my last post but I am in the middle of 3 different projects and blogging is not one of the priorities. However, I spend a lot of time on OTN Financial consolidation space.

    1. Proem

The topic of post today will be the data synchronisation of two HFM applications with the use of the rule file.

To give you a bit of background, during an Oracle training for the HTP application, one of the interesting topics that we discussed was how to keep the data of the HTP application in sync with the data of the statutory application. The solutions offered were:

• Use of FDM.
• Use of Data synchronisation (if the application are EPMA).
• Manually extract and load data.
• Use of the rule file 

    2. Approach

Since more or less all the rules have a VB code to write to text file the debugging logs during the calculation of the data, we will use the same approach to extract the data from the source application and load the data to the target application.