Financial Consolidation and Close

Get Involved. Join the Conversation.

Comments

  • Roland van den Berg

    Thanks for the tip!

  • Doron Rousseau

    Hi,

    Thank you for your reply.

    Hope it is not too late for you because you suffered from those 2 options. Let me offer you the best option I found out after I posted this issue.

    It is basically an upgrade of option 2, you can use the notepad++ option to replace words in all the files existing in a specific folder ctrl+f >> find in files

    find "Old application name"

    Replace "New application name"

    Directory " application artifacts folder" 

    Then Zip all the folders and load it to the FCCS.

    This way you do not need to open each file and replace you replace all the files at once.

    Regards

     

  • Roland van den Berg

    Hi Doron,

    It is possible, but it takes a lot of time and hassle, that you really shouldn't do it.

    Option 1, is to re-build the application from scratch

    Option 2, is to change the application name in every single file of the LCM extract.

    I have been through both options, and it takes at least days to get it done and even in the case of option 2, I couldn't get it done, as I had problems putting the files back in a zip file, that FCCS wanted to accept.

    My advice would be to live with the current name. What's in a name anyway?

    Hope this helps.

     

     

  • Rich Wilkie
    It's actually two custom dimensions today and we expect to expand to 4 in 2H18. Safe harbor applies.
  • Keith Glide

    If I understand your question correctly, you wish to calculate what we refer to as "Equity Pick-Up". The owning / holding company recognizes their share of the earnings of any owned companies on a period-by-period basis. This share of earnings is recognized at the legal company level rather than in the consolidated results. This requirement is common in the Netherlands (and perhaps a few other countries) but is not so common globally. The results are in effect a "current value" valuation of the investment in the owned company instead of the more traditional "lower of cost or market" valuation.

    Equity Pick-Up must be calculated at the Holding company level from its siblings (and descendants of siblings in a multi-level organization structure) so it cannot be calculated using Consolidation Rules. We anticipate adding standard system Equity Pick-Up Configurable Calculation rules at some point but have no targeted date as yet.

    You could write the necessary rules in Configurable Calculations but need to make sure that the siblings of a Holding company are always calculated before the Holding company is calculated.

  • Wayne F

    Hi Keith,

    Thank you for the explanation,

    Are you able to include some examples in the manual or via Customer connect?

    Thanks
    Wayne

     

  • Rich Wilkie

    Today we have lock/unlock and Close Management for approvals.  Phased submissions is on the mid-term roadmap

  • Julien Coudrette

    Hi Wei,

    The documentation says:

    • Leaf-level "Never Share" members that are outside of the Total Data Source hierarchy are not considered for aggregation to Total Data Source or Total Input and Adjusted. They are also not considered for Intercompany Elimination.

    • Only Translation and Movement calculations are performed on the leaf-level "Never Share" members that are outside of the Total Data Source hierarchy.

    So I would recommend having your "GAAP_To_NonGAAP adjustment" under Total Data Source.

    You can set it up with the ~ aggregation so it doesn't roll up into the main hierarchy.

    Julien

  • Roland van den Berg

    Hi Pavan,

    Could you please advise, where we can find an overview of the known issues?

    Also the link provided doesn't work. I get the following message:

    Cannot reach this page
    • Make sure the web address https://mosemp.us.oracle.com is correct.

    SR for this issue has been logged: SR 3-17362058131 

     

    Best regards,

    Roland

  • Keith Glide

    The following update will be added to the 18.05 Admin Guide:

    In an organization structure with shared entities, the aggregation of elimination entries processed in relation to each of the branches in which the shared entity resides is not always the result required when all instances of the shared entity are combined. For example, an entity might be owned at 40% by one immediate parent and 40% by another, with the Equity method being applied in both cases. The lower of the entity and partner consolidation % is applied to the elimination. In this case, no eliminations occur because the Consolidation % for the Equity method is 0%. When the two shared entities consolidate into their first common parent however, the combined ownership is 80% and the Subsidiary method should be applied, with a Consolidation % of 100%. An adjustment is made at the first common parent at which the aggregated results of the lower level eliminations are incorrect for the current consolidation method. This adjustment is made in the Entity Elimination Adjustments Consolidation member of the first common parent.

  • Wei Aldrich

    What we're trying to achieve is to separate GAAP and Non-GAAP balances, such as pro forma financial statement. We don't want to use multi-GAAP dimension, prefer to reserve it for something else. If we are allowed to share Total Data Source, I'm thinking a rollup as below. Please let me know if this is supported by FCCS. Thanks.

    FCCS_Total Data Source
    Total Pro Forma
                FCCS_Total Data Source (Shared)
                GAAP_To_NonGAAP adjustment
  • Pavan Indurthi

    I assume this is one of the known issue reported.

    Can you please create an Service Request to Oracle Support including Provide Feedback.

    Please refer below article for providing feedback,

    How can I assist technical support in Troubleshooting my EPM Cloud issue?

    https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?id=2208548.1

  • Nayar Ellis

    It is a New seeded member that is added when the Ownership Management is enabled for the application.  My understanding is that it is a calculated member which is used to support the consolidation process and is based off of the ownership percentages allocated to each entity.  

    Hope that was somewhat helpful.

    Nayar 

  • Wayne F

    Thank you for your reply Julien,

    This works for the Balance sheet but not the Profit and Loss, I am encountering the same issue as https://cloudcustomerconnect.oracle.com/posts/5a562e0baf.

    There is another limitation in Data Management that you need to upload twice because you need to hard code the view dimension in the import format. The workaround is to have one location for the movements and one location for the YTD data

    Thanks
    Wayne

     

  • Julien Coudrette

    Hi Wayne

    You can load YTD data to FCCS, using the FCCS_YTD_Input.

    Hope that helps.

    Julien