Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Concurrent Request Parameter that uses SYSDATE using Submitted Date and not Run Date

edited Dec 10, 2018 4:01AM in Core Concurrent Processing - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center