What's new in Customer Journeys?

Connect and learn more! ×
How to append next sequence number with Oracle Extract generated File Name to integrate with SdWorx — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to append next sequence number with Oracle Extract generated File Name to integrate with SdWorx

Received Response
22
Views
2
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!