11 Replies Latest reply on Jun 19, 2013 11:59 AM by 35a5d643-1f3b-49db-9947-9ef7b42a988c

    R12.1.3 :- XML concurrent request giving completed and "WARNING"

    755639
      Dear All,

      One particular Concurrent request was not running fine.

      Its show compleated* in Phase and in Status it showing *"warning"*.

      Actually its a "Supplier Invoice Aging"

      and the log file says like below
      ---------------------------------------------------------------------------------------------------------------------------------

      :++---------------------------------------------------------------------------++
      XXXXX Custom Application: Version : UNKNOWN
      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
      XXOMNSOS module: XXXXX Supplier Invoice Aging report
      ++---------------------------------------------------------------------------++
      Current system time is 18-FEB-2011 11:24:40
      ++---------------------------------------------------------------------------++
      ++-----------------------------+
      +| Starting concurrent program execution...+
      ++-----------------------------+
      Arguments
      ------------
      P_COMP_FR='008'
      P_COMP_TO='008'
      P_VENDOR_ID='115'
      p_account='320001'
      P_PERIOD_TYPE='Weekly Aging'
      p_as_of_date='2009/08/19 00:00:00'
      ------------
      +-- Start of Reports Command --+
      +/ebiz/apps/TEST/inst/apps/TEST_odhdbtest/ora/10.1.2/bin/appsrwrun.sh+
      P_CONC_REQUEST_ID=1429988
      P_COMP_FR='008'
      P_COMP_TO='008'
      P_VENDOR_ID='115'
      p_account='320001'
      P_PERIOD_TYPE='Weekly Aging'
      p_as_of_date='2009/08/19 00:00:00'
      report=/ebiz/apps/TEST/apps/apps_st/appl/xxomn/12.0.0/reports/US/XXOMNSOS.rdf
      batch=yes
      destype=file
      desname=/ebiz/apps/TEST/inst/apps/TEST_odhdbtest/logs/appl/conc/out/o1429988.out
      desformat=XML
      +-- End of Reports Command --+
      Request language is :
      AMERICAN
      Request territory is :
      AMERICA
      Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
      APPLLCSP Environment Variable set to :
      Previous NLS_LANG Environment Variable was :
      American_America.UTF8
      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
      American_America.UTF8
      +'.,'+
      Enter Password:
      Report Builder: Release 10.1.2.3.0 - Production on Fri Feb 18 11:24:41 2011
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      Reset original NLS_LANG in environment as :
      American_America.UTF8
      ++---------------------------------------------------------------------------++
      Start of log messages from FND_FILE
      ++---------------------------------------------------------------------------++
      ++---------------------------------------------------------------------------++
      End of log messages from FND_FILE
      ++---------------------------------------------------------------------------++
      ++---------------------------------------------------------------------------++
      Executing request completion options...
      Output file size:
      +12664+
      ++------------- 1) PUBLISH -------------++
      Beginning post-processing of request 1429988 on node ODHDBTEST at 18-FEB-2011 11:24:55.
      Post-processing of request 1429988 failed at 18-FEB-2011 11:24:56 with the error message:
      One or more post-processing actions failed. Consult the OPP service log for details.
      ++--------------------------------------++
      ++------------- 2) PRINT -------------++
      Not printing the output of this request because post-processing failed.
      ++--------------------------------------++
      Finished executing request completion options.
      ++---------------------------------------------------------------------------++
      Concurrent request completed
      Current system time is 18-FEB-2011 11:24:56
      ++---------------------------------------------------------------------------++
      ----------------------------------------------------------------------------------------------------------

      i have traced the concurrent request log file and its log says;-

      ------------------------------------------------------------------------------------------------------------------


      [2/18/11 11:06:41 AM] [1926299:RT1429947] Completed post-processing actions for request 1429947.
      [2/18/11 11:24:56 AM] [OPPServiceThread1] Post-processing request 1429988.
      [2/18/11 11:24:56 AM] [1926299:RT1429988] Executing post-processing actions for request 1429988.
      [2/18/11 11:24:56 AM] [1926299:RT1429988] Starting XML Publisher post-processing action.
      [2/18/11 11:24:56 AM] [1926299:RT1429988]
      Template code: XXOMNSOS
      Template app: XXOMN
      Language: en
      Territory: US
      Output type: RTF
      [2/18/11 11:24:56 AM] [1926299:RT1429988] Output file was found but is zero sized - Deleted
      [2/18/11 11:24:56 AM] [UNEXPECTED] [1926299:RT1429988] java.lang.reflect.InvocationTargetException
      at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      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.fo.util.FOUtility.generateFO(FOUtility.java:1044)
      at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
      at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
      at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
      at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
      at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)
      at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
      at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
      at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
      at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
      Caused by: org.xml.sax.SAXParseException: <Line 1, Column 3>: XML-20108: (Fatal Error) Start of root element expected.
      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.NonValidatingParser.parseRootElement(NonValidatingParser.java:343)
      at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)
      at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)
      ... 16 more

      [2/18/11 11:24:56 AM] [1926299:RT1429988] Completed post-processing actions for request 1429988.
      [2/18/11 12:19:47 PM] [OPPServiceThread1] Post-processing request 1430104.
      [2/18/11 12:19:47 PM] [1926299:RT1430104] Executing post-processing actions for request 1430104.
      [2/18/11 12:19:47 PM] [1926299:RT1430104] Starting XML Publisher post-processing action.

      --------------------------------------------------------------------------------------------------------------

      I am not able to understand this,, Is this a issue of DBA or Functional or Developers ??

      i have refered few documents here i would like to mention


      1) Troubleshooting Oracle XML Publisher For The Oracle E-Business Suite [ID 364547.1]
      2) R12: Tax Reconciliation By Taxable Account: Post-Processing Action Failed [ID 740223.1]
      3) Statement Generation Program ending in XDOException "java.lang.reflect.InvocationTargetException" [ID 869522.1]


      i througly checked with the above 3rd Document, ever settings are very fine,, no changes in this,, then i bounced the concurrent. the notes says ths problem may occure because of insufficient of space or not proper setup of xml, !;(

      Can any one kindly tell me from where i have to start,, ;(

      Thanks in Advance

      Hameed

      Edited by: Hameed on Feb 18, 2011 6:37 AM
        • 1. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
          Helios-GunesEROL
          Hi;
          XML-20108: (Fatal Error) Start of root element expected
          Please check below notes:
          BI Publisher: EText Template Reports Error When Using XMLDebug [ID 1295554.1]
          Cannot Publish Request Set Through Report Manager: Failed To Get The Expanded Values [ID 733396.1]
          Unable to start OC4J services on E-Business Suite R12 [ID 813813.1]

          Regard
          Helios
          • 2. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
            Srini Chavali-Oracle
            >
            [2/18/11 11:24:56 AM] [1926299:RT1429988] Output file was found but is zero sized - Deleted
            >

            Looks like the output XML file created was zero bytes in size - this indicates that the XXOMNSOS.rdf executable did not find any data to retrieve for the parameters passed to it.

            HTH
            Srini
            • 3. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
              Hussein Sawwan-Oracle
              desname=/ebiz/apps/TEST/inst/apps/TEST_odhdbtest/logs/appl/conc/out/o1429988.out
              Can you find any data in this file?

              Thanks,
              Hussein
              • 4. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                755639
                Yes ,, there is some data's

                -----------------------------------------------
                encoding="UTF-8"?>
                +<!-- Generated by Oracle Reports version 10.1.2.3.0 -->+
                +<T04101344>+
                +<LIST_G_COM_ACC>+
                +<G_COM_ACC>+
                +<COMACC>008320001</COMACC>+
                +<ACCOUNT>Trade Payables[320001]</ACCOUNT>+
                +<COMPANY>OP08-BINARY</COMPANY>+
                +<LIST_G_VEN>+
                +<G_VEN>+
                +<VENDOR_NAME>XXXXXXX</VENDOR_NAME>+
                +<LIST_G_INV>+
                +<G_INV>+
                +<INV_CURR>AED</INV_CURR>+
                +<VENDOR_NAME1>XXXXXX</VENDOR_NAME1>+
                +<PAID_AMOUNT>404167</PAID_AMOUNT>+
                +<INVOICE_NUM>2652</INVOICE_NUM>+
                +<DUE_DATE>27-NOV-08</DUE_DATE>+
                +<INVOICE_AMOUNT>416668</INVOICE_AMOUNT>+
                +<DUE_DAYS>265</DUE_DAYS>+
                +<AMOUNT_REMAINING>12501</AMOUNT_REMAINING>+
                +<AMT_PER>3</AMT_PER>+
                +<DUE1></DUE1>+
                +<DUE2></DUE2>+
                +<DUE3></DUE3>+
                +<DUE4></DUE4>+
                +<DUE5>12501</DUE5>+
                +<DUE6></DUE6>+
                +<DUE7></DUE7>+
                +<CF_1></CF_1>+
                +</G_INV>+
                +<G_INV>+
                +<INV_CURR>AED</INV_CURR>+
                +<VENDOR_NAME1>XXXXXX</VENDOR_NAME1>+
                +<PAID_AMOUNT>104167</PAID_AMOUNT>+
                +<INVOICE_NUM>2668</INVOICE_NUM>+
                +<DUE_DATE>27-NOV-08</DUE_DATE>+
                +<INVOICE_AMOUNT>208334</INVOICE_AMOUNT>+
                +<DUE_DAYS>265</DUE_DAYS>+
                +<AMOUNT_REMAINING>104167</AMOUNT_REMAINING>+
                +<AMT_PER>50</AMT_PER>+
                +<DUE1></DUE1>+
                +<DUE2></DUE2>+
                +<DUE3></DUE3>+
                +<DUE4></DUE4>+
                +<DUE5>104167</DUE5>+
                +<DUE6></DUE6>+
                +<DUE7></DUE7>+
                +<CF_1></CF_1>+
                +</G_INV>+
                +<G_INV>+
                +<INV_CURR>AED</INV_CURR>+
                +<VENDOR_NAME1>XXXXXX</VENDOR_NAME1>+
                +<PAID_AMOUNT>104167</PAID_AMOUNT>+
                +<INVOICE_NUM>2696</INVOICE_NUM>+
                +<DUE_DATE>29-NOV-08</DUE_DATE>+
                +<INVOICE_AMOUNT>208334</INVOICE_AMOUNT>+
                +<DUE_DAYS>263</DUE_DAYS>+
                +<AMOUNT_REMAINING>104167</AMOUNT_REMAINING>+
                +<AMT_PER>50</AMT_PER>+
                +<DUE1></DUE1>+
                +<DUE2></DUE2>+
                +<DUE3></DUE3>+
                +<DUE4></DUE4>+
                +<DUE5>104167</DUE5>+
                +<DUE6></DUE6>+
                +<DUE7></DUE7>+
                +<CF_1></CF_1>+
                +</G_INV>+
                +<G_INV>+
                ------------------------
                Tail of the .out file
                ------------------------
                +</LIST_G_COM_ACC>+
                +<DUE1_RANGE_FR>1</DUE1_RANGE_FR>+
                +<DUE2_RANGE_FR>8</DUE2_RANGE_FR>+
                +<DUE3_RANGE_FR>15</DUE3_RANGE_FR>+
                +<DUE4_RANGE_FR>22</DUE4_RANGE_FR>+
                +<DUE5_RANGE_FR>29</DUE5_RANGE_FR>+
                +<DUE6_RANGE_FR></DUE6_RANGE_FR>+
                +<DUE7_RANGE_FR></DUE7_RANGE_FR>+
                +<DUE1_RANGE_TO>7</DUE1_RANGE_TO>+
                +<DUE2_RANGE_TO>14</DUE2_RANGE_TO>+
                +<DUE3_RANGE_TO>21</DUE3_RANGE_TO>+
                +<DUE4_RANGE_TO>28</DUE4_RANGE_TO>+
                +<DUE5_RANGE_TO>9999</DUE5_RANGE_TO>+
                +<DUE6_RANGE_TO></DUE6_RANGE_TO>+
                +<DUE7_RANGE_TO></DUE7_RANGE_TO>+
                +<TITLE1>1 Week</TITLE1>+
                +<TITLE2>2 Weeks</TITLE2>+
                +<TITLE3>3 Weeks</TITLE3>+
                +<TITLE4>4 Weeks</TITLE4>+
                +<TITLE5>Over 4 weeks</TITLE5>+
                +<TITLE6></TITLE6>+
                +<TITLE7></TITLE7>+
                +<DUE1_NET>325307.5</DUE1_NET>+
                +<DUE2_NET></DUE2_NET>+
                +<DUE3_NET></DUE3_NET>+
                +<DUE4_NET></DUE4_NET>+
                +<DUE5_NET>1071029</DUE5_NET>+
                +<DUE6_NET></DUE6_NET>+
                +<DUE7_NET></DUE7_NET>+
                +<AMT_REM_NET>1396336.5</AMT_REM_NET>+
                +<P_VENDOR_NAME>XXXXXX</P_VENDOR_NAME>+
                +<P_COMPANY_FR>OP08-BINARY</P_COMPANY_FR>+
                +<P_COMPANY_TO>OP08-BINARY</P_COMPANY_TO>+
                +<P_PERIOD_NAME>Weekly Aging</P_PERIOD_NAME>+
                +<P_ACCOUNT_NAME>Trade Payables</P_ACCOUNT_NAME>+
                +<P_DATE>2009/08/19 00:00:00</P_DATE>+
                +</T04101344>+

                ------------------------------------------------------

                These are the data's its showing.. :(

                Regards,
                Hameed
                • 5. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                  755639
                  Dear Hussein,

                  This is the only document i followed till now, and i checked those workarounds,
                  Statement Generation Program ending in XDOException "java.lang.reflect.InvocationTargetException"; [ID 869522.1]

                  Can you give me suggestion wether is it correct because the doc says its insufficient of space also this warning may raise ! what is your suggestion!


                  Regards
                  Hameed
                  • 6. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                    Hussein Sawwan-Oracle
                    This is the one document i followed till now and check its workarounds,
                    Statement Generation Program ending in XDOException "java.lang.reflect.InvocationTargetException"; [ID 869522.1]

                    Can you give me suggestion wether is it correct because the doc says its insufficient of space also this warning may raise ! what is your suggestion!
                    Do you mean the workaround worked for you? Please elaborate more.

                    Also, if this concurrent request returns data, can you view the output file from the application?

                    Thanks,
                    Hussein
                    • 7. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                      755639
                      Dear Hussien,

                      I have followed these following step, and check the parameters in "Administration Responsibility":

                      References
                      BUG:7317280 - XML POST PROCESSING ENDS WITH WARNING
                      -------------------------------------------------------------------------------------------------------------
                      Even i restart the concurrent managers !

                      Can you explain me what else i have to in this..


                      Regards
                      Hameed
                      • 8. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                        Hussein Sawwan-Oracle
                        Hameed,

                        Please answer the questions in my previous reply.

                        Thanks,
                        Hussein
                        • 9. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                          755639
                          Sorry Hussine

                          No, the workaround not given any change
                          The concurrent doesnt return any data or any output form, more over the "view output" button was diabled in the "Requests" form because of that warning!

                          i have posted the concurrent request out logfile details in above posts.

                          Regards
                          Hameed
                          • 10. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                            755639
                            Thank you very much for all, the issue is solved.


                            Actually the problem was in the form properties , its a technical issue.

                            The developer have to set the Properties to XML publisher in the appropriate form propertie.*
                            Once again thank you very much for all who respond for this issue.

                            Thanks & Regards
                            Hameed
                            • 11. Re: R12.1.3 :- XML concurrent request giving completed and "WARNING"
                              35a5d643-1f3b-49db-9947-9ef7b42a988c

                              Hi Hameed,

                               

                                I'm facing same kind of issue.  Can you please let me know how did you resolve?

                               

                              Thanks,

                              Raghu