7 Replies Latest reply: Jun 7, 2013 8:28 AM by 937476 RSS

    ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing

    937476
      Hi,

      I am trying to update an already existing Sales Order through PO Change Inbound 860. When i am performing changes in the line quantity and scheduled ship date with operation code as "Update" then it is successfully updating the Order and also we are able to generate the POAck for the updated sales order lines. But when i am rejecting one of the PO change lines by checking rejected flag, then order is getting imported successfully(I mean sales order is getting updated successfully) but during the POAck Generation i.e. 865 its raising "*ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00103: Warning: document structure does not match DTD Error at line 1*" at XML Gateway. we are using XML Gateway to process the orders, can somebody help me to get rid of this issue. Thanks in advance.

      Thanks,
      Sunil Chauhan
        • 1. Re: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing
          Hussein Sawwan-Oracle
          Please review the following docs and see if it helps.

          Trying to Send cXML Documents via Purchase Order Approval, Errors occur: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00103 [ID 752153.1]
          During cXML Generation for a Purchase Order, Error Occurs: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00103 [ID 1301689.1]
          ORA-31011:Xml Parsing Failed ORA-19202: Error Occurred In XML Processing LPX-00103 [ID 1332349.1]
          Unable to Generate cXML Purchase Order Due to Errors ORA-31011, ORA-19202, and LPX-00103: Warning: document structure does not match DTD [ID 1287553.1]
          XML Document Generation Fails With LPX-00103: Warning: Document Structure Does Not Match DTD [ID 1275586.1]
          XML Error While Generating Xml Payload In Xml Gateway, Transaction Type : CLN [ID 1197934.1]

          Thanks,
          Hussein
          • 2. Re: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing
            937476
            Thanks For the reply.

            i have checked all the doc ids mentioned above but no one is related to my issue. I am getting this issue while generating the PO change Ack Outbound (when we are rejecting any line for a PO Change by applying rejected flag from correction window) and not PO Outbound. Please advice.

            Thanks,
            Sunil
            • 3. Re: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing
              937476
              Can anyone help me on this issue.

              Thanks,
              Sunil Chauhan
              • 4. Re: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing
                937476
                I am still looking for reply..

                Thanks,
                Sunil
                • 5. Re: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing
                  Hussein Sawwan-Oracle
                  If none of the docs help then please log a SR.

                  Thanks,
                  Hussein
                  • 6. Re: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing
                    user11141835
                    I hope for few of the fileds in XML is not matching with target tables.could you verify the XML/DTD tag values and target tables data types.

                    if possible post the XML and DTD files ,will analyze it and give more analysis.

                    Regards,
                    B.kishan
                    • 7. Re: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing
                      937476
                      Hi Kishan

                      Thanks for the reply.

                      Because this is an outbound transaction so i can not provide you the XML file as we are facing issue to generate the same. Also we are using oracle seeded PO outbound Ack map.
                      In addition i can provide you the DTD file.

                      <!-- ==================================================== -->
                      <!ENTITY % RESOURCES SYSTEM "oagis_resources.dtd">
                      %RESOURCES;
                      <!-- ==================================================== -->
                      <!ELEMENT ACKNOWLEDGE_PO_008 (CNTROLAREA, DATAAREA+)>
                      <!ATTLIST VERB
                           value CDATA #FIXED "ACKNOWLEDGE"
                      >
                      <!ATTLIST NOUN
                           value CDATA #FIXED "PO"
                      >
                      <!ATTLIST REVISION
                           value CDATA #FIXED "008"
                      >
                      <!ELEMENT DATAAREA (ACKNOWLEDGE_PO)
                      >
                      <!ELEMENT ACKNOWLEDGE_PO (POORDERHDR, POORDERLIN*)
                      >
                      <!ELEMENT POORDERHDR ((%DATETIME.DOCUMENT;)?, (%OPERAMT.EXTENDED.T;)?, POID, POTYPE, ACKREQUEST?, CONTRACTB?, CONTRACTS?, DESCRIPTN?, NOTES*, OPRAMTAUTH?, PORELEASE?, TAXWHEXMPT?, USERAREA?, ACKHEADER, ATTCHREF*, CHARGE*, PARTNER*, POTERM*)
                      >
                      <!ELEMENT ACKHEADER (SENDER, (%DATETIME.PROMDELV;)?, (%DATETIME.PROMSHIP;)?, ACKCODE, DESCRIPTN?, NOTES*, SALESORDID?, USERAREA?)
                      >
                      <!ELEMENT POTERM (DESCRIPTN?, TERMID?, ((DAYOFMONTH, PROXMONTH) | DAYSNUM), ((%OPERAMT.EXTENDED.T;) | (%QUANTITY.PERCENT;)), USERAREA?)
                      >
                      <!ELEMENT POORDERLIN ((%QUANTITY.ORDERED;), (%DATETIME.NEEDDELV;)?, (%OPERAMT.UNIT.T;)?, POLINENUM, DRAWING?, HAZRDMATL?, ITEMRV?, ITEMRVX?, NOTES*, PACKING?, POLNSTATUS?, TAXWHEXMPT?, ((DESCRIPTN, ITEM?, ITEMX?, UPC?) | (ITEM, ITEMX?, UPC?) | (ITEMX, UPC?) | (UPC)), USERAREA?, ACKLINE*, ATTCHREF*, CHARGE*, DISTRIBUTN*, PARTNER*, POTERM*, POSUBLINE*, POLINESCHD*)
                      >
                      <!ELEMENT ACKLINE ((%DATETIME.PROMDELV;)?, (%DATETIME.PROMSHIP;)?, (%QUANTITY.ORDERED;)?, ACKCODE, NOTES*, SALESORDID?, USERAREA?)
                      >
                      <!ELEMENT POSUBLINE ((%QUANTITY.ITEM;), DRAWING?, ITEMRV?, ITEMRVX?, PSBLINENUM?, ((DESCRIPTN, ITEM?, ITEMX?, UPC?) | (ITEM, ITEMX?, UPC?) | (ITEMX, UPC?) | (UPC)), USERAREA?)>
                      <!ELEMENT POLINESCHD ((%DATETIME.NEEDDELV;), (%QUANTITY.ORDERED;), DESCRIPTN?, PSCLINENUM?, USERAREA?)
                      >


                      Thanks,S
                      --Sunil