MRC And NRC Totals On Quote Not Correct When Using QuotingWebService Without Syncing Quote To DB

(Doc ID 2058568.1)

Last updated on NOVEMBER 12, 2015

Applies to:

Siebel CRM - Version 8.1.1.11.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11.11 [IP2013] version, Siebel EAI

ACTUAL BEHAVIOR
---------------

Using with QuotingWebService, MRC Total and NRC Total should get calculated in Quote or Order header with out setting the SyncQuoteFlag = Y



EXPECTED BEHAVIOR
-----------------------

Using with QuotingWebService, MRC Total and NRC Total should get calculated in Quote or Order header with out setting the SyncQuoteFlag = Y



STEPS
-----------------------

1.Create following Product 

Cp1  Price is 0 

--Sp1 NRC as 100 

 

2.Go to application-->Create Account-->Associate Price List to Account 

3.Create Quote for this Account 

Note down following field values: 

Account No Row #: 1-7CI4 

Account Name: Test QWS 

Quote Id: Row #:  1-7CIV 

Price List id: #: 1-6J9J 

product CP1id: Row #: 0CR-1GQ1Z8 

SP1: Row #: 0CR-1GQ1Y3 

 

4.Generate the WSDL for QuotingWebservice 

Sample Request for QuotingWebService: 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" 
xmlns:quot="http://siebel.com/OrderManagement/Quote/Quoting" 
xmlns:data="http://siebel.com/OrderManagement/Quote/Data"> 
   <soapenv:Header> 
      <soapenv:SessionType xmlns:soapenv="http://siebel.com/webservices">None</soapenv:SessionType> 

     <soapenv:UsernameToken xmlns:soapenv="http://siebel.com/webservices">SADMIN</soapenv:UsernameToken>
<soapenv:PasswordText  xmlns:soapenv="http://siebel.com/webservices">SADMIN</soapenv:PasswordText> 
    </soapenv:Header> 
   <soapenv:Body> 
      <quot:ExecuteQuoting_Input> 
         <quot:QueryQuoteFlag>N</quot:QueryQuoteFlag> 
         <quot:PricingFlag>Y</quot:PricingFlag> 
         <quot:Delta_spcAction_spcCode_spcFlag>N</quot:Delta_spcAction_spcCode_spcFlag> 
           <data:ListOfQuote> 
            <data:Quote> 
               <data:ServiceAccountId>1-7CI4</data:ServiceAccountId> 
               <data:Revision>1</data:Revision> 
               <data:QuoteNumber>Adi_369</data:QuoteNumber> 
               <data:PriceListId>1-6J9J</data:PriceListId> 
               <data:NRCTotal></data:NRCTotal> 
               <data:MRCTotal></data:MRCTotal> 
               <data:Freight>6.5</data:Freight> 
               <data:BillingAccount>Test QWS</data:BillingAccount> 
               <data:BillToAccountId>1-7CI4</data:BillToAccountId> 
               <data:AccountId>1-7CI4</data:AccountId> 
               <data:ServiceAccount>Test QWS</data:ServiceAccount>

               <data:Account>Test QWS</data:Account>
               <data:PrimaryOrganizationId>1-4TMQ5</data:PrimaryOrganizationId>
               <data:ShipToAccountId>1-7CI4</data:ShipToAccountId>
               <data:ShipToAccount>Test QWS</data:ShipToAccount>
                 <data:ListOfQuoteItem>
                        <data:QuoteItem>
                          <data:PricingAdjustmentAmount>0</data:PricingAdjustmentAmount>
                          <data:NRCCxTotal>0</data:NRCCxTotal>
                          <data:MRCCxTotal>0</data:MRCCxTotal>
                          <data:IntegrationId>c3</data:IntegrationId>
                          <data:CurrentPrice>0</data:CurrentPrice>
                          <data:CfgStateCode>Saved Item</data:CfgStateCode>
                          <data:ActionCode>Add</data:ActionCode>
                          <data:AccountId>1-7CI4</data:AccountId>
                          <data:PrePickCD>Y</data:PrePickCD>
                          <data:Id>c3</data:Id>
                          <data:Quantity>1</data:Quantity>
                          <data:ProductId>0CR-1GQ1Z8</data:ProductId>
                          <data:Name>CP1</data:Name>
                          <data:ListPrice>0</data:ListPrice>
                        </data:QuoteItem>
                          <data:QuoteItem>
                            <data:PricingAdjustmentAmount>0</data:PricingAdjustmentAmount>
                            <data:NRCCxTotal>0</data:NRCCxTotal>
                            <data:MRCCxTotal>0</data:MRCCxTotal>
                            <data:IntegrationId>c1</data:Integ
                            <data:CurrentPrice>50</data:CurrentPrice>
                            <data:CfgStateCode>Saved Item</data:CfgStateCode>
                            <data:ActionCode>Add</data:ActionCode>
                            <data:AccountId>1-7CI4</data:AccountId>
                            <data:PrePickCD>Y</data:PrePickCD>
                            <data:Id>c2</data:Id>
                            <data:Quantity>1</data:Quantity>
                            <data:ProductId>0CR-1GQ1Y3</data:ProductId>
                            <data:Name>SP1</data:Name>
                            <data:ListPrice>50</data:ListPrice>
                          </data:QuoteItem>

             </data:ListOfQuoteItem>
        <data:BillingAccountId>1-7CI4</data:BillingAccountId>
  </data:Quote>
</data:ListOfQuote>
<quot:CheckEligibilityFlag>Y</quot:CheckEligibilityFlag>
<quot:SyncQuoteFlag>N</quot:SyncQuoteFlag>
<quot:VerifyPromotionFlag>Y</quot:VerifyPromotionFlag>
<quot:CalculateShippingCostFlag>N</quot:CalculateShippingCostFlag>
<quot:RepricingFlag>N</quot:RepricingFlag>
<quot:CalculateTaxFlag>N</quot:CalculateTaxFlag>
</quot:ExecuteQuoting_Input>
</soapenv:Body>
</soapenv:Envelope>                     


Observe Results: For MRC Total and NRC Total in Header are 0 when you have the SyncQuoteFlag = N 

i.e: <quot:SyncQuoteFlag>N</quot:SyncQuoteFlag> 

But if you change the SyncQuoteFlag = Y, MRC Total and NRC Total in Header is getting calculated properly. 




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms