Supplier Management

Get Involved. Join the Conversation.

Topic

    Padmanaban Sanjeevi
    Supplier Site Creation with Context DFF via web service
    Topic posted September 1, 2019 by Padmanaban SanjeeviRed Ribbon: 250+ Points, tagged Web Services 
    39 Views, 3 Comments
    Title:
    Supplier Site Creation with Context DFF via web service
    Summary:
    Context DFF has been configured at Supplier Site with 10 Attributes. Getting error using Web Services while passing 3 attributes
    Content:

    Hi,

    We have a requirement to create Supplier/Site/Address/Site Assignment via Web service.

    Context DFF has been configured at Supplier Site level with 10 attributes.  All attributes are Non-mandatory

    While calling Web service, we are passing only values for 3 attributes.

    Web service is failed with the following error

    "The value for the attribute cannot be blank when Operation has the value Create"

    It is expecting all attributes should have value during create operation, even though none of the attributes are mandatory.

    Need help on how to resolve this issue.  Appreciate very much

    Thanks

    Paddy

    sample Payload Below

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

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" 
    xmlns:typ="http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/" 
    xmlns:sup="http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
       <soapenv:Body>
          <typ:updateSupplier>
             <typ:supplierRow>
                <sup:Supplier>SCS - ABB PRM2708003</sup:Supplier>
                <sup:SupplierAddresses>
                   <sup:Operation>CREATE</sup:Operation>
                   <sup:AddressName>TSC 600108002</sup:AddressName>
                   <sup:Country>US</sup:Country>
                   <sup:AddressLine1>6502</sup:AddressLine1>
                   <sup:AddressLine2>N Military Trl</sup:AddressLine2>
                   <sup:AddressLine3/>
                   <sup:City>Boca Raton</sup:City>
                   <sup:State>FL</sup:State>
                   <sup:PostalCode>33496</sup:PostalCode>
                   <sup:OrderingPurposeFlag>TRUE</sup:OrderingPurposeFlag>
                </sup:SupplierAddresses>
                <sup:SupplierSites>
                   <!--Optional:-->
                   <sup:Operation>CREATE</sup:Operation>
                   <sup:SiteName>TSC 600108002</sup:SiteName>
                   <sup:AddressName>TSC 600108002</sup:AddressName>
       <sup:AlternateSiteName>600108002</sup:AlternateSiteName>
                   <sup:ProcurementBU>XX Trade Procurement BU</sup:ProcurementBU>
                   <sup:PurchasingPurposeFlag>TRUE</sup:PurchasingPurposeFlag>
                   <sup:PaymentCurrency>USD</sup:PaymentCurrency>
                   <sup:InvoiceCurrency>USD</sup:InvoiceCurrency>
                   <sup:FOB>SHIPPING</sup:FOB>
                   <sup:AmountTolerances>US_OD_TOLERANCES_1_PCT_SERVICES</sup:AmountTolerances>
                   <sup:QuantityTolerances>US_OD_Tolerances_Default</sup:QuantityTolerances>
                   <sup:InvoiceMatchOption>P</sup:InvoiceMatchOption>
                   <sup:PaymentPriority>99</sup:PaymentPriority>
                   <sup:PaymentTerms>0/0N0</sup:PaymentTerms>
                   <sup:PayDateBasis>DISCOUNT</sup:PayDateBasis>
                   <sup:PayGroup>US_OD_TRADE_NON_DISCOUNT</sup:PayGroup>
                   <sup:AlwaysTakeDiscount>Y</sup:AlwaysTakeDiscount>
                   <sup:TermsDateBasis>Invoice</sup:TermsDateBasis> 
      <sup:SupplierSitesFlexField xsi:type="sup3:Xx" xmlns:sup3="http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/">
                      <sup3:__FLEX_Context>XX</sup3:__FLEX_Context>
                      <sup3:siteCategory>TR-SCS</sup3:siteCategory>
                      <sup3:ediDistributionCode>ED</sup3:ediDistributionCode>
                      <sup3:backOrderFlag>Y</sup3:backOrderFlag>
                      <sup3:fob>SHIPPING</sup3:fob>
                      <sup3:legacySupplier xsi:nil="true"></sup3:legacySupplier>
                      <sup3:geocode xsi:nil="true"></sup3:geocode>
                      <sup3:supplierTrait xsi:nil="true"></sup3:supplierTrait>
                      <sup3:consignmentFrequency xsi:nil="true"></sup3:consignmentFrequency>
                      <sup3:duns xsi:nil="true"></sup3:duns>
                      <sup3:sendLocIdOnPoXml xsi:nil="true"></sup3:sendLocIdOnPoXml>
                      <sup3:odDateSigned xsi:nil="true"></sup3:odDateSigned>
                      <sup3:vendorDateSigned xsi:nil="true"></sup3:vendorDateSigned>
                      <sup3:legacySupplierSiteId xsi:nil="true"></sup3:legacySupplierSiteId>
                      <sup3:eftSettleDays xsi:nil="true"></sup3:eftSettleDays>
                      <sup3:relatedPaySite xsi:nil="true"></sup3:relatedPaySite>
                   </sup:SupplierSitesFlexField>    
                   <sup:SupplierSiteAssignments>
                      <sup:Operation>CREATE</sup:Operation>
                      <sup:ClientBU>XX US Fin BU</sup:ClientBU>
                      <sup:BillToBU>XX US Fin BU</sup:BillToBU>
                      <sup:ShipToLocation>Office Depot Florida</sup:ShipToLocation>
                      <sup:BillToLocation>Office Depot Florida</sup:BillToLocation>
                      <sup:LiabilityDistributionConcatSegments>1150.43.00000.211110.10000.0000</sup:LiabilityDistributionConcatSegments>
                      <sup:PrepaymentDistributionConcatSegments>1150.43.00000.151340.10000.0000</sup:PrepaymentDistributionConcatSegments>
                      <sup:BillsPayableDistributionConcatSegments>1150.43.00000.151340.10000.0000</sup:BillsPayableDistributionConcatSegments>
                   </sup:SupplierSiteAssignments>
                </sup:SupplierSites>
                <sup:SupplierContacts>
                   <sup:Operation>CREATE</sup:Operation>
                   <sup:FirstName>PKUM</sup:FirstName>
                   <sup:LastName>PRM0409007</sup:LastName>
                   <sup:EmailAddress>1test@officedepot.com</sup:EmailAddress>
                   <sup:PhoneCountryCode>1</sup:PhoneCountryCode>
                   <sup:PhoneAreaCode>240</sup:PhoneAreaCode>
                   <sup:Phone>4098977</sup:Phone>
                </sup:SupplierContacts>
             </typ:supplierRow>
          </typ:updateSupplier>
       </soapenv:Body>
    </soapenv:Envelope>

    Response 

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

    HTTP/1.1 500 Internal Server Error
    Server: Oracle-HTTP-Server
    X-ORACLE-DMS-ECID: 005^OSr4fDE5i^E_R5^Ayd0005E60002kj
    SOAPAction: ""
    Content-Encoding: gzip
    Content-Type: text/xml; charset=UTF-8
    Content-Language: en
    X-Content-Type-Options: nosniff
    Strict-Transport-Security: max-age=31536000 ; includeSubDomains
    X-DataStream-MidMile-RTT: 7
    X-DataStream-Origin-MEX-Latency: 20658
    X-DataStream-Cache-Status: 0
    Date: Mon, 02 Sep 2019 00:40:34 GMT
    Transfer-Encoding: chunked
    Connection: close
    Vary: Accept-Encoding
    Connection: Transfer-Encoding
    Set-Cookie: JSESSIONID=NePvakJjseWhpsrLFnzYNGt0mU3HgNJlZepmBB4SitDrZWn4vmNZ!-1795238425; path=/; HttpOnly
    Set-Cookie: _WL_AUTHCOOKIE_JSESSIONID=1EYbNkoLpUwGANRr4vqc; path=/; secure; HttpOnly

    <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header/><env:Body><env:Fault><faultcode>env:Server</faultcode><faultstring>&lt;Supplier WebServiceOperation="updateSupplier" Supplier="SCS - ABB PRM2708003" SupplierNumber="" SupplierId=""&gt;
       &lt;SupplierSite Operation="CREATE" SiteId="" SiteName="TSC 600108002" ProcurementBUId="" ProcurementBU="OD Trade Procurement BU"&gt;
          &lt;Rejection Attribute2=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute3=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute4=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute5=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute7=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute9=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute14=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute17=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection AttributeDate1=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection AttributeDate2=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection AttributeNumber3=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;SupplierSiteAssignments Operation="CREATE" SiteAssignmentId="" SiteId="" Site="" ProcurementBUId="" ProcurementBU="" ClientBUId="" ClientBU="OD US Fin BU"&gt;
             &lt;Rejection VendorSiteId=""&gt;A value is required. You must provide a value.&lt;/Rejection&gt;
          &lt;/SupplierSiteAssignments&gt;
       &lt;/SupplierSite&gt;
    &lt;/Supplier&gt;</faultstring><detail><tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><tns:code/><tns:message>&lt;Supplier WebServiceOperation="updateSupplier" Supplier="SCS - ABB PRM2708003" SupplierNumber="" SupplierId=""&gt;
       &lt;SupplierSite Operation="CREATE" SiteId="" SiteName="TSC 600108002" ProcurementBUId="" ProcurementBU="OD Trade Procurement BU"&gt;
          &lt;Rejection Attribute2=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute3=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute4=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute5=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute7=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute9=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute14=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection Attribute17=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection AttributeDate1=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection AttributeDate2=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;Rejection AttributeNumber3=""&gt;The value for the attribute cannot be blank when Operation has the value Create.&lt;/Rejection&gt;
          &lt;SupplierSiteAssignments Operation="CREATE" SiteAssignmentId="" SiteId="" Site="" ProcurementBUId="" ProcurementBU="" ClientBUId="" ClientBU="OD US Fin BU"&gt;
             &lt;Rejection VendorSiteId=""&gt;A value is required. You must provide a value.&lt;/Rejection&gt;
          &lt;/SupplierSiteAssignments&gt;
       &lt;/SupplierSite&gt;
    &lt;/Supplier&gt;</tns:message><tns:severity>SEVERITY_ERROR</tns:severity>

     

    Comment