1 2 Previous Next 18 Replies Latest reply on Mar 1, 2017 3:43 PM by 3173025

    Need to schedule the concurrent program which automatically changes the date as per sysdate


      Hi Guys,


      I have concurrent program which is of SQL* loader that loads data from csv to staging table.


      Two parameters are there for the concurrent program

      1. Country (LOV- value set) - US/IN/CN/JP

      If US is selected then based on the value set value the file name is populated - file name parameter is of type sql statement with the value set

      file name will be like if the country is US

      2. file name: US_ONB_02202017.csv  -->(US_ONB_mmddyyyy.csv)


      Screenshot placed below

      Now if i schedule this program then this date in the file name should change everyday as per sysdate after scheduling.


      Please help me guys.


      Thanks in advance



        1 2 Previous Next