Financial Consolidation and Close

Get Involved. Join the Conversation.


    Steven Getze, CMA
    FCCS Amount Overrides
    Topic posted August 14, 2019 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Balance Sheet, Consolidation, Data Integration, Dimensions, Eliminations, Income Statement, Translations 
    312 Views, 13 Comments
    FCCS Amount Overrides
    Is documentation/instruction available, including form construction?

    Does anyone have clear documentation on how best to create FCCS forms for loading "amount" overrides?  I need to adjust USD values.   I tried building the forms using the correct POV, I inputting the zero into the entity currency column and input the incremental change into the Data Input column, but the results are wildly wrong. 

    See attachment showing specific details.   Any/all guidance will be appreciated.



    • Michel Schoolenaar

      Hi Steven,


      here's the link to the documentation:

      There is a standard "Override Rates" form available by default.

      To enter override rates:

      1. On the Home page, click Data.
      2. From the Forms list, click Override Rates.
        All accounts specified as Historical Rate accounts are listed in the rows.
      3. From the POV, select a Scenario, Year, and Entity.
      4. For an account, enter the amount or rate for the override, and click Save.





    • Keith Glide

      Keep in mind that FCCS translates level 0 members and not parent members... so override entries must be applied to level 0 members only (for example, level 0 movements, level 0 data source members, level 0 Departments etc.).

      For the currency dimension, enter to the "Input Currency" member (so USD and not USD_Reporting). For the Consolidation dimension, enter to either the "FCCS_Rate Override" or "FCCS_Amount Override" member (depending on the Exchange Rate setting on the account). As Michel notes, the seeded "Override Rates" form provides an example with valid dimensionality.

      Also note that you can only enter Rate or Amount overrides to "Historical" Exchange Rate accounts (Historical Rate Override or Historical Amount Override) and not to "No Rate" accounts... so these Historical accounts are those for which the FX Variance is transferred to CTA / CICTA. If you need to override a "No Rate" account, you could use the Translation Override rules in combination with a new global or local Exchange Rate account. In this case you could create a rule that translates your movements at the required exchange rate entered to the new rate account.

    • Paul Wilcock

      One other thing to note you need to enter the override amount in an entity that immediately translates in to the parent currency.

      If you have, for example, an entity denominated in EUR that consolidates in to another EUR entity any overrides entered in the base entity will have no effect.  In this example you would need to enter the override in to the parent entity (assuming the parent entity consolidates in to an entity with denominated the override currency).

    • Tushant Pandey


      I  need a help on posting the override for an asset account . In the attached screenshot, i am submitting the override data of column H and after running the consolidation, i am expecting the same amount in column E ( Parent currency ). Please note that the asset account is tagged as historical amount override . But somehow the override data is not sticking to the parent currency after running the consolidation .

      Could you please help me in posting this override . Oracle response was to remove the member formula from the balance sheet hierarchy, but even after doing so i am not able to post the override for this particular asset account . I was able to post for the equity accounts successfully .

      Any help is greatly appreciated .


      Thanks ,


      • Carolina Rodríguez

        Hi Tushant,

        I am currently with the same problem and I would like to know if you have been able to solve it.

        Also explain me how you could post for the equity accounts.

        Thank you very much for your help.

        • Tushant Pandey

          Make the exchange rate type to "Historical amount override " and drill down to level zero where you want to post the override . Use the consolidation dimension member "FCCS_Amount Override" and currency based on the parent entity . Submit the amount and check the parent currency after running the consolidation .

          Refere to above screenshot ColumnH, where i was trying to post the override and was expecting the same amount in column E. 

          This works fine for equity accounts but not working for assets account . Will let you know my findings .

          Thanks ,


          • Carolina Rodríguez

            Hi Tushant,

            Thanks for time, but unfortunately I don't know why it doesn't work for me. The account have the exchange rate type "Historical amount override", and I post the override in the form in "FCCS_Amount Override". Then running the consolidation, the value is not the same:




            • Keith Glide

              What Currency dimension member are you entering the override amount / rate to? It appears that you are entering to "Parent Currency". Input the override entry to the Input Currency that represents the parent currency to which you are translating. Take a look at the POV of the cells in the Override Rates form shown above (second column of the row headers).

              • Carolina Rodríguez

                You are right. I forgot to show you the "USD- input currency" member where I post the Amount Override 1500 (D22).

                However, after running the consolidation, the result is 1588 (C17).

                Thank you very much for your answers!







    • Carolina Rodríguez

      The value is in "parrent currency" but in "Amount Override", how should I do so that the value arrives inside "entity input"? (C17).

      Thank you very much


    • Carolina Rodríguez

      Thank you very much. I can do it with a calculate.


      • Yan CAI

        Hi Carolina,


        I am facing the same issue at this moment, would you please suggest what do we need to do to perform calculate?


        Thanks and Regards,


    • Carolina Rodríguez

      Hi Yan,

      I solved it within a calculation in FCCS_40_Final Calculations_Translated, where I copied the value of "Amount Override" into "Entity Input". Example:

      FIX ("Parent Currency", "31110001", "Changes in Capital Increases", "Managed Data")

      "Entity Input" = "Amount Override" -> "Data input";