Financial Consolidation and Close

Get Involved. Join the Conversation.

Comments

  • Julien Coudrette

    Hi Nouria

    Yes, I think it is a known issue.

    You'll have to find creative ways to preserve your overrides somewhere else.

    Julien

  • Berndt De Bruyn
    • posted via email reply October 17, 2019
    • Permalink
    Thanx Tom
    
    Much appreciated - will try to get client to go the OIC route
    
  • Dishil Shah

    Hi,

    We had a similar type of issue where we have data with Particular Inter company from Jan. Till April for that inter company method of Consolidation was Not Consolidated and form May we started its Consolidation. So In May we want YTD data with that particular entity to be eliminated but in FCCS it was just doing elimination for May Periodic. So at that time we had to adjust the same through journals.

    As FCCS is working with Periodic concept, it seems that this issues will be there.

  • Elena Medrano

    Thanks a lot! I have investigated and it seems related with the fact that our entity hierarchy is not created under the Total Geography member... so yes, we can do nothing but wait until the ER is solved.

    Thanks.

  • Margaret Reed

    Pamela, you will need to post the alternate hierarchy for Income Statement accounts after the FCCS_Balance Sheet grouping.  Currently, you need to have the primary accounts for balance sheet and the descendants of FCCS_Net Income within the FCCS_Balance Sheet grouping. You can create a new group called Income Statement and place the alternate hierarchy after the FCCS_Balance Sheet group.

  • Dishil Shah

    Hi,

    We had faced this issue and when we raised the SR for the same then they told that there is already Enhancement request raised for the same.

    So I think now we don't have any solution for the same. Just need to wait till ER get resolved in any update.

  • Tom LeFebvre

    Yes, Oracle Integration Cloud (OIC) is required to perform Automation or Event Monitoring tasks for Non-EPM cloud applications including on-premise EBS.  Yes, there is an additional subscription cost for OIC but it is not expensive and does enable the customer to use the pre-built integrations for EBS events.  

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

    It is possible to write fully custom integrations which leverage a different integration component (like Oracle SOA suite) but it would be a completely custom implementation and would require extensive understanding of the communication between the EPM cloud, the integration component and EBS. 

    I would strongly recommend positioning OIC with your customer.

  • 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 ,

    Tushant 

  • 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.
    Regards,

  • S.L

    Hi Luca,

    I am so sorry for my delay.

    Here you have the error I get.

    Regards,

    Sandra

  • Tushant Pandey

    Hello Dipen ,

    I re-deploy the FCCS_10 rule and tried posting the override again but still facing the same issue .Also, i tried by commenting out the custom rule which is at the insertion point .

  • Dipen Shah

    Just re-deploy FCCS_10 rule, please. This will set the calc status to system change and will allow you to run consolidation again. That may fix your issue.

     

    Thanks,

    Dipen

  • Tushant Pandey

    We haven't implemented any translation overrides . We have built a custom rule at the insertion point FCCS_10 rule and it's deployed.

    Is there anything else i can check ?

    Thanks ,

    Tushant 

  • Dipen Shah

    The setup looks correct. I hope you haven't implemented any "Translation Overrides".

    If you have access to configuration rules, please deploy the FCCS_10 rule (even if it's empty) and try running consolidation again.

     

    Thanks,

    Dipen

  • Tushant Pandey

    Hello Dipen ,

    Thanks for the prompt response !

    Base currency for the Entity Ent_40_76 is CAD while it's parent entity has the base currency USD. Please find the attached s/s for the account properties .

    Thanks ,

    Tushant