Oracle Fusion BI Publisher: Bursting Query does not render carriage return in the Message Body
Last updated on JANUARY 11, 2018
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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.
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