Import Parts - Partner as Parts Source

Use the template provided in the Result XSL to map the multi-select attributes of Salesforce with the corresponding attributes:

</xsl:template>
<!-- Template to replace charsIn(";") delimiter string with charsOut("~") delimiter string -->
<xsl:template name="replaceCharsInString">
  <xsl:param name="stringIn"/>
  <xsl:param name="charsIn"/>
  <xsl:param name="charsOut"/>
  <xsl:choose>
    <xsl:when test="contains($stringIn,$charsIn)">
      <xsl:value-of select="concat(substring-before($stringIn,$charsIn),$charsOut)"/>
      <xsl:call-template name="replaceCharsInString">
        <xsl:with-param name="stringIn" select="substring-after($stringIn,$charsIn)"/>
        <xsl:with-param name="charsIn" select="$charsIn"/>
        <xsl:with-param name="charsOut" select="$charsOut"/>
      </xsl:call-template>
    </xsl:when>
    <xsl:otherwise>
      <xsl:value-of select="$stringIn"/>
    </xsl:otherwise>
  </xsl:choose>
</xsl:template>

The Integration of Parts, Parts Extended Descriptions, and Price Book information between CRMs and Oracle CPQ occurs incrementally. You can choose to send parts when syncing/scheduling a Delta Parts Sync; for example, when exporting and/or importing parts from the last export/import date.

1. Navigate to the List Integrations page.
   1. Click Admin to go to the Admin Home Page.

   2. Click Parts under Products.

      The Parts Search for Admin page opens.

   3. Click List in the Price Book section.

      The Price Book Administration List page opens.

   4. Click the Name of the Price Book you want to export.

      The Price Book Administration page opens.

   5. Click Integration.

      The List Integrations page opens.

2. Select the Delta checkbox.

   

   This reduces overall Integration time.

The Import Parts integration synchronizes any changes made to items in the PIM Item Master into Oracle CPQ.

View Current Parts Source in Oracle CPQ:

1. Sign in to Oracle CPQ as a parts administrator or as a Full Access user.
2. Navigate to the Admin Home page.
3. Click Parts under Products. The Parts Search for Admin page appears.
4. The Item Master field shows the current parts source. If you see 'Partner' as the item master (source), it's referring to Product Information Management.

Import Parts:

1. Sign in to Oracle CPQ as a Full Access user.
2. Navigate to the Admin Home page.
3. Click Parts under Products. The Parts Search for Admin page appears.
4. Click Integration.
5. Under List Integration, select the Import Parts check box.

6. Upload the Integration XSL files for both SOAP Generation and Result Parser XSL files that have the field mappings for the integration. The integration uses the "findItem" SOAP web service of Product Information Management. The fetch criteria can be set up as needed, according to the business requirements in the implementation.

   Both standard and part custom fields can be mapped in the Result Parser XSL file. The field _partner_part_id is the primary field for mapping and is used as cross-reference ID for the integration.

   The _partner_part_id and partner_organization_id are important fields in the integration, which correspond to inventory_item_id and inventory_organization_id in Product Information Management.

   The reference XSL files can be obtained by performing the following steps:

   1. Navigate to the Admin Home page.

   2. Click Parts under Products.

   3. Click Integration.

   4. Select Import Parts under List Integration.

   5. Click Display File for SOAP Generator XSL and the Result Parser XSL to view the reference files.

7. Click Import to perform a one-time integration, or click Schedule to schedule a one-time integration or recurring integrations. If you schedule one or more integrations, the new schedule details for job import dialog box appears.
8. Select a Schedule Type and the corresponding frequency:
   • Monthly: Select the day of the month and the time of the integration.
   • Weekly: Select the day of the week and the time of the integration.
   • Daily: Select the time of the integration.
   • Hourly: Select an interval of 1-23 hours.
   • On Demand: Select the date and time of a one-time integration.
9. You can add start and end dates for a recurring integration.
10. Select either All Parts or Delta, depending on whether all parts always need to be integrated or only parts that are modified since the last integration.
11. When you're done with the scheduling details, click Add Schedule.
12. You can refer to the integration logs available in the Parts Integration and error logs for any troubleshooting or diagnosis.