1 2 3 8 Previous Next

SAP Sourcing

107 Posts

The New SAP Sourcing & CLM DOCX Generation service

(SAP Sourcing & CLM 7.0 SP5)

Introduction

 

As we all know that SAP Sourcing & CLM can use the Microsoft .NET-based WordService to generate structured clause documents, collection variables documents and contract document templates. The Microsoft .NET-based WordService requires setup of an additional Windows server. Due to this overhead and additional TCO SAP Sourcing & CLM now with SAP Sourcing & CLM 7.0 SP5* also supports WordService based on JAVA technology. This new wordservice is called SAP Sourcing DOCX Generation Service. The does not require an additional Windows server.

Customers must enable SAP Sourcing for either the .NET service or the SAP Sourcing DOCX Generation Service, not for both services.

 

Comparison between .NET service and SAP Sourcing DOCX Generation Service

 

Microsoft .NET-based WordService

New SAP Sourcing DOCX Generation Service

Higher TCO

Lower TCO

Requires setup of an additional Windows server

No additional server required

Supports .doc & .docx format

Supports only MS 2007 .docx format

Available in all 7.0 and 9.0 versions

Available from SAP Sourcing & CLM 7.0 SP 5 onwards*

 

Enabling SAP Sourcing DOCX Generation Service

To use the SAP Sourcing DOCX Generation Service, you must first convert all legacy contract clauses, collection variables documents, and contract document templates to .docx and .dotx formats. Therefore, you must have the .NET WordService enabled in order to convert these document types. After the conversion, disable .NET WordService.

NOTE

Customers new to SAP Sourcing & CLM, and those who have not yet configured WordService, should set up the SAP Sourcing DOCX Generation Service.

We also recommend that customers with SAP Sourcing & CLM already installed and WordService already configured should update directly to the SAP Sourcing DOCX Generation Service as well. However, these customers may instead update Microsoft .NET WordService to the latest version.

 

 

Steps involved for enabling SAP Sourcing DOCX generation service.

 

a)    Take a backup of your whole database

b)    Log on as a member of the administrator group. Make sure WordService is enabled. Select Setup->System Properties. Select Contractgen.wordservice.enabled.

If contractgen.wordservice.enabled is not listed, create the property by clicking New, and add it. Then, if the DB Importer is run with the system context, set this property in the system portal. Select Edit. In the Value field, type TRUE, and select Save.

c)    Convert .DOC and .DOT files to .DOCX and .DOTX respectively: With new SAP Sourcing DOCX Generation service, CLM supports only .docx and .dotx formats. Convert the legacy .doc and .dot files to .docx and .dotx respectively with the conversion script provided in DB Importer.  Find DB Importer on the Sourcing server, in the Sourcing bin subdirectory.

Invoke the DB Importer tool. For Linux servers, invoke dbimport.sh. For Windows servers, invoke dbimport.bat. On the Setup tab, select the fcieso.jar file. Navigate to the com/sap/eso/odp/install/scripts/upgrade directory, and select the convert_doc_to_docx.xml script file. Run the upgrade script, convert_doc_to_docx. This script converts all the existing contract .doc and .dot files to .docx and .dotx respectively.

Pic 1.png

d)    After testing the SAP Sourcing DOCX Generation Service thoroughly, and checking your documents, disable WordService. Select Setup->System Properties. Select Contractgen.wordservice.enabled . Select Edit. In the Value field type FALSE, and select Save. Setting the FALSE value to this system property will automatically enable new word service

pic 2.png

 

NOTE

Customers new to SAP Sourcing, and those who have not yet configured WordService, should set up the SAP Sourcing DOCX Generation Service.

We recommend also that customers with SAP Sourcing already installed and WordService already configured should update directly to the SAP Sourcing DOCX Generation Service as well. However, these customers may instead update Microsoft .NET WordService to the latest version.

