Message templates that contain multiple lines are imported as one line

Document ID : KB000089611
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Message templates that contain multiple lines are imported as one line
Resolution:

Symptoms

When importing message templates inApplications Manager that have multiple lines, the entire message is wrappedinto one line but each of the lines are separated by a '\n' character insteadof a carriage return.


Cause

The SQL procedure used to import themessage templates was using the '\n' character as the line separator instead ofCHR(10), which was not being evaluated correctly during the import process.


Resolution

This issue was resolved with therelease of Applications Manger v8.0 SP5, (Fix 26359).


Workaround

Run the following SQL statement as theApplications Manager's Oracle userid to replace all '\n' characters in theaw_msg_template table with CHR(10).

updateaw_msg_template setaw_template_body=replace(aw_template_body,'\n',CHR(10));