Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    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 
    30 Views
    Title:
    Prompt Variables Not Being Passed
    Summary:
    Selections from Prompt variables are not passed
    Content:

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

    Version:
    11.1.1.9.0
    Code Snippet: