Concurrent Request Parameter that uses SYSDATE using Submitted Date and not Run Date
Is there anyway other than to write a custom implementor function, to have a parameter that uses sysdate to calculate a filename (SELECT Payx_Utility.decode_lookup( 'PAYX_SERVICE_AWARDS', 'FILENAME' ) || TO_CHAR(sysdate,'YYYYMMDD') || '.csv' FROM DUAL) to calculate using the date the request is run as opposed to the submitted date? For example, if we schedule this program to run daily with the "recalc parameters" checked, and run this today, the filename = FILENAME20181116.csv, but since the concurrent manager submits the request for tomorrow right after todays run completes, tomorrow when it runs the filename is still the same because it is using the submitted date for the request and not the date that the process runs (i.e. should be FILENAME20181117.csv).