From ICIHelp7.14
Revision as of 18:26, 4 December 2019 by IDT-1 (Talk | contribs)

Jump to: navigation, search

Icertis Experience for Workday

Icertis Experience for Workday is a highly configurable and comprehensive solution that enables data synchronizing capabilities for mapping business objects between ICM and Workday. ICM integration with Workday provides a seamless user experience to work with the business data from both ICM and Workday.

This integration gives ICM the capabilities to tag Worker Data (for example, Employee ID, Employee Name, etc.) and Worker Role, and map them to the relevant ICM user attributes which can be referred and used across application as required.
Icertis Experience for Workday supports following sample use cases: 

  • Create Supplier Contracts in ICM that allows negotiating and managing the Contract through ICM, but only tracking the status in Workday
  • Synchronize the amended and renewed Supplier Contracts from Icertis to Workday

Icertis Experience for Workday offers many benefits: 

  •  Measure supplier performance with access to more detailed information 
  •  Manage the entire process throughout the entire life-cycle of the Agreement
     

ICM Side Configuration

Use the Configuration tile in the ICM application to specify the mapping details between Workday and ICM by creating Masterdata records for mapping entities. Data Mapping involves the following two primary tasks: 

  • Creating Masterdata Contract Type
  • Creating Masterdata records for mapping entities 
     

Creating a Masterdata Contract Type 

Masterdata Contract Type is the core data that changes less frequently and has a unique ID associated with it. For example, Employee Records can be a Masterdata Contract Type and Employee ID can be an attribute associated to that Masterdata Contract Type.
1. Log on to the ICM application.

2. Click Configuration on Dashboard. The Configuration page opens.

RTENOTITLE

3. Click Create Contract Type on the Configuration page. The Select Contract Type page opens and shows the following options:

  • Agreement
  • Associated Document
  • Masterdata
  • Contract Request 

4. Select Masterdata on the Select Contract Type page and click Next. The Create Contract Type page opens, which consists of these five sections:

  • Details
  • Attributes
  • Display Preference
  • Team
  • Verify

Each of these sections is described in detail below.


Details
Enter the following basic details of the Masterdata in this section: 

  • Contract Type Name: Type the name in this field as Client App Cross Reference Mapping. Note that Client App Cross Reference Mapping is an example provided here for the list of Masterdata you need to create. This Contract Type is used for mapping entities between ICM and Workday.
  • Contract Type Code: Every Contract Type is assigned a unique ID known as Contract Type Code. The Contract Type Code is generated automatically when you create the Contract Type. 
  • Enable Approval Workflow: Select Yes to enable the approval workflow. 
  • Two Column Attribute Layout: Select Yes to enable a two-column attribute layout

Attributes

This section captures important details of the Masterdata you are creating. The integration between ICM and Workday is restricted to the attributes listed below. 

Click the plus icon to create them: 

  • Name
  • Client Name
  • ICM Entity Name
  • Client Entity Name
  • ICM Attribute Name
  • ICM Relationship Key
  • Client Reference Key
Note: If any of the attributes mentioned above already exist, use the arrow to move them to the Selected Attribute list. 
 
RTENOTITLE
 
 
While creating each of the above attributes, ensure that you retain the following default settings:
  • Data Type: String
  • Is Default: Off 
  • Is Editable: On
  • Is Mandatory: Select Off
  • Tracking Attribute: Off
  • Is Unique: Off 
  • Defined by Rule: Off 
  • Is Inherit: Off
  • Is Searchable: On 
  • Is Conditional: Off
  • Is Lookup: Off 
  • Is Localized: Off
     

Display Preference

Select any four attributes that you want to display on the agreement tile view and agreement details view and click Next. The Team section is displayed. 

RTENOTITLE

Team

This section shows the existing team members along with their roles for the Masterdata Contract Type.

Click the plus icon to add a user with the Approver role to the Contract Type Masterdata team.

Workday-Addnewuser-SP6.png

Verify

This is the final section for creating the Contract Type Masterdata. It displays only the sections and attributes that you used to create this Masterdata Contract Type. 

