Accounts Payable Trial Balance Report Completed With Error: java.lang.NullPointerException in Log File

The job was completing in error and no XML output is generated.

Error:

Calling XDO Data Engine...

java.lang.NullPointerException

at java.io.RandomAccessFile.<init>(RandomAccessFile.java:233)

at java.io.RandomAccessFile.<init>(RandomAccessFile.java:122)

at oracle.apps.xdo.dataengine.ScalableStringList.initSessionIfNecessary(ScalableStringList.java:53)

at oracle.apps.xdo.dataengine.StringList.<init>(StringList.java:51)

at oracle.apps.xdo.dataengine.ScalableStringList.<init>(ScalableStringList.java:40)

at oracle.apps.xdo.dataengine.StringList.createStringList(StringList.java:43)

at oracle.apps.xdo.dataengine.DataGroup.initDataGroupProps(DataGroup.java:86)

at oracle.apps.xdo.dataengine.DataTemplateParser.groupParser(DataTemplateParser.java:768)

at oracle.apps.xdo.dataengine.DataTemplateParser.dataStructureParser(DataTemplateParser.java:727)

at oracle.apps.xdo.dataengine.DataTemplateParser.templateParser(DataTemplateParser.java:313)

at oracle.apps.xdo.dataengine.XMLPGEN.setDataTemplate(XMLPGEN.java:140)

at oracle.apps.xdo.dataengine.DataProcessor.setDataTemplate(DataProcessor.java:193)

at oracle.apps.xdo.oa.util.DataTemplate.<init>(DataTemplate.java:231)

at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:283)

at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Solution:

BI Publisher code the default temp directory specified in the options on the screen cannot be used in all cases.

Update the xdo.cfg under $AF_JRE_TOP/jre/lib or $AF_JRE_TOP/lib.

1. Add this property:

</properties>

2. Re-run report again

If you like please follow and comment