My Oracle Support Banner

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


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">
    <parameter name="p_user_id" dataType="number" />
    <sqlStatment name="Q1">
        jtf_rs_resource_extns rex
        WHERE rex.user_id=:p_user_id
    <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" />

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
Calling XDO Data Engine...
         at oracle.apps.xdo.dataengine.XMLPGEN.writeData(
         at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(
         at oracle.apps.xdo.dataengine.XMLPGEN.processData(
         at oracle.apps.xdo.dataengine.XMLPGEN.processXML(
         at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(
         at oracle.apps.xdo.dataengine.DataProcessor.processData(
         at oracle.apps.xdo.oa.util.DataTemplate.processData(
         at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(
         at oracle.apps.fnd.cp.request.Run.main(


Created a custom Data Template.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.