1.Verify the information you entered in the previous sections. You can go back and make changes or click Create.
2. Send the Contract Type for approval.
3. After Masterdata is approved, publish the Masterdata Contract Type to make it available for Agreement creation.
 

Creating Masterdata records for mapping entities

ICM integrates with Workday and provides capability of synchronizing important Masterdata from Workday to ICM through a technical configuration. This list of Masterdata includes:
•    Supplier
•    Payment Terms
•    Payment Type
•    Purchase Items
The synchronized Masterdata can be used and referred across ICM application as required. For example, Supplier Masterdata can be used while creating supplier type contracts in ICM.

You can create Masterdata records for mapping the entities between ICM and Workday.

Creating Client App Cross Reference Mapping

1. Log on to the ICM application.
2. Click Configuration on ICM Dashboard. The Configuration page opens.

RTENOTITLE

3. Click Masterdata on the Configuration page. The Masterdata page opens.

RTENOTITLE

4. Click Create Masterdata. The Create Masterdata page opens. 

RTENOTITLE
 
5. Provide relevant information in the respective fields:
  • Category: Select Default from this drop-down. 
  • Masterdata: Select Client App Cross Reference from this drop-down.
RTENOTITLE

6. Click Next. The Attributes page opens.

RTENOTITLE
 
7. Provide relevant information in the respective fields:
  • Client Name: Select Workday from the drop-down. 
  • Name: Type the name of the Masterdata. 
  • ICM Entity Name: Type the name of the Agreement for which you are creating the Masterdata. For example, ICMSupplierMaster
  • Client Entity Name: Type the name of the Entity of Workday. For example, Supplier. 
  • ICM Reference Key: Type the ICM Reference Key value in this field. This is used to track the Masterdata in Workday that was created in ICM. For example, ICMExtSupplierId
  • Client Reference Key: Type the Reference attribute to be entered from Workday. For example, Supplier_Reference_ID.
  • External Contract Creation Criteria: Type the ICM entity metadata value that evaluates the value and creates the Contract Type. You can type @true to create the Contract Type Masterdata record and make it visible in Workday. 
  • External Contract Creation Event: Select the appropriate event from this drop-down to enable create object in in Workday. 
  • External Contract Update Event: Select the appropriate event from this drop-down 

8. Click Save after entering the details. 

Creating Client App Entity Mapping

You can create a Masterdata record for the Contract Type Masterdata that you created earlier. This helps in mapping the entities between ICM and Workday. 

To create a Masterdata record:
1.Click Configuration on My Dashboard. The Configuration page opens. 

RTENOTITLE

2. Click Masterdata on the Configuration page. The Masterdata page opens.

RTENOTITLE
 
3. Click Create Masterdata on the Masterdata page. The Create Masterdata page opens.
 
RTENOTITLE
 
4. Complete the information in the following sections. 
  • Masterdata Details
  • Attributes

5. Click Next at the end of Masterdata Details section to go to the Attributes section and complete creating the Masterdata record. 

Masterdata Details

This section displays the categories you can select and the Masterdata Contract Type for creating the Masterdata record. 
1. Select the category from the drop-down list. 
2. Select the Contract Type Masterdata that you created earlier. For mapping the data between ICM and Workday, select Client App Entity Mapping.
3. Click Next. The Attributes page opens. 


RTENOTITLE
 
Attributes
This section shows the attributes that you created when creating the Contract Type Masterdata. 
 
RTENOTITLE