The SAP Sourcing DOCX Generation Service generates and works with documents only in .docx or .dotx formats. For example, you cannot upload .doc or .dot files to the SAP Sourcing DOCX Generation Service. Therefore, to use the SAP Sourcing DOCX Generation Service, you must convert your legacy .doc and .dot files to .docx and .dotx formats.

* Enabling SAP Sourcing DOCX Generation Service on the SAP Sourcing & CLM 9.0 and its various SP’s is still in development.

Overview

Installing multiple language packs can be time consuming.  To help with the process, we are providing an unattended option to allow for an easy reproducible method to load or reload language packs.   For each language , two install scripts are required.  This procedure leverages the command line option of DBIMPORT to script these imports all at once without using the UI.  Logs will be created as they would when using the UI. And an overall output of the import activity can be collected and reviewed afterwards.

 

Preparation

Edit a copy of the Template.  (see Appendix A)

For each language add a section and change the settings in RED to the appropriate values for that language as follows:

echo ---------SWEDISH-------------

echo Start ODP/sv ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ODP/sv/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

@IF %ERRORLEVEL% NEQ 0 GOTO END

echo ODP/sv complete

echo Start ESO/sv ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ESO/sv/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

echo ESO/sv complete

@IF %ERRORLEVEL% NEQ 0 GOTO END

  

 

Execution

Once you have your modified version of the multi-lang.cmd file,  Copy it to a location of your choice. I chose to put it in <FCI_HMOMEDIR>/bin  You may choose a different place, that’s fine, since the path to DBIMPORT is included in the batch file.

  1.       Shut down the application.

  2.       Backup your database.

  3.       At a DOS Command prompt>

            CD to <FCI_HOMEDIR>/bin

  4.       Enter @multi-lang.cmd > out.txt  (this creates a file out.txt with all the standard output for review later)

  5.       Wait for this to finish

  6.       Review out.txt

7.       Review the two logfiles produced for each language. (located in <FCI_HOMEDIR>/logs.)

  8.       Start the application and check that the languages were installed properly.

 

Verification

Check for the expected language packs.

 

1.png

 

 

Check for mail templates for each language.

 

 

2.png

 

 

Individual localized resource:

 

3.png

  

 

Login Page:

 

4.png

 

 

 

 

 

 

APPENDIX A – The template.  (multi-lang.cmd) This template includes German, Swedish, French…

@echo off

REM This is a template for executing multiple language imports

REM Please add/remove appropriate language codes before installing.

REM Please modify the system password before proceeding

REM --------------------------------------------------------------------------------

REM              Deutsch   : de (german)

REM              English      : en

REM              Spanish        : es (spain)

REM              French      : fr (France)

REM              Italiano     : it

REM              Nederlands     : nl (Dutch)

REM              Portuguese                    : pt (Brazilian)

REM              Turkish      : tr

REM              Russian     : ru

REM              Chinese    : zh

REM              Japanese                         : ja

REM              Korean                              : ko

REM              Danish       : da

REM              Swedish   : sv

REM              Polish        : pl

REM              Slovak        : sk                

REM              Hungarian                       : hu

REM              Finnish      : fi

REM              Czech                                 : cs

REM ------------------------------------------------------------------------------------

echo ---------GERMAN-------------

echo Start ODP/de ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ODP/de/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

@IF %ERRORLEVEL% NEQ 0 GOTO END

echo ODP/de complete

echo Start ESO/de ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ESO/de/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

echo ESO/de complete

@IF %ERRORLEVEL% NEQ 0 GOTO END

echo ---------SWEDISH-------------

echo Start ODP/sv ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ODP/sv/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

@IF %ERRORLEVEL% NEQ 0 GOTO END

echo ODP/sv complete

echo Start ESO/sv ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ESO/sv/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

echo ESO/sv complete

@IF %ERRORLEVEL% NEQ 0 GOTO END

echo ---------FRENCH-------------

echo Start ODP/fr ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ODP/fr/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

@IF %ERRORLEVEL% NEQ 0 GOTO END

echo ODP/fr complete

echo Start ESO/fr ......

