This content has been marked as final. Show 2 replies
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 ?