Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    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
    How to extract Registration Number on OTBI?


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





    • 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.



    • Jairo Rojas Mendez