Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Nouria Kehli
    How to avoid error:Cannot set value to restricted members:...
    Topic posted August 28, 2019 by Nouria KehliBronze Trophy: 5,000+ Points 
    57 Views, 8 Comments
    Title:
    How to avoid error:Cannot set value to restricted members: "FCCS_MVMTS_FX_MOVEMENT
    Content:
    The conversion makes when an Entity is foreign currency, it applies that exchange currency and the exchange differences are calculated in movement "FCCS_Mvmts_FX_Movement", in the same account. I want to reclass that exchange currency from that account to another one but it's automatically calculated by the system. Then I try to create a rule but I can't make any rule with this movement because it's a restricted member. I can't put that member in a FIX or a member block or directly in the formula, I always get the same error: [Error Message] Cannot set value to restricted members: "FCCS_MVMTS_FX_MOVEMENT Tu" I need some way to reclass this calculated amount form an account to another one. Thank you Nouria

    Comment

     

    • Bob McGrath

      In general, I'd recommend leveraging out of box functionality wherever possible as Oracle's patches can disrupt customizations and custom logic has an adverse impact on consolidations.  

      The CICTA redirect functionality provides some capability to redirect the currency impact.   I recommend exploring that.   If CICTA functionality do not address your requirements or it's not enabled in you application, consider a Smartview model that uploads Historical Amount Overrides.  This can be used to transfer components of CTA to other sections of the balance sheet (e.g. Translation Reserve for Minority Interest).  For example, load a penny into the Entity Currency and $1,000 to the USD override to transfer $1,000 from AOCI to Minority Interest Translation Reserves.

      • Nouria Kehli
        Thank you Bob for your response. However that's in the case Historical Accounts which the exchange differences are redirected to CTA account. But my problem is when an account is NOT historical. In this case, the exchange differences are redirected in the same account, in a specific movement (FCCS_Mvtms_FX_Movement) automatically, and I want to redirect that calculated amount in that movement. How can we overcome this limitation?
      • Nouria Kehli
        Thank you Bob for your response. However that's in the case Historical Accounts which the exchange differences are redirected to CTA account. But my problem is when an account is NOT historical. In this case, the exchange differences are redirected in the same account, in a specific movement (FCCS_Mvtms_FX_Movement) automatically, and I want to redirect that calculated amount in that movement. How can we overcome this limitation?
      • Nouria Kehli

        Hi Bob

        Can you let me know how do Oracle Patches disrupt Customisation? I need to know as I think the latest patch deleted some of our rates.

        Thanks

         

    • Luis

      Hi Nouria,

      I`m not aware of the full scenario. But you should have two alternatives. (likely even more)

      First is to use the translation override feature.

      https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/agfcc/override_translation_rules_about.html

      Based on your summary it should give you the feature that you`re looking for. It will replace the out of the box translation for a given POV and you can redirect to different accounts.

       

      The other option is to do not create the fix on the FX movements as this is a restricted member. You should fix on your target (that is not a restrict member) and create a journal style movement. Removing the FX from the Original POV and adding on the target. You cannot use the FX as target. But there should be no problem in use it as source of the movement.

      I would suggest to use the translation override if possible.

      Regards,

      Luis

      • Nouria Kehli

        Hi Luis

        Thank you for your comment. Let me check if this resolves our issue and I will let you know.

        Thanks

        Nouria

      • Nouria Kehli

        Hi Luis

        Thank you for your responses, but they do not help us, ( or we have not figured out how to apply them).

        The problem is FCCS by defaults computes the (End rate - Exchange Rate ) + the difference under the same account ( 24000). See Attachment. What we could like to is reclass / move the rates difference into a different account ( 24DC), but as it is a system account, we get the error. 

        If we could find a wait to move the difference to that account, our problem will be resolved.

         

    • Luis

      Hi,

      Translation replacement with a redirection should give exactly this feature. On the configurable consolidations you should be able to do it also using the eliminations to transfer this amount.

      With the logic that you seems to be implementing you may have to change the logic.

      With restricted members you can use it on the right side of the formula but not on the left side as well.

      So something like bellow code should work.

       

      FIX (/*DIM:Account*/"240000"
      /* your other fixes should be added here */
      )
      "New_FX_movement"(
      "New_FX_movement" = "FCCS_Mvmts_FX_Movement" * -1

      )
      )

      ENDFIX

      FIX (/*DIM:Account*/"24DC"
      /* your other fixes should be added here */
      )
      "New_FX_movement"(
      "New_FX_movement" = "240000"->"FCCS_Mvmts_FX_Movement"

      )
      )

      ENDFIX

      Note that use the features like the translation override should work better depending on your scenario as there are some restrictions on the execution of custom rules when doing the translation for reporting currencies. (it is not executed when there is no translation for the a parent - e.g.: children USD, Parent USD while doing a reporting translation for the children to GBP as reporting currency, currently FCCS does not support customizations for this kind of translation)