Hi Community,
We have created a transform map to insert data into the sys_user table. We use a flow designer to fetch data through integration and insert it into the import set table. Once the data is inserted, we trigger the transform map using the function transformImportSet from the script include ImportSetUtils.
However, after the transform is completed, we noticed that a few fields (for example, Manager (Reference field)) are not getting updated with the value we have in the import set table. Instead, the original values for those fields are being removed and set as empty.
Interestingly, if we reprocess the same import set and manually transform it, all fields are updated with the correct value without any error.
Can anyone please help me figure out why this is happening?
Thank you.
