This discussion is archived
0 Replies Latest reply: Jul 10, 2013 3:00 AM by 948169 RSS

BI Publisher: how to format date on an xsl template

948169 Newbie
Currently Being Moderated

Using a xsl templates to generate report output to excel (xls). One of the functions that I've tried is format-date:


<P_START_DATE>2013-05-01T00:00:00.000+08:00</P_START_DATE>


<Row ss:AutoFitHeight="1">
  <Cell>
    <Data ss:Type="String"><xsl:value-of select="format-date(.//P_END_DATE,'[D01]-[MN,*-3]-[Y0001]',)"/></Data>
  </Cell>
</Row>


expected output : 01-MAY-2013


exception returned:

[UNEXPECTED] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:611)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:239)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:6032)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
Caused by: oracle.xdo.parser.v2.XPathException: Function 'format-date' not found.
at oracle.xdo.parser.v2.XSLProcessor.reportException(XSLProcessor.java:806)
at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:571)
... 12 more

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points