call dbimport.bat -nogui -c:system -u:system -p:manager90 -f:classpath:///i18n/ESO/fr/install_language.xml

echo ERRORLEVEL =  %ERRORLEVEL%

echo ESO/fr complete

@IF %ERRORLEVEL% EQU 0 GOTO DONE

REM the end....

:END

echo ERROR detected

:DONE

echo all is well

This eLearning video teaches the simplest procedure a purchaser could use for creating a contract with SAP Sourcing. It covers selecting contract document templates and types, adding and removing clauses, adding and removing sections, defining variables, and generating contracts.

 

Creating Contracts with SAP Sourcing

 

This video, along with numerous other training videos and documents for SAP Sourcing, can be found on the How To playlist of the YouTube channel, SAP's Procurement Solutions.

SAP posted a revised version of the Upgrade Guide for SAP Sourcing 7.0 On-Premise for Oracle database systems. To download a PDF copy of the guide, go to Service Marketplace, and browse to the SAP Sourcing 7.0 page.

HI All,

 

We are implementing CLM 9,0 with contract generation on NW 7.3 SPS06 ( JAVA)

 

Following concerns or thoughts we came accross.

 

1) CLM application can point to use LDAP as well as NW UME as ( data source): even there are others.. but my focus is in these 2.

 

I would like to know.. what should be best approach and is there any difference in both cases. In terms of roles, CLM  security profiles assignments.

I believe in either case access level will remain with in CLM and only authentication could happen via LDAP or via NW UME.

 

2) We also like to use Portal SSO to CLM. I have seen some blogs.. that it is possible. But again not sure.. how would our access assignment should work.

 

I have seen config guide , security guide already but i could not find the best recommended approach.

 

Basically is there any difference in-terms of how CLM will behave when it comes to access control and assignment in both the cases.

 

I have seen this link in the forum as: http://scn.sap.com/community/sourcing/blog/2012/11/07/sourcingclm-7-sp3-and-netweaver-ume-authentication-the-sap-way

 

which says we can point NW JAVA UME to LDAP and let CLM use NW-UME as driver. Would this be the best approach suggested?

 

 

Just thought of getting some inputs for por's and cons' if possible. Thanks

In the past weeks our team has often received requests about best practices with regards to database installations for SAP Sourcing/CLM. The main questions which have been posted via customer support as well as SCN is: "Is SAP Sourcing/CLM required to be on the same or a separate database from the Application Server NW Java?". The short answer would to this question would be: "It is technically feasible to install on the same database instance, but it is strongly recommended to install on a separate database"

 

When purchasing a license to deploy SAP Sourcing/CLM on-Premise, the recommendation from a technical perspective is to use one database for the application server (NetWeaver Java) and one database for the application itself. There are several reasons why this is a good idea:

  • Potential performance improvements
  • Less constraints in planning and execution of upgrade strategy
  • Easier version control since NetWeaver and SAP Sourcing do not have to use the same DBMS version
  • Higher flexibility in backup and restore strategy
  • Pick a DBMS such as SQL Server or MAX DB for Netweaver but ONLY DB2 and Oracle are supported for Sourcing / CLM.

 

For further references on the installations procedures, please read the installations guides on the Service Marketplace (www.service.sap.com/eso). Our team has also contributed some more knowledge on best practices related to the database usage:

While, addressing Contract Generation messages over the past year I took a step back and noticed an emerging pattern with issues pertaining to the configuration area.  Please, note the following checklist.

 

 

Checklist Document for Contract Generation

1)      Upload a simple text document as clause document and check if it works.  This will generally tell you if all of Contract Generation is affected or if it is affecting just specific documents.

2)      If you are  not able to do this successfully, then see section 1.0

3)      If the wordservice is working fine but the clause still doesn’t upload, then

4)      Go to the wordservice machine

5)      Go to C:\fci\logs and get the latest log file

6)      Scroll to the very end of the file and look for the following:

7)      If the error has one of the following statements:

a.       “remote procedure call failed”

