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

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>