Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Nathanael Dryden
    Prompt Variables Not Being Passed
    Topic posted August 23, 2019 by Nathanael Dryden, last edited August 26, 2019, tagged Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, OBI Answers, OTBI, Reports 
    Prompt Variables Not Being Passed
    Selections from Prompt variables are not passed

    I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas, "Payables Invoices - Transactions Real Time" and "Procurement - Procure To Pay Real Time." In order to provide for user input I have included several prompts in the query with are then referenced as Request Variables in a Prompt built within OTBI. SQL is attached. Unfortunately, when I select an item from the Prompt list, the value does not get passed through to the query (as validated by reviewing the result set and the Manage Sessions screen).

    Code Snippet: