There are usually multiple OPP logs as there are usually more than one running at the same time,

so check all the files. I expect it is an empty file error: "Start of root element expected".

Because the error in the program is fatal:.

Calling XDO Data Engine...

java.lang.ArrayIndexOutOfBoundsException: -16

    at oracle.sql.LnxLibThin.lnxnuc(LnxLibThin.java:6068)

    at oracle.sql.NUMBER.toText(NUMBER.java:2682)

Run the program with DebugFlag = Y, it should provide more details.

Kevin

Hi Kevin

I checked the OPP log and below issue is shown:

[7/24/14 2:16:57 AM] [OPPServiceThread1] Post-processing request 34514585.

[7/24/14 2:16:58 AM] [411506:RT34514585] Executing post-processing actions for request 34514585.

[7/24/14 2:16:58 AM] [411506:RT34514585] Starting XML Publisher post-processing action.

[7/24/14 2:16:58 AM] [411506:RT34514585]

Template code: AEXPESSSTATPFTLDREP

Template app:  AEXP

Language:      en

Territory:     US

Output type:   EXCEL

[7/24/14 2:16:58 AM] [UNEXPECTED] [411506:RT34514585] 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:585)

    at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:570)

    at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:235)

    at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)

    at oracle.apps.xdo.template.excel.ExcelController.processActionLanguage(ExcelController.java:337)

    at oracle.apps.xdo.template.excel.ExcelController.process(ExcelController.java:241)

    at oracle.apps.xdo.template.ExcelProcessor.process(ExcelProcessor.java:245)

    at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:6159)

    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3458)

    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3547)

    at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:282)

    at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:172)

Caused by: org.xml.sax.SAXParseException: <Line 6, Column 1>: XML-20210: (Fatal Error) Unexpected EOF.

    at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java:441)

    at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:303)

    at oracle.xdo.parser.v2.XMLReader.popXMLReader(XMLReader.java:530)

    at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1312)

    at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)

    at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)

    at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)

    ... 15 more

[7/24/14 2:16:58 AM] [411506:RT34514585] Completed post-processing actions for request 34514585.

[7/24/14 2:27:45 AM] [OPPServiceThread2] Post-processing request 34514587.

[7/24/14 2:27:45 AM] [411506:RT34514587] Executing post-processing actions for request 34514587.

[7/24/14 2:27:45 AM] [411506:RT34514587] Starting XML Publisher post-processing action.

[7/24/14 2:27:45 AM] [411506:RT34514587]

Template code: AEXPESSSTATPFTLDREP

Template app:  AEXP

Language:      en

Territory:     US

Output type:   EXCEL

[7/24/14 2:27:48 AM] [411506:RT34514587] XML Publisher post-processing action complete.

[7/24/14 2:27:48 AM] [411506:RT34514587] Completed post-processing actions for request 34514587.

7920K->56626K(153380K), 0.0213920 secs]

[GC 99058K->57771K(153380K), 0.0239190 secs]

[GC 100203K->58908K(153380K), 0.0203010 secs]

[GC 101340K->60062K(153380K), 0.0206090 secs]

[GC 102494K->61013K(153380K), 0.0211130 secs]

Is it possible to investigate on the basis of this information ?

Regards,

Amit

This is pretty much the same basic error: the base program failed after starting to write the file.

So the issue is your Data Template extract.

Run the program with DebugFlag = Y, it should provide more details in the request log.

You can also test your queries using SQL Developer.

Kevin