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

EPM Integration Agent Write back only to comma seperated format?

Summary:

Hello,

We are running a writeback job using EPM integration agent from EPM to Oracle database.

We see that Data exchange creates an output after validation in a csv format and then inserts the data from comma seperated file to oracle Database using the insert query.

We have issues with the comma delimeter when for example a name field have comma in the text, then it does not insert the data correctly.

Do we have any options to change the delimeter when creating the output file before inserting? Or Should the output file creation job in background put double quotes in the text where it is comma?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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