Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Ling Xiang
    R12 ERP OTBI subject areas to database tables mapping...
    Topic posted March 30, 2017 by Ling XiangGold Trophy: 10,000+ Points, last edited April 14, 2017, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip 
    7734 Views, 10 Comments
    R12 ERP OTBI subject areas to database tables mapping spreadsheets
    R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheets

    These spreadsheets are published by Oracle OTBI Development.  These spreadsheets document Fusion Financial and Supply Chain Management OTBI subject areas and the corresponding View Objects and database tables and columns.  Customers can use these spreadsheets to search for reporting fields in OTBI subject areas or trace the lineage from subject areas to database tables, columns and view objects or vice versa.  

    The spreadsheets apply to Fusion ERP and SCM Release 12.

    Please note In R12 users can search for a field in a subject area in OTBI.



    • Soumya Parhi

      A great input that definitely helps in OTBI Reporting



      does anyone has the OBIA subject area mapping? i.e. none realtime ones



    • Jason Eggers

      Is there an RPD file that can be viewed in BI admin tools. It would give more visibility into the business model mapping layer and find out the key constraints, logical joins, etc.

      Thank you!!

    • Richard Chan



      I'm a bit confused are you asking for a sample rpd file as the Admin Tool only works on RPD files, so open your current <file>.rpd file, if you don't have it then copy it down from the BI Server commonly found in the \Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

    • MShrini

      Thanks for sharing the OTBI subject areas mapping file. It will be really useful.



      M Srinivasu.

    • Wendy Ware

      This mapping is great but there is one edit I would suggest:  A number of the FA subject areas were eliminated in Rel12.


      Oracle Financials Cloud Release 12 What's New
      Usability Improvements for Assets

      Assets subject areas for depreciation and asset transactions have been redesigned to better support the creation of asset reports. Asset analysis functionality has been consolidated into two subject areas.


      The following subject areas are no longer available for building new ad hoc reports.
      •Fixed Assets - Asset Assignments Real Time
      •Fixed Assets - Asset Balances Real Time
      •Fixed Assets - Asset Financial Information Real Time
      •Fixed Assets - Asset Retirements and Reinstatements Real Time
      •Fixed Assets - Asset Source Lines Real Time
      •Fixed Assets - Asset Transfer Real Time

      The two remaining two subject areas now contain all functionality for asset reporting and analysis.

      • Fixed Assets - Asset Depreciation Real Time

      • Fixed Assets - Asset Transactions Real Time

    • Siva Kumar

      Thank you very much :) 

    • Animesh Agrawal

      Thanks a ton Ling,

      Is there a way to get these mapping files on a regular basis? can you share the path OR source how to search on our own incase required.


      Thanks in advance.



    • Animesh Agrawal

      Hi Ling,

      seems some R12 Subject area have changed since the attached version, is it possible to have latest one for R12.




    • Manikantan Surendran

      Hi Experts,


      need the ITD actual cost and PTD actual cost table list  from the PPM in the Review project performance