XDODTEXE: Data Template fails with java.lang.NullPointerException error (Doc ID 394864.1)

Last updated on JUNE 24, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.5 to 11.5 [Release 11.5]
BI Publisher (formerly XML Publisher) - Version 5.6.3 to 5.6.3 [Release 5]
BI Publisher (formerly XML Publisher) - Version 12.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 5.6 to 5.6.3
EXECUTABLE:XDODTEXE - XML Publisher Data Template


Symptoms

It is not possible to successfully generate an XML data file from a custom Data Template using XML Publisher. The XDO Data Engine fails with a java.lang.NullPointerException error.

Example of a Data Template that fails:

<?xml version="1.0" encoding="windows-1255" standalone="no"?>
<dataTemplate name="ReportXml" description="REPORTXML" version="1.0">
  <parameters>
    <parameter name="p_user_id" dataType="number" />
  </parameters>
  <dataQuery>
    <sqlStatment name="Q1">
      <![CDATA[
        SELECT REX.RESOURCE_ID,REX.SOURCE_ID,REX.USER_ID,REX.USER_NAME FROM
        jtf_rs_resource_extns rex
        WHERE rex.user_id=:p_user_id
        ]]>
    </sqlStatment>
  </dataQuery>
  <dataStructure>
    <group name="G_RESOURCE_ID" source="Q1">
      <element name="RESOURCE_ID" value="RESOURCE_ID" />
      <element name="SOURCE_ID" value="SOURCE_ID" />
      <element name="USER_ID" value="USER_ID" />
      <element name="USER_NAME" value="USER_NAME" />
    </group>
  </dataStructure>
</dataTemplate>


The Data Template is registered as a custom Concurrent Program in the Oracle E-Business Suite and makes use of the XDODTEXE executable. The Concurrent Request for this program will run in Error and the request log shows:

XDO Data Engine ver 1.0
Resp: 20420
Org ID : 204
Request ID: 3380192
All Parameters: p_user_id=1001237
Data Template Code: PB0031
Data Template Application Short Name: FND
Debug Flag: Y
{p_user_id=1001237}
Calling XDO Data Engine...
java.lang.NullPointerException
         at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:397)
         at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:281)
         at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:251)
         at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:192)
         at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:222)
         at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:334)
         at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:236)
         at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:272)
         at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

Changes

Created a custom Data Template.

Cause

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