4. Enter the following details in appropriate fields

  • Masterdata Code: Every Masterdata record you create is assigned a unique ID. It is generated automatically when you create the Masterdata.
  • Client Name: This helps in defining the mapping with the external system. For example, select Workday from the Client Name drop-down to define the mapping between ICM and Workday
  • ICM Entity Name: Type the ICM Agreement Contract Type for which you are creating the mapping between ICM and Workday.
  • ICM Attribute Name: Type the ICM Attribute Name of the Contract Type Masterdata. 
  • Client Entity Name: Workday entity name for which you are defining the mapping between ICM and Workday. 
  • Client Attribute Name: Type the Workday side attribute name for the client entity name that you mapped.
  • Data Flow Type: Defines the direction of mapping for the data flow. You can select the following data flow type.
    • ICM to Client: Select this option if you intend to map the data from ICM to Workday.
  • Contract Events: It is used to synchronize data from ICM to Workday. You can enter the events that happen in the Contract life cycle. For example, Created, Approved and so on. If you want to send the Agreement document in .docx format, set the value as Created/Published, else set the value as Created/Published/Updated to send the Agreement document in .pdf format.
  • Applicable to: Select one of the following from this drop-down to make this Masterdata record applicable to the Main Contract and Amendment or both: 
    • Main Contract: Select this if you want to make the Client App Entity Mapping Masterdata applicable to the main Contract.
    • Amendment: Select this if you want to make the Client App Entity Mapping Masterdata applicable to the Amendment added to the main Contract. 
    • Both: Select this if you want to make the Client App Entity Mapping Masterdata applicable to the main contract and the Amendment added to it.

5. Click Save to save the Masterdata record and enable mapping between ICM and Workday.

Creating Client App Masterdata Sync 

You can create a Masterdata record for the Contract Type Masterdata that you created earlier. This helps synchronize the Masterdata between Workday and ICM. 
To create a Masterdata record:
1.Click Configuration on My Dashboard. The Configuration page opens. 

RTENOTITLE
 
2. Click Masterdata on the Configuration page. The Masterdata page opens.
RTENOTITLE
 
3. Click Create Masterdata on the Masterdata page. The Create Masterdata page opens.
 
RTENOTITLE 
 
4. Complete the information in the following sections. 
  • Masterdata Details
  • Attributes
5. Click Next at the end of Masterdata Details section to go to the Attributes section and complete creating the Masterdata record. 
 
Masterdata Details
 
This section displays the categories you can select and the Masterdata Contract Type for creating the Masterdata record. 
1. Select the category from the drop-down list. 
 
RTENOTITLE
 
2. Select the Contract Type Masterdata that you created earlier. For mapping the data between ICM and Workday, select Client App Masterdata Sync.
3. Click Next. The Attributes section is displayed. 
 
Attributes
This section shows the attributes that you created when creating the Contract Type Masterdata.
 
RTENOTITLE

4. Enter the following details in the following fields.

  • Masterdata Code: Every Masterdata record you create is assigned a unique ID. It is generated automatically when you create the Masterdata.
  • Name: Type the name of the Masterdata record you are creating for mapping with Workday. Ensure that the name you give to the Masterdata record is unique and can be identified easily. For example, you can use WD_Supplier_Name for mapping: 
  • Client Name: Defines the mapping with the external system. For example, select Workday from the Client Name drop-down to define the mapping between ICM and Workday. 
  • ICM Entity Name: Type the ICM Agreement Contract Type for which you are creating the mapping between ICM and Workday.
  • Client Entity Name: This is the Workday side entity name for which you are defining the mapping between ICM and Workday.
  • ICM Reference Key: Type the ICM Reference Key value in this field. This is used to track the Masterdata in Workday that was created in ICM.
  • Client Reference Key: Type the Reference attribute to be entered from Workday.
  •  Data Retrieval Filter Criteria: Select from one of the following options: 
    • From Date: Select this option to map the data with Workday from a specific date. 
    • From Last Run: Select this option to synchronize the data with Workday since the time this operation was last performed.
  • Data Retrieval Filter Criteria: Select from one of the following options: 
     
    • From Date: Select this option to map the data with Workday from a specific date. 
    • From Last Run: Select this option to synchronize the data with Workday since the time this operation was last performed. 
  • Effective Date: Select the date using the calendar control from which the data should be mapped with Workday.

Creating a Supplier Contract in ICM 

Supplier Contract is an Agreement in which the seller promises to provide the specified goods or services to the buyer on an agreed date at the agreed price. 
The exact process of creating a Supplier Contract in ICM depends on how the workflow is implemented in your organization. 
To create a Supplier Contract in ICM: 
1.Click Agreement Management on the Dashboard. The Agreement Management page opens.

