0 Replies Latest reply: Jul 10, 2013 5:00 AM by 948169 RSS

    BI Publisher: how to format date on an xsl template

    948169

      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