Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Ling Xiang
    R13 Financials OTBI subject area to database lineage mapping...
    Topic posted August 4, 2017 by Ling XiangGold Trophy: 10,000+ Points, last edited October 31, 2019, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports 
    12546 Views, 33 Comments
    R13 Financials OTBI subject area to database lineage mapping spreadsheet
    This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security.

    This spreadsheet is published by Oracle OTBI Development.  This spreadsheet documents Fusion Financials OTBI subject areas, the corresponding View Objects and database tables and columns.  Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.  

    This spreadsheet also documents subject area security duty roles and job roles.

    The spreadsheet applies to Financials R13. 


    • Senthilrajan Vaithianathan


      Do we have the Data Lineage, Subject Area, Report list document for 19D release for Fusion ERP?


    • Kateryna Jastrebowa


      Can you please also add documentation for 19D?

      Thank you very much in advance!

      With regards,


      • Senthilrajan Vaithianathan

        Hi Katia,

        Refer below links,

        It does not have the database lineage mapping.


    • Ian Taylor


      I may be mistaken, but I do not see the physical database table GL_DAILY_BALANCES (Period Aggregates for deriving Averages) exposed in any General Ledger PVO. Is this on the roadmap? If so can you signpost when it might be available?

      We are Fusion R13 19D customer

      Guidance appreciated....

      • Veronica Dumitriu

        Currently, there is no PVO based on GL_DAILY_BALANCES. We are considering creating a new subject area based on Essbase cube Daily Average Balances, to provide real-time information on general ledger average and ending daily and monthly balances. Please let us know your specific requirements on Idea labs and specify the business impact so that the PM team would evaluate and prioritize adding this to the roadmap.

    • Pawan Gupta

      why do we have duplicate rows in the lineage doc, example "Invoice Description" for subject area Payables Invoices - Transactions Real Time, can anyone educate me?

      • Veronica Dumitriu

        There are different PVOs on the same base table and you'll see an entry in the csv for each of the PVOs used in the Physical model where the column is present.

        • Pawan Gupta

          could you explain what i need to do if i were to match the columns i see in OTBI new analysis page to data lineage. I see only one "Invoice Description" field in the new analysis page in Fusion OTBI.