Comments

  • 1-10 of 10
  • Andy Gough

    The short answer is No. 

    OBIA is a separate data warehouse-based reporting environment into which the standard ETL processes pull data from across the ERP suite and beyond.

    FR in Financials Cloud is a very powerful tool for reporting on Financial Balances held in real-time in the Essbase cube that is built-in to the GL. FR is great for Financial Statements and other reports based on GL Balances (Actuals, Budgets etc). It also provides drill-down to associated journals and subledger transactions. BUT, FR only works with the Essbase Balances data, so you can't for example, write an FR report to show the list of Invoices for a given supplier, or the current aged debt position.

    Financials Cloud also contains a more general BI facility known as OTBI, which is based on the same OBIEE technology traditionally used in OBIA. OTBI provides real-time reporting and dashboarding capability across all areas of the Cloud ERP and HCM suite. You may well find that some of the reports you used to create in OBIA can now be created in OTBI, with the added benefit that they'll report real-time data, rather than relying on an overnight refresh of the data warehouse.

    However, there are some use-cases where OBIA is still the best product for your requirement. Examples include reports that need data from multiple sources, both within and outside the ERP system, reports that need to include historical snapshots (e.g. "How does the current debt aging for my customer compare to the position this time last year?"), or reports that require heavy duty data processing (e.g. Procurement Spend Analysis). In all of these use-cases (and others) the data warehouse that underpins OBIA allows it to do things that OTBI can't do (or can't do easily).

    My advice then is to use the right tools for the right job: FR for real-time (and static) Financial Reports and Statements (P&L. Balance Sheet, Cash Flow etc), OTBI for real-time performance monitoring, exception reporting and process management, and OBIA for more strategic analysis of trends, correlations and aggregated multi-source data. OBIA can now be deployed on BI Cloud Service or Analytics Cloud as well as on-prem OBIEE12c, so you can also take advantage of the new "Data Visualization" capability in those platforms, which is fantastic, and isn't available in OTBI.

    Hope that helps.

    Andy

     

  • Andy Gough

    Hi Matt,

    You can get close to that in OTBI using the "Subledger Accounting - Journals Real Time" subject area, but I don't think you can get the balance information that way - might need a custom BIP report.

    See attached for my quick attempt based on your spreadsheet - you might be able to build on it.

    Andy

  • Andy Gough

    Nice report - thanks

  • Andy Gough

    Hi Matt,

    As you probably know, there is a standard AP Aging report you can run from the Scheduled Processes window - it's called "Payables Invoice Aging Report".

    The advice you received was correct though - the report shows the AP Aging position as it is at the time you run the report. As far as I know, we don't store historical snapshots of AP balances/aging so it's not possible to view the Aging position as it was at previous points in history. Unless you could do something clever with Due Dates and Payment Dates in OTBI, I think you'd need to use something like BI Cloud Service to routinely collect the current aging position (e.g. via an OTBI report) and store it for historical/trend reporting.

    Regards,

    Andy

  • Andy Gough

    Hi Matt,

    See if you can import into your "My Folders" folder in the catalog - it might just be that you don't have write access to the folder you're trying to import into.

    If that doesn't help, it's probably down to your roles - I think you need to have the BI Administrator role to use Import/Export. See https://docs.oracle.com/cloud/farel9/common/OCHRA/F1518712AN10625.htm#F1228884AN10A69 for info.

    Regards,

    Andy

     

  • Andy Gough

    Hi Virginia.

    Requestor info is held at PO distribution level, since multiple requisitions may have been combined on the same PO. In the "Open Purchase Order Report - Distribution Level" version of the report, you can add requestor. In the subject area, look under Purchase Order Distributions -> Purchase Order Distribution Detail -> Requester -> Purchase Requester Name.

    Adding Receipt Date and Invoice details is not possible since this report is based on the Purchasing Subject Area, which doesn't include Receipt and Invoice information. It's not a trivial thing to add, since there may be multiple receipts and multiple invoices matched against the same PO.

    Regards,

    Andy

  • Andy Gough
    Thanks! I'll give that a try.
    
  • Andy Gough

    Yes, that is a problem. Not sure what else to suggest - use an FR report instead maybe?

    A

  • Andy Gough

    Hi Angel,

    The nearest I've come to a suggested workaround is to use a Union report to join the "General Ledger - Balances Real Time" and "General Ledger - Transactional Balances Real Time" subject areas. The latter has segment descriptions, but only for the posting-level values, not for the hierarchy levels.

    Andy

  • Andy Gough

    Ooops! Sorry - my mistake. They're attached now.