Enable M2M mapping between supplier contact and suppliers

Enable many-to-many (M2M) mapping between supplier contacts and suppliers. This enables one supplier contact to be the contact for multiple suppliers, provided the suppliers share a parent-subsidiary relationship.

Before you begin

Role required: admin

Important: M2M mapping between supplier contact and suppliers is available from the Xanadu December 2024 release onwards. The following steps are required to enable M2M mapping.

Procedure

1. Create and run a fix script to enable M2M mapping.

   For detailed steps, see Run the fix script to enable M2M mapping.

2. Verify that the version record is created for the script include M2MSupplierSupportUtil.

   For detailed steps, see Verify version record.

3. Configure the Supplier Email Domain [sn_slm_email_domain] table to remove the unique constraint from the Email Domains column.

   For detailed steps, see Remove the unique constraint from Email Domain.

   Note: This step is required only for the upgrade scenarios (for all earlier versions upgrading to the Xanadu December 2024 release).

4. Run the fix script to enable M2M mapping
   Run the fix script to enable M2M mapping between supplier contact and suppliers.

5. Verify version record
   After the fix script is created and run to enable M2M mapping between supplier contact and suppliers, a version record must be created.

6. Remove the unique constraint from Email Domain
   Multiple supplier records can have the same email domain after removing the unique constraint from the Email Domain column of the Supplier Email Domain [sn_slm_email_domain] table.

Parent Topic:Configure Supplier Lifecycle Operations

Related topics

{Install Supplier Case Management}[]

{Install Supplier Collaboration Portal}[]

{Install Supplier Operations}[]

{Install Supplier Payment Optimization}[]

{Supplier Document Management}[]

{Configure the document template for the Sign document action type for supplier task}[]

{Advanced Work Assignment for Supplier Lifecycle Operations}[]

{Configure Supplier Relationship and Performance Management}[]

{Install Universal Request for SLO}[]

{Configure smart assessments}[]

Run the fix script to enable M2M mapping

Verify version record

Remove the unique constraint from Email Domain