You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Transaction line items are getting set through sales cloud opportunty import integration

Received Response
14
Views
2
Comments
edited Aug 4, 2020 9:06AM in Configure Price Quote 2 comments

Summary

Transaction line items are getting set through sales cloud opportunty import integration

Content

HI Team,

We have integration between sales cloud and cpq, where we need to get opportunity details and revenue line details to cpq, in this opportunity details are getting but revenue line items are not populating. bellow is the XSL im using. 

Code Snippet

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sb1="urn:crmondemand/ws/account/10/2004" xmlns:ns4="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/OpportunityResource/" xmlns:ns3="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/" xmlns:ns2="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/" xmlns:ns1="http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/" version="1.0">
<xsl:output method="xml"/>
<xsl:template match="/">
<data_xml>
<document document_var_name="transaction">
<opportunityName_t>
<xsl:value-of select="//ns2:Name"/>
</opportunityName_t>
<opportunityNumber_t>
<xsl:value-of select="//ns2:OptyNumber"/>
</opportunityNumber_t>
<_distributor_t_company_name>
<xsl:value-of select="//ns2:TargetPartyName"/>
</_distributor_t_company_name>
<_reseller_t_company_name>
<xsl:value-of select="//ns2:Reseller_c"/>
</_reseller_t_company_name>
<_endUser_t_company_name>
<xsl:value-of select="//ns2:EndUser_c"/>
</_endUser_t_company_name>
<distributorLOBCode_t>
<xsl:value-of select="//ns2:ClassCode"/>
</distributorLOBCode_t>
<resellerLOBCode_t>
<xsl:value-of select="//ns2:ResellerClassificationCode_c"/>
</resellerLOBCode_t>
<endUserLOBCode_t>
<xsl:value-of select="//ns2:EndUserClassificationCode_c"/>
</endUserLOBCode_t>
<distributorPartyNumber_t>
<xsl:value-of select="//ns2:CustomerRegistryID_c"/>
</distributorPartyNumber_t>
<resellerPartyNumber_t>
<xsl:value-of select="//ns2:ResllerAccountNumber_c"/>
</resellerPartyNumber_t>
<endUserPartyNumber_t>
<xsl:value-of select="//ns2:EndUserAccountNumber_c"/>
</endUserPartyNumber_t>
<oRCL_OSC_PrimaryOrgID_t>
<xsl:value-of select="//ns2:PrimaryOrganizationId"/>
</oRCL_OSC_PrimaryOrgID_t>
</document>
<xsl:for-each select="//ns2:ChildRevenue">
<document document_var_name="transactionLine">
<_part_desc>PTT 5000</_part_desc>
<_price_list_price_each>
<xsl:value-of select="ns1:UnitPrice"/>
</_price_list_price_each>
<_part_units>
<xsl:value-of select="ns1:Quantity"/>
</_part_units>
<!--_part_number>10005000</_part_number-->
<!-- <_price_quantity>1</_price_quantity> -->
</document>
</xsl:for-each>
</data_xml>
</xsl:template>
</xsl:stylesheet>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!