RTENOTITLE
 
2. Click Create Agreement on Agreement Management page. The Create Agreement page opens.
 
RTENOTITLE
 
To create a new Agreement, provide the details in the sections mentioned below: 
  • Contract Type Details
  • Attributes
  • Select Template
  • Verify
Contract Type Details

Provide the following basic details of the Agreement in this section. 
  • Category: These are used for organizing the Agreements and are created by the administrator. The drop-down shows all the categories created while creating the Contract Type. Select the desired category from this drop-down. 
  • Contract Type Name: This shows the list of Contract Types that were created for the selected Category in the earlier step.
  • Type of Paper: Select either Own or Third party Template for creating the Agreement. Provide your own Template if you select Own type of paper. Select Third Party option when you want to create the Agreement by uploading the Template provided by the vendor. 

Of the four sections mentioned above, the Select Template section only appears for Own type of paper. The two options for Type of Paper are: 

  • Own: If you select Own type of paper, the Select Template section is displayed with the list of Templates available for the selected Contract Type. Note that, selecting Own Type of Paper provides you with the option to use either Own or Third Party paper for the Agreement you are creating. 
  • Third: If you select Third Party type of paper, the Select Template section is not displayed and you will have to upload the Template provided by the vendor manually. 

3. Click Next. The Attributes section is displayed.

RTENOTITLE

Attributes

This section captures the important details of the Agreement you are creating. The attributes appearing on this page vary according to the Contract Type you select. Following is an explanation of some of the less obvious attributes:

  • Organization Unit: Select the organization unit in which you want to create this Agreement. Users within an organization unit must have specific privileges to take any action on the Agreement. For example, users with View privilege can only view the Agreement whereas users with Manage privilege can perform actions on the Agreement. 
  • Contract Name: Specify a name for the Agreement you are creating. Note that the name must be unique and easily identifiable. This helps in tracking the Agreement easily.
  • Agreement Code: Each Agreement is assigned a unique ID known as its Agreement Code. It is generated automatically on clicking the Create button to create the Agreement

4. Click Next. The Select Template section is displayed.

Select Template

This section displays the Templates that are available for the selected Contract Type. This section is available only if you select Own Type of Paper while creating the agreement. Select the appropriate Template in this section and click Next. The Verify section is displayed. 

RTENOTITLE

Verify

This is the final step for creating the Agreement. It displays only the sections and attributes that you have used for creating this Agreement. Verify all the details you have entered. On this page, you can: 

  • Click Previous to go back and make changes to the Agreement. Click Next to return to this section after making the required changes and create the Agreement. 
  • Click Create to create the Agreement. The Agreement will not be visible to anyone except the user who created it, until it is published. 
  • Click Create and Publish to create and publish the Agreement. After publishing, other users with adequate access can search, view and take actions on the Agreement. After publishing, a Draft watermark appears on the Agreement until it is approved.
  •  Click Create and Send for Approval to create and send the Agreement for approval. The Agreement is sent for approval to the approvers that are set by a rule on the Contract Type selected for this Agreement and the status changes to Waiting for Approval. If no rules are defined and no approvers are set, the Agreement status automatically changes to Approved.
  • Click Discard to delete the Agreement you are creating. 

Sending an Agreement Document from ICM to Workday

ICM provides the ability to send Agreement documents from ICM to Workday.  You can create an Agreement using Own and Third Party Type of Paper to send the Agreement document in .docx and .pdf format from ICM to Workday. 

Sending the .docx version of Agreement from ICM to Workday

If you have already configured sending an Agreement document in .docx or .pdf format, modify the Contract events and also the document format , else you must create the Client App Entity Mapping Masterdata using the steps mentioned in the Creating Client App Entity Mapping section.

1. Click Configuration on the Dashboard. The Configuration page opens.

RTENOTITLE
2. Click Masterdata on the Configuration page. The Masterdata page opens.
 
RTENOTITLE

3.Click the icon next to the Client App Entity Mapping Masterdata. The Client App Entity Mapping page opens.

