Get Involved. Join the Conversation.


  • Arun Raj

    I believe the following are available out of the box right now:

    • Oracle ERP Cloud (Payables Transactions)

    • Oracle ERP Cloud (Receivable Transactions)

    • Oracle ERP Cloud (Trial Balance - Average)

    • Oracle ERP Cloud (Trial Balance)

    If the above don't meet your needs, then you can use the Generic Cloud Adapater to load data from a BI Publisher report.



  • Lydia Maksoud

    Hi Joseph,

    Are you attempting to retrieve General Ledger data only from the subledger? If so, you can use the standard Oracle Financials Cloud data management connection here:

    Hope that helps,


  • Mónica Gonçalves

    I was pretty sure that wpuld be the answear,

    Thank you anyway.


  • Matt Treml

    In the transfer out it does appear that the compensation is just copied from the source cost center to unspecified entity. Though you wouldn't have any rates or anything else setup on this entity so you wouldn't want to modify anything while it's in this transfer state. 

    I believe as a best practice the purpose of the transfer out/in was created to enable transfers across cost centers where the person transferring doesn't have access to the source cost center. So from a business process this should be coordinated between the 2 planners of transfer out/in within a short time period. I don't think you'd want to bring over the amounts sitting on unspecified in financials as the rollup of costs wouldn't go up the hierarchies.

    What's the business case that you want to leave the positions in the unspecified cost center?



  • Raju Naidu

    Hi Luis,

    Thanks for your time in looking into this and replying.
    I am trying to write a script so that when I save the webform,the calculation runs only for the rows which have been changed. Basically its a calculation like 
    Amount = Units * Price.
    Because I have lot many items it takes a long time to run the query. I know how to manage that in BSO , but ASO is where I am struggling with.
    Any help you can provide is highly appreciated.


  • Joseph Ip

    I don't think there is any automate migration tool for Web Analysis.  The only thing you can do is to recreate the Web Analysis information with PBCS Dashboard.

  • Muthu Ranganathan

    Hi Lesa,

    Forecast version is seeded with actuals every month as through the Prepare Forecast rule. Prepare Forecast rule does the following:

    - Copies data to prior forecast version

    - copies selected month of actual to forecast

    - recalculates

    We didn't want to seed the plan to forecast by default but agree it could be made available through an out of box rule as an option. Do log that in ideas lab



  • Sudhakara Reddy

    It is possible in the same way you would migrate dashboards via LCM. Infolets Pages appear under Global Artifacts -> Dashboards folder.

  • Ravijyot Kaur

    Have you modified the substitution variable OEP_YearRange for the cube OEP_WFP to cover the years for both plan and forecast scenarios? We are working on an enhancement to deliver this in next few months.

    Regarding your question, restore of these templates should not cause the issue mentioned.

  • Lesa Muir

    Hey Lawrence

    Thanks for that, good to know I wasn't missing something, Pete has helped me create a custom rule where we are copying the plan in for future periods and the actuals in for prior periods.

    Great to meet you too!



  • Law

    Hi Lesa,

    Last I checked there are no rules to pre-populate Forecast with plan (surprisingly). There is a rule to pre-populate Forecast with Actuals (Prepare Forecast). We handled this requirement through a custom business rule that just pre-populated the first Forecast month with Budget. 

    Moving forward the planners were just using the OOTB prepare forecast rule to seed OEP_Forecast->OEP_Working with actuals.


    p.s. Nice meeting you last week



  • Luis Autrique

    Hi Raju,

    The script builder is used to produce a script that will execute against a BSO cube. ASO doesn't have the same functionality.

    That being said, you can accomplish similar things using a combination of GridDefinitionBuilder and/or GridBuilder to read/write data to/from the ASO cube.

    If you can describe what you want to accomplish it may help to provide more focused guidance.





  • HL1

    Hey Brains Trust :), I am trying to get the correct number in the red highlighted cell below (132). In Excel l get this with =SUMPRODUCT(D4:D11,G4:G11) but I can't find a way to get the second dimension (Employee Type) into the formula below, any suggestions please?

    "FTE x Rate" = @CalcMgrExcelSUMPRODUCT(@LIST(@DESCENDANTS("All Jobs")->"Employee Type"->"FTE"),@LIST(@DESCENDANTS("All Jobs")->"Employee Type"->"Base_Rate"->"BegBalance"));

        Assumptions Assumptions Assumptions

        Pay Frequency Base Rate ($) Shift Loading (%) FTE x Rate FTE
    Manager - Day Permanent Weekly 53 #Missing #Missing 2
    Supervisor - Day Permanent Fortnightly 26 #Missing #Missing 1
    Operator - Day Permanent Weekly 26 #Missing #Missing #Missing
    Operator - Day Casual Weekly 36 #Missing #Missing #Missing
    Maintenance - Day Permanent Monthly 40 #Missing #Missing #Missing
    Apprentice - Day Permanent Weekly 32 #Missing #Missing #Missing
    Operator - Afternoon Permanent Weekly 53 15% #Missing #Missing
    Supervisor - Night Permanent Fortnightly 26 30% #Missing #Missing
    All Jobs Employee Type #Missing 292 #Missing #Missing 3
    No Job No Employee Type #Missing #Missing #Missing   132 #Missing


  • Mark Rinaldi

    My pleasure.  Happy (Workforce) Planning!  :-)

  • Yu Zeng

    Thank you so much! Have a great day!