Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Aaron Leggett
    How to extract Registration Number on OTBI?
    Topic posted June 12, 2017 by Aaron LeggettGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports 
    124 Views, 2 Comments
    Title:
    How to extract Registration Number on OTBI?
    Content:

    Hi

    I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'First-Party Tax Registration Number' and 'Supplier Tax Registration Number'. However, both options return no results. I have attached a screenshot of what we need to extract below. I know that the Registration number in the image is blank, but we are under the impression that it should just return a null value (rather which it just produces an error in the report). 

     

    Image:

    Comment

     

    • Antony Hooper

      The following works for me:

      Use the 'Supplier - Supplier Real Time' subject area, and add 'Supplier Profile.Supplier Name' and 'Income Tax.Tax Registration Number' to the analysis.  If the field is populated, it will show in the dataset.

      Thanks,

      Antony.

    • Jairo Rojas Mendez

      Great!smiley