Unable to display Date column in the final PDF report output using bursting functionality — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to display Date column in the final PDF report output using bursting functionality

Received Response
21
Views
1
Comments

Summary

Unable to display Date column in the final PDF report output using bursting functionality

Content

Hello Friends,

I'm looking for help with displaying Date column on a RTF temple using XML bursting functionality. Please provide your inputs.

Issue description : I have report rdf which generates the XML output . I'm leveraging the bursting functionality to send the pdf o/p via email.

Everything works fine until I tried to add a new placeholder column which holds a Date value. I am able to generate the Preview in Template Viewer but when I run it via concurrent request , the bursting program errors out. When I remove the date columns from the rtf template the program completes just fine.

PROMISED_DATE and DT are both  Date types in the RDF

PROMISED_DATE and DT are both  Date types in the rtf Template with no formatting added .

Here's my snippet Sample XML file  output:

<CUSTOM_DATA>

                  <PROMISED_DATE>06-DEC-16</PROMISED_DATE>

                  <DT>08-DEC-16</DT>

                  <AMOUNT>30</AMOUNT>

</CUSTOM_DATA?

Please let me know if I need some conversion on date format to be rendered correctly at runtime .

Many Thanks

Answers