Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Ling Xiang
    R13 Financials OTBI subject area description documentation
    Topic posted August 4, 2017 by Ling XiangGold Trophy: 10,000+ Points, last edited June 14, 2018 by Veronica DumitriuSilver Medal: 2,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports 
    3706 Views, 4 Comments
    R13 Financials OTBI subject area description documentation
    R13 Financials OTBI subject area description documentation

    This documentation is published by Oracle OTBI development.  This document provides users a functional understanding of Financials subject areas - what they contain, key business questions that can be answered with the analyses built using the subject areas, the primary navigation paths in the application UI that contain information related to specific subject areas, and other useful information.  This document also contains information on the duty and job roles that provide access to each subject area.

    This document applies to Financials OTBI R13.



    • Chris Lloyd

      Thanks you, but Is there a subject area listing with attributes and measure for Release 13 ERP, please? :-)


      • Veronica Dumitriu

        Chris, please check the Data Lineage doc available here:

        • Chris Lloyd

          Excellent Thank you :-)

        • Chris Lloyd

          Hi Veronica, thank you again for this post, which has been very useful in analysing quite a complex OTBI analysis, using logical SQL to perform outer joins. I am struggling to locate a "Collections" Subject Area that functionally sits between Receivables and Payables. So we need to look at the Unpaid_Reason for an AR transaction. We have 1 version of the BI (using BI Publisher) and unpaid reason is located in the AR transactional database column - IEX_DELINQUENCIES_ALL.UNPAID_REASON_CODE. This is the only column that we cannot source from Subject Areas and our ideal solution would be to use the Analytical tables for the whole BI. So the question is "is there a Subject Area for collections that includes unpaid reason code?

          Thank you in advance Chris :-)