This discussion is archived
12 Replies Latest reply: Nov 2, 2012 10:49 AM by user10383617 RSS

sales quote example error (Schema validation failed for message part )

user10383617 Newbie
Currently Being Moderated
i am getting this error while starting process.


Non Recoverable System Fault :
<bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: Schema validation failed for message part payload. Please ensure at the message sender level that the data sent is schema compliant. Invalid text '' in element: 'PurchaseToDate'</summary></part><part name="detail"><detail>Invalid text '' in element: 'PurchaseToDate'</detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>
  • 1. Re: sales quote example error (Schema validation failed for message part )
    user10383617 Newbie
    Currently Being Moderated
    this is my log file says

    Caused By: com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault}
    messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}
    parts: {{
    summary=<summary>oracle.fabric.common.FabricInvocationException: Schema validation failed for message part payload. Please ensure at the message sender level that the data sent is schema compliant. Invalid text '' in element: 'PurchaseToDate'</summary>
    ,detail=<detail>Invalid text '' in element: 'PurchaseToDate'</detail>
    ,code=<code></code>}

    this is my script task xml which i am trying to assign
    oraext:parseXML('<ns1:QuoteRequest
    xmlns:ns1="http://www.mycompany.com/ns/salesquote">
    <ns1:Summary>
    <ns1:OpportunityID>zzzz2</ns1:OpportunityID>
    <ns1:AccountName>Acme New</ns1:AccountName>
    <ns1:Address>
    <ns1:Street>Demo Way</ns1:Street>
    <ns1:City>Redwood Shores</ns1:City>
    <ns1:State>CA</ns1:State>
    <ns1:Zip>94065</ns1:Zip>
    <ns1:Country>USA</ns1:Country>
    </ns1:Address>
    <ns1:PurchaseToDate>2010-05-30</ns1:PurchaseToDate>
    <ns1:SalesRepId>jcooper</ns1:SalesRepId>
    <ns1:SalesRepName>James Cooper</ns1:SalesRepName>
    <ns1:ValidUntil>2010-05-30</ns1:ValidUntil>
    <ns1:EffectiveDiscount>0.0</ns1:EffectiveDiscount>
    </ns1:Summary>
    <ns1:QuoteRequestStatus>James Cooper</ns1:QuoteRequestStatus>
    </ns1:QuoteRequest>')


    this is my schema
    <?xml version= '1.0' encoding= 'UTF-8' ?>
    <schema xmlns="http://www.w3.org/2001/XMLSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:qt="http://www.mycompany.com/ns/salesquote" targetNamespace="http://www.mycompany.com/ns/salesquote"
    elementFormDefault="qualified">
    <annotation>
    <documentation xml:lang="en">Sales Quote Request XSD</documentation>
    </annotation>
    <element name="QuoteRequest" type="qt:QuoteRequestType"/>
    <complexType name="QuoteRequestType">
    <sequence>
    <element name="Summary" type="qt:QuoteSummaryType"/>
    <element name="ProductItem" type="qt:ProductItemType"/>
    <element name="LicenseTerm" maxOccurs="unbounded" minOccurs="0" type="qt:LicenseTermType"/>
    <element name="QuoteRequestStatus" type="string"/>
    <element name="RecommendedDiscount" type="qt:DiscountRecommendationType" minOccurs="0"/>
    </sequence>
    </complexType>
    <complexType name="QuoteSummaryType">
    <sequence>
    <element name="OpportunityID" type="string" nillable="true"/>
    <element name="AccountName" type="string" nillable="true"/>
    <element name="NewCustomer" type="string" minOccurs="0"
    nillable="true"/>
    <element name="PurchaseToDate" type="double" minOccurs="0"
    nillable="true"/>
    <element name="Address" type="qt:AddressType" minOccurs="0"
    nillable="true"/>
    <element name="Contacts" type="qt:ContactType" minOccurs="0" maxOccurs="unbounded"
    nillable="true"/>
    <element name="CustomerType" type="string" minOccurs="0"
    nillable="true"/>
    <element name="Industry" type="string" minOccurs="0"
    nillable="true"/>
    <element name="SalesRepId" type="string" nillable="true"/>
    <element name="SalesRepName" type="string" minOccurs="0"
    nillable="true"/>
    <element name="SalesRepContact" type="string" minOccurs="0"
    nillable="true"/>
    <element name="ValidUntil" type="date" minOccurs="0"
    nillable="true"/>
    <element name="TotalNetRevenue" type="double" minOccurs="0"
    nillable="true"/>
    <element name="EffectiveDiscount" type="double" minOccurs="0"
    nillable="true"/>
    </sequence>
    </complexType>
    <xsd:complexType name="ProductItemType">
    <xsd:sequence>
    <xsd:element name="ProductID" maxOccurs="1" type="xsd:string"/>
    <xsd:element name="ProductName" minOccurs="0" maxOccurs="1" type="xsd:string"/>
    <xsd:element name="Quantity" maxOccurs="1" type="xsd:int"/>
    <xsd:element name="ListPrice" type="xsd:double"/>
    <xsd:element name="PreApprovedDiscount" minOccurs="0" maxOccurs="1" type="xsd:double"/>
    <xsd:element name="RequestedDiscount" maxOccurs="1" type="xsd:double"/>
    <xsd:element name="RestrictedItem" type="xsd:boolean" maxOccurs="1" minOccurs="0"/>
    <xsd:element name="ControlledAvailability" type="xsd:boolean" maxOccurs="1" minOccurs="0"/>
    <element name="Approval" type="qt:ApprovalType" maxOccurs="1" minOccurs="0"/>
    </xsd:sequence>
    </xsd:complexType>
    <complexType name="ContactType">
    <sequence>
    <element name="Name" type="string"/>
    <element name="Title" type="string"/>
    <element name="PhoneNumber" type="string"/>
    <element name="EmailAddress" type="string"/>
    </sequence>
    </complexType>
    <complexType name="AddressType">
    <sequence>
    <element name="Street" type="string"/>
    <element name="City" type="string"/>
    <element name="State" type="string"/>
    <element name="Zip" type="decimal"/>
    <element name="Country" type="string"/>
    </sequence>
    </complexType>
    <complexType name="QuotedSupportInfo">
    <sequence>
    <element name="SupportTerms" type="string" minOccurs="0"/>
    <element name="SupportRevenue" type="decimal" minOccurs="0"/>
    </sequence>
    </complexType>
    <complexType name="DiscountRecommendationType">
    <sequence>
    <element name="RevenueRange" type="string"/>
    <element name="SuggestedDiscount" type="string"/>
    <element name="FutureDiscountProvision" type="string"/>
    </sequence>
    </complexType>
    <complexType name="ApprovalType">
    <sequence>
    <element name="Approver" maxOccurs="1" minOccurs="0" type="string"/>
    <element name="Title" maxOccurs="1" minOccurs="0" type="string"/>
    <element name="Approved" maxOccurs="1" minOccurs="0" type="boolean"/>
    <element name="ApprovalIsConditional" maxOccurs="1" minOccurs="0" type="boolean"/>
    <element name="ApprovalNote" type="string" maxOccurs="1" minOccurs="0"/>
    </sequence>
    </complexType>
    <complexType name="LicenseTermType">
    <sequence>
    <element name="Category" type="qt:LicenseTermCategoryType" maxOccurs="1"/>
    <element name="Type" type="qt:LicenseTermTypeType" maxOccurs="1"/>
    <element name="Description" type="string" maxOccurs="1"/>
    <element name="Approval" type="qt:ApprovalType" maxOccurs="1" minOccurs="0"/>
    </sequence>
    </complexType>
    <simpleType name="LicenseTermCategoryType">
    <restriction base="string">
    <enumeration value="PriceHoldOptions"/>
    <enumeration value="NonStandardPricingAndCurrencyOptions"/>
    <enumeration value="LicenseManagementServicesOptions"/>
    <enumeration value="NonStandardLicensingOptions"/>
    </restriction>
    </simpleType>
    <simpleType name="LicenseTermTypeType">
    <restriction base="string">
    <enumeration value="FutureProgramPriceHolds"/>
    <enumeration value="FutureDiscountProvisions"/>
    <enumeration value="PriceHoldOnEntirePriceList"/>
    <enumeration value="ModificationsToContractualPricing"/>
    <enumeration value="Currency"/>
    <enumeration value="PreferredCustomerProvisions"/>
    <enumeration value="WaivingOrLoweringPurchaseMinimums"/>
    <enumeration value="AuditWaivers"/>
    <enumeration value="CancelAndReplace"/>
    <enumeration value="DirectOrderFromCompetitors"/>
    <enumeration value="ReciprocalTransaction"/>
    <enumeration value="Hosting"/>
    <enumeration value="HostingRights"/>
    <enumeration value="NDA"/>
    </restriction>
    </simpleType>
    <element name="ApprovalFlow" type="qt:ApprovalFlowType"/>
    <complexType name="ApprovalFlowType">
    <sequence>
    <element name="SelfApproved" type="boolean"/>
    <element name="NumberOfTier3Levels" type="int"/>
    <element name="Tier2ApprovalNeeded" type="boolean"/>
    <element name="Tier2Approvers" type="string"/>
    <element name="Tier1ApprovalNeeded" type="boolean"/>
    <element name="BusinessPracticesReviewNeeded" type="boolean"/>
    <element name="CustomerType" type="boolean"/>
    <element name="NewEffectiveDicount" type="double"/>
    </sequence>
    </complexType>
    <element name="RulesInput">
    <complexType>
    <sequence>
    <element ref="qt:QuoteRequest"/>
    </sequence>
    </complexType>
    </element>
    <element name="RulesOutput">
    <complexType>
    <sequence>
    <element ref="qt:ApprovalFlow"/>
    </sequence>
    </complexType>
    </element>
    <element name="ApproveTaskInfo">
    <complexType>
    <sequence>
    <element name="GUID" type="xsd:string"/>
    <element name="Namespace" type="xsd:string"/>
    </sequence>
    </complexType>
    </element>
    </schema>

    Edited by: user10383617 on Nov 1, 2012 11:05 AM
  • 2. Re: sales quote example error (Schema validation failed for message part )
    user10383617 Newbie
    Currently Being Moderated
    In my schema PurchaseToDate is of type double

    i tried with both option but still didnt work

    <ns1:PurchaseToDate>2010-05-30</ns1:PurchaseToDate>

    <ns1:PurchaseToDate>2.2</ns1:PurchaseToDate>
  • 3. Re: sales quote example error (Schema validation failed for message part )
    Daniel Atwood Oracle ACE
    Currently Being Moderated
    In the text for your "parseXML" XPath expression try either deleting the "<ns1:PurchaseToDate>...</ns1:PurchaseToDate>" text or moving it above the <ns1:Address>...</ns1:Address> text.
  • 4. Re: sales quote example error (Schema validation failed for message part )
    user10383617 Newbie
    Currently Being Moderated
    Thanks for your reply ..

    Now getting this error

    Non Recoverable System Fault :
    <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: Schema validation failed for message part payload. Please ensure at the message sender level that the data sent is schema compliant. Element not completed: 'QuoteRequest'</summary></part><part name="detail"><detail>Element not completed: 'QuoteRequest'</detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>


    Any idea about this..
  • 5. Re: sales quote example error (Schema validation failed for message part )
    user10383617 Newbie
    Currently Being Moderated
    i removed script task then i started getting this error

    Non Recoverable System Fault :
    <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: Schema validation failed for message part payload. Please ensure at the message sender level that the data sent is schema compliant. Invalid text '' in element: 'Quantity'</summary></part><part name="detail"><detail>Invalid text '' in element: 'Quantity'</detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>



    giving default value in xsd also dint work it keep on throwing same problem for others element.

    Edited by: user10383617 on Nov 1, 2012 12:13 PM
  • 6. Re: sales quote example error (Schema validation failed for message part )
    Daniel Atwood Oracle ACE
    Currently Being Moderated
    Looks like there's a typo somewhere in your XPath statement. Know you've done this before, but paste your XPath statement in here again.
  • 7. Re: sales quote example error (Schema validation failed for message part )
    user10383617 Newbie
    Currently Being Moderated
    My Xpath Query


    oraext:parseXML('<ns1:QuoteRequest
    xmlns:ns1="http://www.mycompany.com/ns/salesquote">
    <ns1:Summary>
    <ns1:OpportunityID>zzzz2</ns1:OpportunityID>
    <ns1:AccountName>Acme New</ns1:AccountName>
    <ns1:PurchaseToDate>0.0</ns1:PurchaseToDate>
    <ns1:Address>
    <ns1:Street>Demo Way</ns1:Street>
    <ns1:City>Redwood Shores</ns1:City>
    <ns1:State>CA</ns1:State>
    <ns1:Zip>94065</ns1:Zip>
    <ns1:Country>USA</ns1:Country>
    </ns1:Address>
    <ns1:SalesRepId>jcooper</ns1:SalesRepId>
    <ns1:SalesRepName>James Cooper</ns1:SalesRepName>
    <ns1:ValidUntil>2010-05-30</ns1:ValidUntil>
    <ns1:EffectiveDiscount>0.0</ns1:EffectiveDiscount>
    </ns1:Summary>
    </ns1:QuoteRequest>')
  • 8. Re: sales quote example error (Schema validation failed for message part )
    user10383617 Newbie
    Currently Being Moderated
    When i removed my script task i got following error..


    <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: Schema validation failed for message part payload. Please ensure at the message sender level that the data sent is schema compliant. Invalid text '' in element: 'PurchaseToDate'</summary></part><part name="detail"><detail>Invalid text '' in element: 'PurchaseToDate'</detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>

    Edited by: user10383617 on Nov 1, 2012 9:31 PM
  • 9. Re: sales quote example error (Schema validation failed for message part )
    Daniel Atwood Oracle ACE
    Currently Being Moderated
    It looks like you're missing the QuoteRequestStatus and the ProductItem XML in your XPath expression. Try this:
    oraext:parseXML('<ns2:QuoteRequest xmlns:ns2="http://www.mycompany.com/ns/salesquote">
         <ns2:Summary>
              <ns2:OpportunityID>zzzz2</ns2:OpportunityID>
              <ns2:AccountName>Acme New</ns2:AccountName>
              <ns2:NewCustomer></ns2:NewCustomer>
              <ns2:PurchaseToDate>0.0</ns2:PurchaseToDate>
              <ns2:Address>
                   <ns2:Street>Demo Way</ns2:Street>
                   <ns2:City>Redwood Shores</ns2:City>
                   <ns2:State>CA</ns2:State>
                   <ns2:Zip>94065</ns2:Zip>
                   <ns2:Country>USA</ns2:Country>
              </ns2:Address>
              <ns2:CustomerType></ns2:CustomerType>
              <ns2:Industry></ns2:Industry>
              <ns2:SalesRepId>jcooper</ns2:SalesRepId>
              <ns2:SalesRepName>James Cooper</ns2:SalesRepName>
              <ns2:SalesRepContact></ns2:SalesRepContact>
              <ns2:ValidUntil>2010-05-30</ns2:ValidUntil>
              <ns2:EffectiveDiscount>0.0</ns2:EffectiveDiscount>
         </ns2:Summary>
         <ns2:ProductItem>
              <ns2:ProductID>a</ns2:ProductID>
              <ns2:Quantity>2</ns2:Quantity>
              <ns2:ListPrice>2</ns2:ListPrice>
              <ns2:RequestedDiscount>2</ns2:RequestedDiscount>
         </ns2:ProductItem>
         <ns2:QuoteRequestStatus>aa</ns2:QuoteRequestStatus>
    </ns2:QuoteRequest>')
    Dan
  • 10. Re: sales quote example error (Schema validation failed for message part )
    user10383617 Newbie
    Currently Being Moderated
    Didnt get success :(

    *<bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: Schema validation failed for message part payload. Please ensure at the message sender level that the data sent is schema compliant. Element 'QuoteRequestStatus' not expected.</summary></part><part name="detail"><detail>Element 'QuoteRequestStatus' not expected.</detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>*
  • 11. Re: sales quote example error (Schema validation failed for message part )
    Daniel Atwood Oracle ACE
    Currently Being Moderated
    Paste this text into your XPath expression:
    oraext:parseXML('<ns2:QuoteRequest xmlns:ns2="http://www.mycompany.com/ns/salesquote">
         <ns2:Summary>
              <ns2:OpportunityID>zzzz2</ns2:OpportunityID>
              <ns2:AccountName>Acme New</ns2:AccountName>
              <ns2:NewCustomer></ns2:NewCustomer>
              <ns2:PurchaseToDate>0.0</ns2:PurchaseToDate>
              <ns2:Address>
                   <ns2:Street>Demo Way</ns2:Street>
                   <ns2:City>Redwood Shores</ns2:City>
                   <ns2:State>CA</ns2:State>
                   <ns2:Zip>94065</ns2:Zip>
                   <ns2:Country>USA</ns2:Country>
              </ns2:Address>
              <ns2:CustomerType></ns2:CustomerType>
              <ns2:Industry></ns2:Industry>
              <ns2:SalesRepId>jcooper</ns2:SalesRepId>
              <ns2:SalesRepName>James Cooper</ns2:SalesRepName>
              <ns2:SalesRepContact></ns2:SalesRepContact>
              <ns2:ValidUntil>2010-05-30</ns2:ValidUntil>
              <ns2:EffectiveDiscount>0.0</ns2:EffectiveDiscount>
         </ns2:Summary>
         <ns2:ProductItem>
              <ns2:ProductID>a</ns2:ProductID>
              <ns2:Quantity>2</ns2:Quantity>
              <ns2:ListPrice>2</ns2:ListPrice>
              <ns2:RequestedDiscount>2</ns2:RequestedDiscount>
         </ns2:ProductItem>
         <ns2:QuoteRequestStatus>aa</ns2:QuoteRequestStatus>
    </ns2:QuoteRequest>')

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points