Oracle Fusion BI Publisher: Bursting Query does not render carriage return in the Message Body

(Doc ID 2347808.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Technology Management - Reports/Analytics

You used to have an email delivery bursting query that includes a message body (Parameter5) where you add chr(13) to set a newline.

For example the content in Parameter5 was like:

'Dear' || ' '||PPNFV.DISPLAY_NAME || ',' || chr(13) || ''||chr(13) ||

'This is a test' || chr(13) || 'Thank you'

This used to work until your environment was patched with the Dec-2017 P4FA patch bundle.

Now the body message is showing all in one line.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms