Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    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 
    12165 Views, 33 Comments
    Title:
    R13 Financials OTBI subject area to database lineage mapping spreadsheet
    Summary:
    This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security.
    Content:

    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. 

    Comment

    • Soumya Parhi

      It's awesome ! Thanks a bunch .

    • Callen Raveret

      Does there exist the same document for Procurement subject areas in R13?

      • Vikram Agarwal

        Hi Callen,

        PFB the URL for R12.

        https://cloudcustomerconnect.oracle.com/posts/c7acda6e57

        Regards,

        Vikram

        • Callen Raveret

          Hi Vikram,

           

          Thanks for sending. I have located the R12 Procurement subject areas but cannot find the R13 procurement subject areas. Do you know where I can go to find the R13 OTBI subject areas for Procurement? All I have found are Financials, Fixed Assets, and HCM.

           

          Thanks,

          Callen

          • Vikram Agarwal

            Hi Callen,

            I am also looking for the same. Will update the post if I come across any such documentation.

            Regards,

            Vikram

          • Katha Ray

            Hi Callen,

            Can you please provide the link to HCM subject area documentation?

            Thanks,

            Katha

    • Callen Raveret

      Ling,

      I have located the R12 Procurement subject areas but cannot find the R13 procurement subject areas. Do you know where I can go to find the R13 OTBI subject areas for Procurement? All I have found are Financials, Fixed Assets, and HCM.

       

      Thanks,

       

      Callen

    • Ling Xiang

      R13 Procurement subject area docs are posted in the SCM & Procurement reporting forum:

      R13 SCM and Procurement OTBI subject area Description documentation

      R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet

      Ling

       

       

    • Ling Xiang

      All OTBI subject area documentation including the spreadsheets are also posted in Oracle Help Center under 'Analyze and Report' for each product family.  This is the link for SCM OTBI Help -> https://docs.oracle.com/en/cloud/saas/supply-chain-management/r13-update17d/analyze-and-report.html

      Ling

    • Subhash Valiveti

      Thanks a lot for this document.

    • Mark Mesias

      This is helpful. May I also know where to download for the updated HCM subject area to database lineage mapping spreadsheet?

    • Chris Lloyd

      I have 2 questions - one I posted on an old OTBI post, so now hopefully posting on the correct thread :-)

      Comment 1 – Unpaid Reason Code

      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 :-)

       

       

      Comment 2 – Missing attributes in Fixed Assets

      I couldn't see these columns listed, which are in the "Fixed Assets - Asset Balances Real Time" Subject Area

      Subject Area

      Folder

      Attribute

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Additions

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Adjustments

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Beginning Balance

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Depreciation

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Ending Balance

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Impairment

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Reclassifications

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Retirements

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Revaluation

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Transfer

         "Fixed Assets - Asset Balances Real Time"

      Asset Account Balances Amounts

      Unplanned Depreciation

       

      Is there a way that I can generate this attribute listing myself to get the most up-to-date information?

      Here are the versions that we are running:-

      OBIEE Version

      Oracle Business Intelligence 11.1.1.9.0

      Oracle Cloud Application

      Revision 13.18.05 (11.13.18.05.0)

      Many thanks, Chris :-)

       

      • Veronica Dumitriu

        Hi Chris,

        Collections subject area is on our roadmap. The AR fields you have referenced will be included in the respective scope.

        For the Fixed Asset columns you have signaled, this seems to be a documentation bug which has been forward ported in 18C documentation as well. We will investigate and correct this at the earliest.

        regards,

        Veronica

      • Veronica Dumitriu

        Hi Chris,

        We have addressed the missing columns you have signaled and the fix will be available in 19.04 data lineage doc. It was due to the fact that derived fields (fields not directly mapped from Fusion table columns) were not captured in the lineage document.

        Thank you for your feedback, it helps us improve the products and documentation that we are producing.

         

        Veronica

    • Maruti Bhanot

      Great post Veronica, thanks!

       

      Maruti

    • Siva Kumar

      Can you please share for R13 18 C as well ?

      Thanks

    • Callen Raveret

      Can you please share and upload R13 19A when possible?

       

      Thanks

    • Faye Karas

      I an not able to locate these columns in Oracle, which are in the "Fixed Assets - Asset Transactions Real Time" Subject Area.  We are on R13 19A.  Please assist.

      SUBJECT_AREA PRESENTATION_TABLE PRESENTATION_COLUMN
      Fixed Assets - Asset Transactions Real Time Asset Transaction History After Cost Amount
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Apps Local Currency Code
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Before Cost Amount
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Amortization Start Date
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Destination Asset Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Invoice Transaction Type
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Asset Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Type
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Type
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Type Code
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Key
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Name
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Sub Type
      SUBJECT_AREA PRESENTATION_TABLE PRESENTATION_COLUMN
      Fixed Assets - Asset Transactions Real Time Asset Transaction History After Cost Amount
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Apps Local Currency Code
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Before Cost Amount
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Amortization Start Date
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Destination Asset Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Invoice Transaction Type
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Asset Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Type
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Type
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Source Transaction Type Code
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Key
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Name
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Number
      Fixed Assets - Asset Transactions Real Time Asset Transaction History Details Transaction Sub Type
    • Veronica Dumitriu

      R13 19B Fin OTBI Data Lineage doc uploaded

    • Veronica Dumitriu

      R13 19C Fin OTBI Data Lineage doc uploaded

    • Madhu Babu Vitta

      Very Useful one.

      Thanks!