RTENOTITLE

4.Set the value of ICM Attribute Name Attribute as Contract_Assembled_Doc and the value of Client Attribute Name as Supplier_Contract_Data#Attachment_Data and the value of Contract Events as Created/ Published to send the Agreement document in .docx format from ICM to Workday.     

Send Agreement doc to Workday.png
 
Note: You can send the .docx version of Agreement to Workday only after the Agreement is published. 

Sending the .pdf version of Agreement from ICM to Workday

If you have already configured sending an Agreement document in .docx or .pdf format, modify the Contract events and also the document format , else you must create the Client App Entity Mapping Masterdata using the steps mentioned in the Creating Client App Entity Mapping section.

To send the .pdf version of Agreement to Workday: 

1. Repeat steps 1-3 from the Sending the .docx version of Agreement from ICM to Workday section and then perform the below step. 

2. Set the value of ICM Attribute Name attribute as $Contract_Assembled_Pdf and the value of Client Attribute Name as Supplier_Contract_Data#Attachment_Data and the value of Contract Events as Created|Published| Updated to send the Agreement document in .pdf format from ICM to Workday.  

Send Agreement pdf to Workday.png
 
Note: You can send the .pdf version of the Agreement to Workday only after the Agreement is approved. 

Viewing the Supplier Contract in Workday

ICM integrates with Workday and provides capability of viewing and updating the Supplier Contracts in Workday that are originally created in ICM. When a Supplier Contract is created in ICM, it is synchronized in Workday. Any updates and amendments made to the ICM Contract are auto-synchronized and get reflected in Workday.

Note: Any Amendments created in ICM will not reflect as separate amendment documents in Workday, but the main Supplier Contract will directly reflect the respective changes, and a Note will be added in Workday to indicate that the Contract has been amended in ICM.

ICM integration with Workday allows you to only view the Contract in Workday. After you create a Supplier Contract in ICM, you can view it in Workday using the following process: 
1. Log on to Workday as an Integration System user provisioned in ICM and Workday. 
2. Type Find Supplier Contract in the text box on the Welcome page. The Find Supplier Contracts page opens. 


RTENOTITLE

3.Type the Contract name you entered in ICM in the Contract Name field on Find Supplier Contract page.

RTENOTITLE

4. Click OK. The Report Criteria page opens showing the list of relevant Contracts. 

RTENOTITLE

5. Click the magnifying glass icon under Supplier Contract. The Contract Information page opens showing the details of the Contract created in ICM. 

RTENOTITLE

Viewing the Agreement document in Workday

The .docx and .pdf are displayed under the Contract record on the View Supplier Contract page under Catalog Item Pricing section. 

Workday Side Configuration

Administrator from Workday end must create the following domain security policy permissions for creating Workday Integration security groups.
Note that, the domain security policy permissions provided below are just an example of the various security policies the Workday administrator will have to create.


RTENOTITLE
 

ICM-Workday Adapter Support for Amendments

Previously, the ICM-Workday integration supported only Supplier contract agreements.

With this release, the ICM-Workday adapter has been enhanced to support amendments for Supplier contracts. Therefore, amendments that are created or updated in ICM are automatically synchronized with Workday, thus saving time and avoiding data duplication. 

Sending Amendments from ICM to Workday

The ICM-Workday integration provides the ability to automatically synchronize amendments in Workday that are created or updated in ICM.

To enable mapping between ICM and Workday, the following Masterdata Contract Types should be configured in ICM:

Client App Cross Reference

This maps ICM Supplier Contract amendments with Workday Supplier Contract entities.

To create Client App Cross Reference:

1. Click Configuration. The Configuration page opens.

7.10 Workday Adapter Enhancements for Amendment 1.png

2. Click Masterdata. The Masterdata page opens.

7.10 Workday Adapter Enhancements for Amendment 2.png

3. Click Create Masterdata. The Create Masterdata page opens.

7.10 Workday Adapter Enhancements for Amendment 3.png

This page contains the following tabs:

7.10 Workday Adapter Enhancements for Amendment 4.png