b.      “HKEY CLASS ID”

c.       “Exception from HRESULT: 0x8001010A” etc

It might be related to Microsoft Word issues. See Section 4.0

8)      If the logs have errors related to permissions then it could be permissions setup for OfficeAutomationUser for which you need to check DCOMCNFG settings. Refer Section 5.0

 

Section 1.0  Checklist to ensure that the wordservice is up and running

a.       Login to the wordservice machine as OfficeAutomationUser

b.      Open IIS

c.       Click websites and select wordservice. Select the wordservice.asmx from the content view.

d.      Right click and select browse.

e.      The wordservice should be working fine. Else see section 2.0

 

Section 2.0  Config Issues checklist

a.       The wordservice page should tell you the nature of the error.

b.      If it is related to user logon or password then it might be issue with the password for the Office Automation user. Then, do section 3.0

 

 

Section 3.0 OfficeAutomationUser password issues.

a.       Go to wordservice installation directory (mostly c:\inetpub\wwroot\Wordservice)

b.      Open the web.config

c.       Copy the xml from the identity section (These details are there in the installation guide too)

d.      Then paste in the web.config file that found in the MachineDPAPI directory

e.      Change the username to OfficeAutomationUser with the domain name and the correct password

f.        Run the aspnet command in the Visual studio command prompt

g.       Now check the wordservice link from IIS again to verify it worked

 

Section 4.0 Microsoft Word Issues

a.       Check if you are able to open Microsoft Word properly

b.      No pop-ups should be there

c.       You should be able to create and save a document properly

d.      Go to task manager check under processes (select show processes for all users) and see if WINWORD.exe is running.

e.      End the process

f.        Go to IIS and click on the wordservice link and then check task manager again.

g.       WINWORD.exe should be present

h.      Upload a clause.

i.         If you still see the same errors in the logs then you might need to uninstall and reinstall Microsoft Word

j.        Make sure you use the OfficeAutomationUser when you reinstall MS Word.

k.       Make sure that MS Word is activated by going to help page.

l.         After reinstalling check for fci.xsd (schema) in Microsoft Word (details in Installation guide).  Also make sure that there are no message/dialog boxes showing when you launch MS Word

 

Section 5.0 Permission issue with launching Microsoft Word

1.       Make sure that the following folders are created in your system.

  \Windows\SysWOW64\config\systemprofile\Desktop

   \Windows\System32\config\systemprofile\Desktop

 

 

2.       Verify if permissions are given to all the users in the DCOMCNFG as given in the installation document.

If, there is still an issue then provide us a screen shot of permissions given to each of the below user  under Launch and Activation and Access Permissions

Console Root->Component Services->Computers->My Computer and right-click Properties.

INTERACTIVE

Everyone

Administrators

OfficeAutomationUser

ASPNET

NETWORK

NETWORK SERVICE

 

Sara Noy

The SAP Sourcing training videos that have been available on the SAP Sourcing Training and eLearning Offerings page on SCN now reside on SAP's Procurement Solutions channel on YouTube. Streaming these videos via YouTube makes them available to a broader audience, including those with YouTube apps on their phones and other mobile devices. On YouTube, browse to SAP's Procurement Solutions channel, and select the How To playlist, or click here.

Register today for Ardent Partners' webcast, "CPO Rising: Keeping Score."


A newly released and groundbreaking procurement research report from Ardent Partners draws on the perspective of more than 270 Chief Procurement Officers and other procurement executives to deliver a comprehensive, industry-wide view into what is happening in the world of procurement today.

Join in on March 14 at 11 a.m. ET as report author Andrew Bartolini, Chief Research Officer at Ardent Partners, leads an interactive webcast discussing the key findings of this report.

This webcast will:

* Provide a comprehensive view of the current state of procurement
* Look at the continuing evolution of the role of the Chief Procurement Officer and its level of engagement and alignment within the enterprise today
* Provide an assessment of the general progress of the procurement function by analyzing the current state of its people, process, and technology
* Highlight procurement performance and operational benchmark statistics, and present a profile of Best-in-Class performers and their distinguishing characteristics
* Present a series of recommended strategies and approaches for CPO's and procurement departments to improve their performance
* Offer case studies and quotes from globally recognized procurement leaders

 

