The excel being generated is in xls format.  Is because of the MS office version the format is giving issue ?  Which office version should I get for formatting to work ?

Also my BI publisher is bit diff than yours,  we are on R12.1 so I'm using BI publisher version 10.1.3.3.0.

I have the same issue can you help.

In RTF template I added column to show fiscal period but in the excel output the month is not uppercase.

xml tag :

         <START_DATE>2018-01-01T00:00:00.000-05:00</START_DATE>

         <FISCAL_PERIOD>JAN-18</FISCAL_PERIOD>

whereas the excel output is formatting and showing : 

I have tried using below formatting in the item but nothing helps.

<?xdofx:to_char(START_DATE,'MON-YY')?>

<?format-date:START_DATE;'MMM-YY'?>

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?FISCAL_PERIOD?></fo:bidi-override>

I would like the fiscal period column output in excel to show as JAN-18 same as what Oracle is generating the xml file.

I looked but could do not find it. I remember marking an answer correct for my another post some time back.

I was able to achieve the desired result by formatting in the sql query using to_char(date_allocated, 'MON-YY') fiscal_period and the excel shows in the desired format e.g., FEB-18

Mark ur respective correct answer as correct