My Oracle Support Banner

Oracle Fusion BI Publisher: Bursting Query does not render carriage return in the Message Body (Doc ID 2347808.1)

Last updated on FEBRUARY 04, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.