Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    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 
    75 Views
    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.