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

    3173025

      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

      Rayudu

       

        1 2 Previous Next