Masterdata Details

1. Select the Category from the drop-down. For example, Default.

2. Select the Masterdata Contract Type.

Note: In order to map ICM Supplier Contract amendments with Workday Supplier Contract entities, you must select Client App Cross Reference from the drop-down.

3. Click Next. The Attributes page opens.

Attributes

7.10 Workday Adapter Enhancements for Amendment 5.png

Provide relevant attribute values in the respective fields:

7.10 Workday Adapter Enhancements for Amendment 6.PNG

The Client App Cross Reference created is displayed as shown in the screenshot below:

7.10 Workday Adapter Enhancements for Amendment 7.png    

Setting the value of the attribute External Amendment Creation Event to AmendmentCreated will automatically synchronize any amendment created in ICM with Workday. Similarly, setting the value of the attribute External Amendment Update Event to AmendmentPublished, AmendmentUpdated, AmendmentApproved or AmendmentExecuted will automatically synchronize any amendment published, updated, approved or executed respectively in ICM with Workday.

Client App Entity Mapping

This maps ICM Supplier Contract amendment attributes with Workday Supplier Contract amendment attributes. Therefore, when an amendment is created or updated in ICM, all Supplier contract amendment attributes are automatically synchronized with Workday. For example, to map the attribute Name between ICM and Workday, you must create the Client App Entity mapping.

1. Click Configuration. The Configuration page opens.

7.10 Workday Adapter Enhancements for Amendment 1.png

2. Click Masterdata. The Masterdata page opens.

7.10 Workday Adapter Enhancements for Amendment 2.png

3. Click Create Masterdata. The Create Masterdata page opens.

7.10 Workday Adapter Enhancements for Amendment 3.png

This page contains the following tabs:

7.10 Workday Adapter Enhancements for Amendment 8.png

Masterdata Details

1. Select the Category from the drop-down. For example, Default.

2. Select the Masterdata Contract Type.

Note: In order to map ICM Supplier Contract amendment attributes with Workday Supplier Contract amendment attributes, you must select Client App Entity Mapping from the drop-down.

3. Click Next. The Attributes page opens.

Attributes

7.10 Workday Adapter Enhancements for Amendment 9.png

Provide relevant attribute values in the respective fields:

7.10 Workday Adapter Enhancements for Amendment 10.PNG

Note: Repeat the steps under Client App Entity Mapping to map any attributes from ICM to Workday.

The Client App Entity Mapping created is displayed as shown in the screenshot below:

7.10 Workday Adapter Enhancements for Amendment 11.png

Creating Supplier Contract Amendments in ICM

1. Click Add Amendment on the agreement Details page.

7.10 Workday Adapter Enhancements for Amendment 12.png

2. Modify the Contract Start Date, Contract End Date and the Contract Value to make amends to the original agreement.

3. Create the amendment.

 7.10 Workday Adapter Enhancements for Amendment 13.png    

Viewing Supplier Contract Amendments in Workday

1. Log on to Workday.

2. Type Find Supplier Contract in the textbox on the Welcome page. The Find Supplier Contracts page opens. 

 

3. Type the Contract Name you entered in ICM in the Supplier Contract Name field.

7.10 Workday Adapter Enhancements for Amendment 15.png

4. Click OK. The Report Criteria page opens. 

7.10 Workday Adapter Enhancements for Amendment 16.png

3. Click the  icon under Supplier Contract. The Contract Information page opens. The amendment created in ICM is automatically updated in Workday as shown in the screenshot below: 

7.10 Workday Adapter Enhancements for Amendment 18.png

Note:

  • In ICM when an amendment is added, a new agreement gets created with a link to its parent agreement. However, in Workday, when an amendment is created, it updates the underlying contract and maintains a history of the changes being done.
  • If the status of an amendment is Draft in ICM, its status in Workday is Amendment In Process. Similarly, if the status is Approved or Executed in ICM, the status in Workday is Approved.
  • ICM allows an approved amendment to be updated. However, in Workday, amendments with the status In Progress or Draft can only be updated.
 

Related Topics: Agreement Management