Tuesday, January 4, 2022

OIC - Add Header or line file field names with easy method

Sometimes when we send FBDI files to ERP/HCM or other applications, we may also need to share the header or line field names to the file itself. To add huge number of field names manually is a hectice process. But there is option to easily we can add the field names. See thr below steps.

Steps:

Step1: Take a stage activity and write file operation and privide file name, virtual stage directory and select append to existing file.


Step2: provide a sample csv file with one field name and select Use first row as column headers.


Step3: add all the fields as comma separated within double quotes to target field .

And its done.

No comments:

Post a Comment

Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...