Consolidation in Oracle Fusion- Part 1
In this training article we will understand the brief overview of Consolidation and the process followed in Fusion Financial Application in order to complete consolidation process. In part 1 we will understand need of consolidation along with types involved and benefits of various method of consolidation used.
In the subsequent parts of Consolidation on Oracle Fusion, we will cover Elimination entries and Financial Management Integration Option in Fusion Applications.
Need of Consolidation:
Consolidation is required to combine or consolidate Accounting and Financial results of multiple companies from multiple Ledgers, Currencies, Calendars & Accounting flexfield structures. Consolidation is a period-end process of combining the financial results of separate subsidiaries with the parent organization to form a single, combined statement of financial results. Consolidation is a year end process when companies prepare their balance sheets.
Types of Consolidation:
Below are brief details of various consolidation methods available-
-
Reporting Only Consolidations- used when subsidiaries and the corporate ledger share the same chart of accounts and calendar.
-
Balance Transfer Consolidations: This type of Consolidation is used when subsidiaries and the corporate ledger have either or both different charts of accounts and different calendars.
-
Financial Management Consolidations: If there are complex factors in financial consolidation requirements like-
-
Complex company structures such as joint ventures, minority interest holdings, partially or fully owned subsidiaries.
-
Multiple heterogeneous systems including non general ledger data sources that are required to support non-financial or industry specific metrics, disclosures, and footnote schedules.
Below is diagrammatic overview of Consolidation-
Let us understand first two consolidation methods-
Reporting only Consolidation Method:
This method is used when-
-
All subsidiaries and the corporate ledger share the same calendar.
-
One of the subsidiaries has a local chart of accounts and local currency. This subsidiary uses a secondary ledger to record balances in the corporate chart of accounts and the corporate currency.
-
One subsidiary has a local currency and uses reporting currency functionality to record balances in the corporate currency.
In this method following tasks are followed-
-
Group the ledgers in a ledger set if the ledgers share the same chart of accounts and calendar.
-
Translate balances to the corporate currency for ledgers not in the corporate currency.
-
Create eliminating entries.
-
Report using the ledger set and the corporate currency as reporting parameters to view the consolidated balances.
If each entity's ledger has a different chart of accounts or calendar from the corporate chart of accounts and calendar, a secondary ledger is used to conform to the common chart of accounts and calendar and is included in the consolidation ledger set.
Benefits of Reporting Only Consolidation:
-
No need to run additional processes to consolidate unless ledgers have a different currency than the consolidation currency.
-
View the consolidated balances anytime. This cannot be done in the Balance Transfer Consolidation method because that method requires a balance transfer be done to achieve consolidation.
-
Faster close process.
Balance Transfer Consolidation Method:
In case where multiple subsidiaries and the corporate ledger do not share the same chart of accounts and calendar we can take the help of Balance Transfer Consolidation method where-
-
The subsidiaries use local charts of accounts and currencies. The Corporate ledger uses a corporate chart of accounts and currency.
-
The subsidiaries use balance transfers to convert the local balances to the corporate chart of accounts and currency.
We need to follow below steps for Balance transfer consolidation method -
Oracle Fusion supports two method of balance transfer, first when the balance data is transferred from a primary ledger to a balance level secondary ledger assigned to it and the second when the balance data is transferred from one ledger to another without a predefined relationship. In both the cases drill down is possible from the target ledger balances to the source ledger balances, below are some instances-
-
When the source and target ledgers currency is the same, we can drill down on the entered amount from the Journal Lines page or the Journal page in target ledger which resulted from a balance transfer.
-
When the source and target ledgers do not share a ledger currency, it is also necessary to translate the source ledger to the target ledger's ledger currency before transferring balances.
Balance Transfer Consolidation Pros:
-
Do not require a standardized chart of accounts and calendar.
-
In journal or subledger level reporting currency ledger, translated balances are available from either Reporting Only or Balance Transfer Consolidations.
-
Reporting level reporting currency ledger needs to have the translation process run when it has a different currency than the consolidation currency.
Balance Transfer Consolidation Cons:
-
Require an additional consolidation ledger to maintain balances or the current parent ledger can serve as the consolidation ledger. By using parent ledger, transfer the subsidiary balances directly into that ledger.
-
Needs to run balance translation process if the currency is different from the consolidation currency. Then run the transfer processes to view the consolidated balances.
-
Maintain charts of accounts mappings, which can be a labor intensive.
-
Outdated balance transfers have to be reversed and posted, and then a new balance transfer is run every time the source ledger's balance changes.
-
Requires translation to be run again if ledger currency is different than the consolidation currency.
Comments
Keep up the good writing.
I'm new to the blog world but I'm trying to get started and set up
my own. Do you require any coding expertise to make your own blog?
Any help would be really appreciated!
truly enjoyed surfing around your blog posts.
In any case I'll be subscribing to your rss feed and
I hope you write again very soon!
blogs use WYSIWYG editors or if you have to manually code with HTML.
I'm starting a blog soon but have no coding expertise so
I wanted to get advice from someone with experience.
Any help would be greatly appreciated!
quick shout out and say I truly enjoy reading your
posts. Can you suggest any other blogs/websites/ forums
that cover the same topics? Thanks for your time!
de las imprescindibles que debes tener siempre a mano.
Uno de los puntos fuertes de Tutete es que hay una gran cantidad de
productos que puedes personalizar con bordados del nombre de su destinatario como
mochilas, baberos o incluso chupetes personalizados.
3. En notas del pedido, indica el nombre con el de que deseas
personalizar el regalo. En todo momento verás, antes de finalizar el pedido, cómo va a quedar
tu regalo, para revisarlo y editarlo a tu gusto.
Una vez hayas confirmado el pedido, nuestro equipo de diseñadores y de producción procederán a fabricar tu
diseño y a enviarlo en la dirección que
hayas indicado. Todos los bolsos cuentan con piezas extra y una herramienta para despegarlas por lo que podrás elegir el diseño que quieras
y cambiarlo tantas veces como te apetezca. Añade tu toque personal
escogiendo un diseño bonito.
details though?
Where are your contact details though?
And i'm satisfied studying your article. However should remark on few normal things, The web site taste is ideal, the articles is actually
nice : D. Just right job, cheers
lot of things from it concerning blogging. thanks.
it, you are a great author. I will remember to bookmark your
blog and will often come back sometime soon. I want to encourage you to
ultimately continue your great writing, have
a nice day!
issues. When I look at your blog in Chrome, it looks fine but
when opening in Internet Explorer, it has some overlapping.
I just wanted to give you a quick heads up!
Other then that, awesome blog!
Extremely helpful info specially the last part :) I care
for such info a lot. I was seeking this particular info for a long time.
Thank you and good luck.
will assist, so here it occurs.
post is written by him as no one else know such detailed about my trouble.
You are incredible! Thanks!
I appreciate you finding the time and effort to put this article
together. I once again find myself personally spending way too much time both reading and
leaving comments. But so what, it was still worth it!
lot approximately this, like you wrote the book in it or something.
I feel that you just can do with some percent to drive the message home a little bit, however instead of that, this is excellent blog.
An excellent read. I'll certainly be back.
I wanted to thank you for ones time just for this wonderful read!!
I definitely loved every little bit of it and i also have you book-marked to look at new stuff in your blog.
I am going to recommend this blog!
any widgets I could add to my blog that automatically tweet my
newest twitter updates. I've been looking for a plug-in like this for quite some time and was
hoping maybe you would have some experience with something
like this. Please let me know if you run into anything.
I truly enjoy reading your blog and I look forward to your new
updates.
plagorism or copyright violation? My site has a lot of unique
content I've either authored myself or outsourced but it appears a lot of it is popping it up all over the internet
without my authorization. Do you know any methods to help protect against content from being ripped off?
I'd genuinely appreciate it.
Keep up the great work! You know, lots of people are looking round for this information, you could aid them greatly.
after going through many of the posts I realized it's new to me.
Anyways, I'm certainly pleased I stumbled upon it and
I'll be bookmarking it and checking back often!
RSS feed for comments to this post