Posts

Posts

  • Ligia Olguin
    Balance Sheet and Income Statement reports: Periodic viewAnswered1
    Topic posted January 31, 2019 by Ligia OlguinGreen Ribbon: 100+ Points, tagged Balance Sheet, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Balance Sheet and Income Statement reports: Periodic view
    Content:

    Hi guys,

    Probably a basic question, but it would be useful to get a confirmation. We loaded YTD data in December 2016 and both Periodic and YTD have been populated in that month. In Jan 2017, we have loaded Periodic data. We also mapped all accounts to the movements dimension for Cash Flow purposes.

    While creating the reports, we noticed that the only way to show the client Periodic and YTD data is working with two different Movements: (FCCS_Mvmts_Total and FCCS_ClosingBalance, respectively). So, we're building two BG and IS. 

    Is this the way you usually do your reports in FCCS?

    Thanks!

  • Stephen Coleman
    Auto Reversal JEs - loading YTD
    Topic posted November 19, 2018 by Stephen ColemanBronze Medal: 1,250+ Points, tagged Balance Sheet, Consolidation, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Auto Reversal JEs - loading YTD
    Summary:
    FCCS_Total Balance Sheet-Traditional Approach is out of balance due to a reversing entry
    Content:

    Hello,

     

    Has anyone used the reversing JEs in FCCS?  I see something strange for the this.

     

    I have a reversing entry in Jan of xxxx.  After I post the reversing entry in Feb, the periodic value is still out of balance.  I looks as if the JE was never posted.

    It is showing on the FCCS_Total Balance Sheet-Traditional Approach.  On the YTD, it is zero, but the period is view has the same number as my reversal.  You might think with the YTD at zero, we are good. However, the periodic is not correct.  To me we need both to be zero.

     

    Notes

    • I unposted the entry
    • Consolidated
    • Reposted the entry
    • Consolidated
    • It is at a parent level.  However, I do not think this the issue
    • The entry is in USD (as the parent)
    • Seems to only affect the P&L accounts
    • The JEs are loaded YTD

     

     

     

     

  • Steven Getze, CMA
    Cash Flow in FCCS2
    Topic posted November 6, 2018 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Balance Sheet, Cash Flow, Consolidation, Dimensions, Income Statement, Intercompany in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Cash Flow in FCCS
    Content:

    I am working to build out our Cash Flow Statement within FCCS, using the existing Cash Flow hierarchy within the Movement dimension.  Today we produce this statement in Excel, but to satisfy future reporting initiatives we need to get this done within FCCS.

    I have successfully completed this, but only in local FX.   In USD_Reporting, the statement does not tie out and I am seeing differences on many lines  It seems that FCCS is converting certain lines at different rates vs. what we are doing today (which is compliant with US GAAP).   I don't see any way to manipulate the FX rate that FCCS uses, movement by movement.   I also need to understand the components of the "Total Effect from FX on Non-Cash Accounts" line as calculated by FCCS - when I drill down in Smart View the data doesn't add as I expect it to.

    Can anyone provide guidance?

     

  • Steven Getze, CMA
    Metadata Validation Errors3
    Topic posted October 29, 2018 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Balance Sheet, Cash Flow, Consolidation, Dashboards, Data Integration, Dimensions, Eliminations, Income Statement, Intercompany, Locking, Supplemental Data, Task Manager, Tip, Translations in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Metadata Validation Errors
    Content:

    I have an open SR for the metadata validation errors that exist in our FCCS production application, but Oracle is not providing assistance.   My most recent communication is "The only course of action is the use of the editor, development will not provide scripting and considers this a user maintenance issue, this has been confirmed by management."

    I continue to run into significant obstacles when trying to work to resolve these errors.  For example, an existing error in our Account dimension cannot be "fixed" because the account was used in a March 2018 journal, even though I unlocked all previously locked periods and unposted all previously posted journals. 

    A few weeks ago, I exported my Account dimension into a file and made all necessary corrections, but FCCS will not allow me to re-import it back into my production app.

    Has anyone been successful in the quest to clear your errors?   Any guidance from the User community will be greatly appreciated.

     

     

  • Wayne F
    New YTD_INPUT Sep 2018
    Topic posted October 11, 2018 by Wayne FSilver Trophy: 7,500+ Points, tagged Balance Sheet, Cash Flow, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    New YTD_INPUT Sep 2018
    Summary:
    Practical use of the YTD_input member
    Content:

    In the September release of What’s New document the following was listed

    "Reverse Year-to-Date Value for Accounts Loaded in Replace Mode", details as per "note A" below.

    This is a great solution for the profit and loss only. We have encountered some practical issues, how do we use this for the balance sheet closing balances that are LTD, this is the case for 98% of our ledgers? The recommendation from Oracle Support is to add the view dimension into the import format which limits the whole load to YTD_input or Periodic?

    Rich or Keith any suggestions on how to use the new functionality for a complete trial balance?

     

    Note A

    Data Load - Reverse Year-to-Date Value for Accounts Loaded in Replace Mode

    When you load data to YTD_Input and use the Replace mode, the system loads the data and then reverses the YTD values for the Flow accounts that are not specified in the data load file.

    Key Resources

    Example: Data Import File – YTD Input and Replace Mode in Administering Oracle Financial Consolidation and Close Cloud

    Note B (summary form url above)

    When you load data using the Replace mode, the combination of data for that Scenario, Year, Period, and Entity is cleared and replaced with the data in the load file. When you load data to YTD_Input and use Replace mode for the load file, the system loads the data from the load file and reverses the YTD values for the Flow accounts that are not specified in the data load file. For the first period of a year, there is no YTD data to reverse, so the system applies this method for Periods 2-12 or 2-13. This feature is supported for Administrator, Power User and User data loads. If a Power User or User performs the data load, the system will reverse the YTD values for which the user has Write access.

  • Steven Getze, CMA
    FCCS Security Configuration?2
    Topic posted October 4, 2018 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Balance Sheet, Consolidation, Data Integration, Dimensions, Income Statement, Task Manager in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    FCCS Security Configuration?
    Summary:
    Users can no longer view forms & reports
    Content:

    We have security configured extensively in our Production application, designed so that Power Users at each of our entity's can only view data in forms and reports for their specific entity.   This is done at the Entity dimension level, where we establish "Write" for the "Entity" member.

    This has been working fine since we configured this at our January 2018 go-live, but with our September close I am being notified that some, but not all, users cannot view reports and forms.   Has anyone else come across this issue?  I don't recall reading about security related changes in the 18.09 patch.

  • Martin Kinovisques
    Financial Consolidation and Close Student Guide2
    Topic posted July 26, 2018 by Martin KinovisquesGold Medal: 3,500+ Points, tagged Balance Sheet, Cash Flow, Consolidation, Dashboards, Dimensions, Eliminations, Income Statement, Intercompany, Task Manager in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Financial Consolidation and Close Student Guide
    Summary:
    Share FCC's Student Guide
    Content:

    Hello :

    I would like to ask you if you can share with me the FCC's student guide and practice as well.

    Also if you can suggest me any SETUP videos or documents.

    Thanks for your help

    Best Regards

     

    Code Snippet:
  • Jamie Cherry
    Multi-currency Consolidations in FCCS2
    Topic posted July 19, 2018 by Jamie CherryGreen Ribbon: 100+ Points, tagged Balance Sheet, Consolidation, Data Integration, Eliminations, Income Statement, Intercompany, Translations in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Multi-currency Consolidations in FCCS
    Summary:
    Implementing and maintaining Multi-currency Consolidations in FCCS
    Content:

    FCCS multi-currency consolidation interests:  original beginning balances for retained earnings in parent and reporting currencies, CTA and entities with no retained earnings prior balances, eliminations in reporting currencies, rate and amount overrides, etc.

  • Katie McCorkle
    Different Exchange Rates for Balance Sheet and Income...4
    Topic posted July 11, 2018 by Katie McCorkle, tagged Balance Sheet, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Different Exchange Rates for Balance Sheet and Income Statement
    Summary:
    How to identify different exchange rates for Balance Sheet and Income Statement accounts
    Content:

    How can the system be configured to use a different set of exchange rates for Balance Sheet (ending rate) and Income Statement (average rate) accounts?  Previously this was done using the Flow/Balance Time Balance but all accounts in FCCS are left at Flow.

    Thanks!

  • Steven Getze, CMA
    Examples of Member Formulas?1
    Topic posted May 18, 2018 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Balance Sheet, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Examples of Member Formulas?
    Summary:
    Seeking examples of member formulas
    Content:

    Trying to created a set of ratios within FCCS, but because I do not know Essbase "code" I am unsuccessful in writing the associated member formulas.  Oracle documentation does not show examples ... so am looking for any documentation showing clear examples of member formulas (these are basic accounting ratios such as Inventory Turns, Day Sales Outstanding etc,)? .  I think I need something visual to get me started.