Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need advice on managing changes in consolidation perimeter in HFM

DanyBOct 29 2018 — edited Oct 30 2018

Hello experts,

Let's say I have the following consolidation perimeter in HFM:

pastedImage_1.png

Now EntityD is going to move up under Holding1 sometime during the year so that we will then have this:

pastedImage_2.png

The requirement that we didn't have before is that we now have to prepare finacial statements for both Holdings (only for Holding1 before), meaning that EntityD will have part of its net income consolidated into Holding2. It also means that we will have an exit from the consolidation perimeter for Holding2 while no changes will be needed for Holding1 since EntityD is still under its perimeter.

I have the following options in mind, but I'm open to other suggestions

  1. keep EntityD under both Holdings, and then create two other entities (EntityD1 under Holding1 and EntityD2 under Holding2) where I would post journal entries in <EC> to control where the net income and the balance sheet are going.

  2. create a consolidation tree exclusively for the consolidation of Holding2, but I would still need an entity to post journals to adjust the amounts found in EntityD under Holding2.

  3. keep EntityD under both Holdings, and then post journal entries in [CA] to control where the net income and the balance sheet are going. Note that we don't really want to use [CA], so this option isn't really an option.

  4. have a separate application for the consolidation of Holding2.

If anybody has experience with something like this, I would gladly take some advice!

Thanks!

Comments