In addition, SAP will provide some insight into the new Ariba Acquisition, what this means for customers, and what they should expect now and in the future.

 

We look forward to seeing you online!

Register here - http://spr.ly/6038VfJs

We had a situation in CLM Production where some contract documents were stuck in approval phases and we were unable to unlock them.

 

As is the case in most organizations, we have contract document approvals / rejections after the respective Legal / Finance / Sourcing team approves or rejects the contract. If it is approved, it moves to Approved phase and when it is rejected it moves back to Draft (or initial) phase for the contract owner to make changes and resubmit. There were a handful of contracts (~31) which were stuck in their approval phases and had remained locked even after approval / rejection.

 

SAP Basis team restarted the ODP_Workflow_Event Daemon and also restarted the application. What we could not do was to take those contracts out of locked phase as the Edit button was no longer there nor did the Legal / Finance / Sourcing teams and the contract owners had the ability to unlock the contract.

 

We referred the post below and saw that Sys admin already has Break document lock as Allowed. Though we could never really find the button which said "Break Document Lock"

 

http://scn.sap.com/thread/1714106

 

We also canceled the workflow for these errant documents from Setup > Workflow definitions > Current workflow processes but when the user goes in to the contract, he/she still did not see the  Edit button.

 

Here is what we did to manually unlock these contract documents. We developed a toolbar script itilizing the IapiDocumentLockManager in our Development instance with the following parameters:

 

Contract document script view.png

 

This put a script option on all contract documents as below. In other words, this script provided an option on all contract documents in PROD with a Scripts > Unlock icon and we then had to manually go into each of the 31 contract documents that were stuck to unlock. We did all this on a Sunday to ensure no users were there in the system. Once we accomplished this, then the toolbar script was made Inactive.

 

Contract document script view.png

 

One tricky part was to identify which contracts documents were stuck. This was the most tedious part as there were many contract documents in approval phases for legitimate reasons and we didn’t want to unlock those unnecessarily.

 

We had to write a query for this to fetch those contract documents. Key here was to catch those contract documents which were not locked by “System”. As you know once you put the contract documents in any approval phase, system shows a message “Locked by System on….”. This message was not available on those contract documents that were stuck.

 

The query snippet that we wrote is as follows:

 

SELECT DISTINCT T1.UNIQUE_DOC_NAME, T1.DISPLAY_NAME,T2.DISPLAY_NAME, T2.CREATED_BY_USER_OBJECT_NAME

FROM DB2CLM.FCI_CONTRACT T1, DB2CLM.FCI_CONGEN_CONTRACT_DOC  T2,

DB2CLM.FCI_DOC_COLLABORATOR T3, DB2CLM.FCI_WORK_PROCESS T5

WHERE

T2.PARENT_OBJECT_ID=T1.OBJECTID

AND T1.INACTIVE = 0 

AND T2.OBJECTID in

(select docref_object_id from db2clm.FCI_DOC_LOCK t6

where lock_mode=1 and locked_by_object_name is null)

 

So by doing the above the problem was solved but the issue is we still dont know why it happened in the first place. We have raised an OSS message with SAP. We do have 2 servers in PROD for HA. Does it have any impact on the system if the Workflow engine Daemon is run on any of these service?

 

Thank you,

Vikram

 

VINOTH R

how to install sourcing 9.0

Posted by VINOTH R Feb 6, 2013

Hi,

 

     sourcing require NW7.3 SP03..

 

     i have to go for java installation or abap installation?

 

     then how to install sourcing??

 

     Pls help me for this..

 

vinoth

Rise and shine in 2013. The SAP Sourcing Team is offering another series of training covering the entire spectrum of functional, technical and integration training. Here are the details you need to know:

How can I sign-up ?

