How to append next sequence number with Oracle Extract generated File Name to integrate with SdWorx
Currently we are trying to integrate from Oracle to SD Worx for Belgium Payroll.
Sd Worx requirement is to generate sequence number and append it with file name (ex:FileName_1.csv) which comes from Oracle. This sequence number is nothing but the count of each successful run in Oracle +1 .
Is there any way we can handle it with in extract?
Please note ,it is a changes only extract and SD Worx wants even if the file is empty ,it should follow the same naming format i.e FileName_next seq number.csv.
We tried handling it through Fast Formula however whenever there is no change in Oracle ,the extract fast formula didn't execute for which extract unable to generate naming format in the required manner.