Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Wayne F
    Data Management Target app configuration changed during...
    Topic posted March 5, 2018 by Wayne FSilver Trophy: 7,500+ Points, tagged Balance Sheet, Cash Flow, Data Integration, Income Statement 
    72 Views, 2 Comments
    Title:
    Data Management Target app configuration changed during monthly updates
    Summary:
    Data Management Target app configuration changed during monthly updates
    Content:

    Hi All,

    I configured Data Management to use UD6 for view data loaded from HFM so I could load both the periodic values and the closing values for history.

    During the Feb update the UD6 link in the target application was removed, I created a new target adapter and the UD6 link was removed in the March update. I have an SR for this issue already

    In the Data management manual it states the following: "Data Management indicates if the data loaded to Oracle Financial Consolidation
    and Close Cloud is "PTD" or "YTD." If data is specified as YTD, Oracle Financial Consolidation and Close Cloud performs any necessary computations as if that data needs to be translated to PTD."

    My assumption is the default for the data loaded in Data management is YTD, if you unhide the view col in the work bench it show the data as YTD.

    How do I load Periodic into the movement and YTD data in the  Closing balance?

    Thanks
    Wayne

    Comment

     

    • Ganesh Nellayappan

      Hi Wayne,

      In Import format. If want to load in YTD, remove the added UD6 dimension. It would load by default in YTD.In Import format. If want to load in YTD, remove the added UD6 dimension. It would load by default in YTD.

      If you want to load Periodic

      1. Add a new Dimension row -> view

      2.Add Periodic as the expression with start and end as 1,1.

      Advice you not to use UD6 for the Periodic / YTD purpose when the view is already available.

      Attached the screenshot for your reference.

      PS: Please mark this as helpful and close the thread if it helps.

       

      • Wayne F

        Hi Ganesh,

        Thank you for your reply,

        This provides either the YTD or PTD upload, how do you recommend loading periodic values for movements and closing balance to the closing balance validation without using a mapping table?

        Thanks
        Wayne