Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Lydibel Murillo
    SQL Table to bring in Audited by from the AP module to a BI...
    Topic posted October 21, 2019 by Lydibel Murillo, tagged BI Publisher 
    64 Views, 2 Comments
    Title:
    SQL Table to bring in Audited by from the AP module to a BI report
    Summary:
    SQL Table to bring in Audited by from the AP module to a BI report
    Content:

    I am searching for the SQL table to bring in Audited by from the AP module to a BI report.

    Comment

     

    • Glen Ryen

      Hi Lydibel,

      That's a DFF (Descriptive Flexfield) that you've set up on the AP Invoice header, so it would be stored in an attribute column of the AP_INVOICES_ALL table.  You'll have to look at your DFF setup to find out exactly which attribute.  But that's also a custom report you've got there, so you'll first need to determine if the report is written in OTBI or BI Publisher.  Do you know how it was coded?  What do you see in the BI Catalog for that object?

      Glen

    • Amitabha Dutta

      Please check the ap_invoices_all attribute values, these are DFF as defined in the environment.