You can find the all training links by going to the SAP Training Website and search for desired training class (TSO100, TSO150 and/or TSO180):


When is it planned?

  • Newtown Square classes:
    • TSO100: May, 13 - May, 17
    • TSO150: June, 10 - June, 14

 

Where are these sessions?

 

What will be the content of these classes?

How can I learn more about SAP Sourcing/CLM 9.0?

Our Product Management Team has summarized the latest and greatest features of SAP Sourcing/CLM 9.0 in a blog series on:

 

Procurement organizations that are already using SAP ERP for operational procurement and want to introduce a more strategic Sourcing or Contract Lifecycle Management Solution like SAP Sourcing/CLM, are typically already following the concept of centralized purchasing in their company. Therefore it is important that this concept is also supported in the organizational model of the Sourcing/CLM solution. In this blog post I want to show you how this is supported in the standard integration package of SAP Sourcing with SAP ERP.

 

The following graphic illustrates the different ways how purchasing in the SAP ERP System can be organized.

04-01-2013 15-34-55.jpg

 

 

If purchasing is set up on a cross-company-code basis, the customer works with central purchasing organizations that are responsible for global outline agreements and the negotiation of the relevant terms and conditions. This means that the purchasing organization is active for more than one enterprise and, in organizational terms, is not linked to one specific company code or particular plants.

To do so, you set up your organizational model in SAP ERP in a way where you do not assign purchasing organizations to company codes. This purchasing organization can then procure for all plants assigned to it, irrespective of the company code to which the plant belongs.

 

How is this concept applied in SAP Sourcing/CLM ?

The relevant part of the organizational data model of SAP ERP is also present in the SAP Sourcing System and all relevant data, in particular Company Codes, Purchasing Organizations and Plants can be easily replicated into the System during the initial setup. There are standard tools available in SAP ERP like ABAP report BBP_ES_CUSTOMIZINGDATA_EXTRACT to extract these data. Corresponding import functions in SAP Sourcing allow a direct import of the extracted files. All data that are relevant for the centralized purchasing concept are included.

 

Creating integrated Cross-Company Master Agreements

When you create a Master Agreement in SAP Sourcing, you assign a purchasing organization, purchasing group and company code on the 'Integration' tab. If you use a central purchasing organization (no assignment to a company code), the system does not validate the assignment of line item plants to the company code that is maintained on the 'Integration' tab, which corresponds to the functionality in SAP ERP for centralized purchasing.

You can then publish your Master Agreement to your ERP System, where an Outline Agreement will be created. The ERP system is connected via PI using the standard integration package, which is available since SAP Sourcing 7.0 / Wave 6. The centralized purchasing concept is supported from SAP Sourcing  9.0 / Wave 9 SP02. There are options to enable this via custom scripting in Version 7.0. Please contact SAP Support or myself directly if you need additional information on this.

Overview:

In SAP Sourcing v9, the ability to integrate with multiple backend system has been introduced.  In order to support this integration, the concept of the relationship of the Business System for some Master Data objects has also been introduced. 

 

With this enhancement, there is now the possibility to have Master Data related to different Business Systems.  When there is a need to update existing Master Data to a different Business System, it is important to use a properly formatted file to avoid duplicating Master Data. 

 

In order to change objects that are already established within SAP Sourcing and that are identified as local to SAP Sourcing to being correctly marked as replicated from ECC, it is important to to use a properly formatted import file.  The key is to use a column with the heading of "CONVERT_TO_REPLICATED" which is set to "TRUE" for each of the business objects to be converted.  This must be used in addition to the BUSINESS_SYSTEM External ID. 

 

If the import file is created using the standard "IS_REPLICATED" column heading, the system will create those business objects as if they were new objects instead of updating the Business System on the existing objects. 

 

Related details can be found on Page 48 of the v9 SAP Upgrade Guide.  An excerpt from the guide is included below for your convenience:

 

CONVERT_TO_REPLICATED.PNG

Filter Blog

By author:
By date:
By tag: