Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to append next sequence number with Oracle Extract generated File Name to integrate with SdWorx
Hi All,
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.
0