XML output error

Tanvi Singh

Summary

XML output error

Content

hi,

I am trying to create a xml report and though my short code and code name is same also in same case yet im getting the below error.

Any help is appreciated.

Calling XDO Data Engine... java.lang.NullPointerException at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:480) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294) at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

Regards,

Tanvi Singh

Brajesh Shukla-95078

How you are generating your XML?

Venkat Thota - BIP

please post how you are generating xml data ? are you using standalone BIP or from EBS environment ?

also what about your source type ? Thanks

Brajesh Shukla-95078

Looks like this is the problem while generating the XML file...please check the code which generates the XML file...

Brajesh Shukla-95078

You can verify these three things

1. There is no template define for that XML in XML Administrator, you can verify this by checking the Option of the concurrent request, it will show the template name if it picked. If its blank it means template is not getting picked up.

                  

2. Output Post Processor is Down : Output post processor is concurrent manager which map the XML data with rtf, if that is down then also you may get this error. Please verify some other XML report if that works it means OPP is up and running, if no then check with DBA team.

3. XML data file has some junk characters, you can download the XML by click on Request id > Diagnostics > View XML and save the XML as .xml extension and then Open the file in IE or Mozilla if  there is any issue or special characters are there browser will point out that character. And once you fix that character XML will appear correctly in browser

Brajesh Shukla-95078

Both the log file attached is pointing to two different error

1. First Log : (Calling XDO Data Engine... java.lang.NullPointerException at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:480) a)

                  In this issue XML data is not generated, please check the Code (e.g. Data Template code, Report Code or Package) through which XML file is getting generated

2. Second Log : Output Post Processor

                   This error appears when XML is generated(you can verify this by click in request id Diagnostics > View XML ) and that XML did not map to rtf template due to some reason, reason can be

                   1. There is no template define for that XML in XML Administrator, you can verify this by checking the Option of the concurrent request, it will show the template name if it picked. If blank it                         means template is not                               getting picked up

                    2. Output Post Processor is Down : Output post processor is concurrent manager which map the XML data with rtf if that is down then also you may get this error. Please verify some                                 other XML report if thats                         working it means OPP is up and running if no then check with DBA team.

                    3. XML data file has some junk characters, you can download the XML by click on Request id > Diagnostics > View XML and save the XML as .xml extension and then Open the file in IE or Mozilla if  there is any issue or special                          characters are there browser will point out that character. And once you fix that character XML will appear correctly in browser 

Tanvi Singh

hi Brajesh,

Please ignore my initial attachment. I have resolved that error.

Now after attaching template when i run the concurrent program it completes in warning and below is the error i get.

Regards,

Tanvi Singh

Tanvi Singh

hi,

I was able to generate the XML now now i am getting post processing error.

Regards,

Tanvi Singh

Jana Vakati

As mentioned in the error log please check opp log

steps to check the opp log

How to find OPP log file? ~ Welcome to Oracle ERP