General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Xin Wang
    Submit Your Allocations Questions to Have them Answered at...
    Topic posted November 9, 2015 by Xin Wang, last edited January 30, 2019, tagged Allocations, Financials, General Ledger, Intercompany, Period Close / Reconciliation 
    162 Views, 10 Comments
    Title:
    Submit Your Allocations Questions to Have them Answered at the Live Event on 11/18/2015
    Summary:
    Submit your questions on GL Allocations before 11/16/2015.
    Content:

    Oracle Fusion General Ledger PM team is conducting a training session on Using Allocations in Oracle General Ledger on 11/18/2015.

    Submit your questions on Allocations before 11/16/2015 to have them answered during the event.

    Comment

     

    • Lynda Brill

      We attempted to set up allocations about a year ago and ran into a bug that did not allow the allocation to complete if one of the accounts it was trying to allocate was at a zero balance for the month. It would end in a divide by zero error. Has this bug been addressed and corrected?

      • Abhijit

        Could you please point us to the SR number or bug number to understand the issue?

         

        Thanks,

        Abhijit

    • Subhash Valiveti

      Hi,

      We have a requirement to do allocations of the Budgets and Forecasting for our client in Cloud ERP

      The below note mentions that this functionality is not possible in the current date. Need a confirmation on the same and know if there are any workarounds. The client does not want to use EPM Cloud.

       

      How to Allocate Budgets in Fusion? (Doc ID 2204193.1)

      Regards,

      Subhash

    • Abhijit

      We do not support Allocation of Budget/Forecast balances using CalcManager. One can do the calculations offline in Excel and upload the allocated amounts directly during the Budget upload process to the GL Balances Cubes.

      Thanks,

      Abhijit

       

      • Subhash Valiveti

        Thank you Abhijit for the confirmation.

        We were toying with the idea of using the Scenario as a criteria for allocating the Budgets/Forecasts, as the Budgets/Forecasts are loaded to ERP as a scenario.

        We were not able put together how the budget allocations were going to make it to budgets as they cannot be posted as journal entries.

        Regards,

        Subhash

    • Abhijit

      You can Generate Allocations but with current implementation those will be processed as actual journal entries in the GL. The workaround I could think of is generate the allocations but do not post and export to excel the entries and later upload them as budgets.

      Thanks,

      Abhijit 

    • Subhash Valiveti

      Hi Abhijit,

      Thank you for the response and the workaround. Upon further analysis, we identified few open issues with the workaround suggested:

      1. We would not able to use the OOB 'Allocated Amount' or 'Total Allocated Amount' scenario if we use the scenario POV to generated the budget entries
      2. We have multiple levels of allocations required for Budgets and Forecasts. If we go with the workaround of generating the those entries as actual entries, we have to involve multiple levels of export to excel and deletion of those entries from GL interface which will defeat the clients requirement of simple, streamlined and automated allocations process
      3. Is there an API which we can use to create a ESS to extract these generated entries from interface and delete them?

      Regards,

      Subhash

    • Abhijit

      #1 I did not get your question. You can still do step down use cases using scenario as 'Allocated' for the source.

      #2 As stated you can have step down cases using the scenario member Allocated.

      #3 I do not think there is any such API.

       

      Thanks,

      Abhijit

       

      • Subhash Valiveti

        Hi Abhijit,

        Thank you responding to my comments/questions. Please find below my questions with more clarity

        1. If we wanted to generate allocations with step down approach where we use the allocated amount, how would we select 'Allocated Budget' amount where we can use either 'Budget' or 'Allocated' as the scenario? How can we use 'Allocated Budget' amount for step down allocation?

    • Pablo Schenquerman

      location Rule with multiple source parents and multiple offset Accounts

       

      Alocation Rule with multiple source parents and multiple offset Accounts

      Hello:

      Does anyone can share some print scrrens or PDF if you have a similar requirement

      I have a requirement to create an allocation rule where the source are multiple parent values from different segments and require multiple offset accounts as well

      Scenario

      Source Journal

      Segment 2- Account can have all values

      Segment 8 Market segment can have all values

                                                                                                                                                                              DEBIT          CREDIT     USD

      30000.615600.9999.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.     10,000.00
      30000.615500.9999.99999.CURRENTEXP.9999.99999.11.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.     40,000.00
      30000.615600.9999.99999.CURRENTEXP.9999.99999.99.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.     50,000.00
      30000.110003.9999.99999.CURRENTEXP.9999.99999.99.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.                        100,000.00

      Allocation range                                                                                                                           

      Based on STAT,

      Account 910410 (segment 2)

      Departmens: ALL (Segment 3)                                                                                                                                   

                                                                                                                                                                            DEBIT     STAT

      30000.910420.1400.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 6,000.00
      30000.910420.1410.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 2,000.00
      30000.910420.1415.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 3,000.00
      30000.910420.1430.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 1,000.00
       
      I have included the expected result as attachment
       
      Any help is appreciated