2 Replies Latest reply on Sep 16, 2016 3:17 PM by RameshPatel

    SQL to default Request Id on a Concurrent parameter

    user11145680

      Hi,

       

      We created created a custom request in Receivables to monitor receipts on a staging table that are processed each day via an Interface. The parameter on the report is Request Id (from a value set RCP_REMIT_SRS_REQID). The User  has to run the report each day becasue they have to go into the Request Id parameter and select the latest Request Id. Is there a SQL that can be created that will default the latest request id that was populated from the value set so we can schedule the report to run each day ?

       

      thank you