CLM XML contract upload

[Former Member]

Hi all, Is there a specific format for the file upload in CLM? I'm trying to upload an XML but the file cannot be imported. I'm getting this error message: Messages: Import failed Import failed null Stack Trace: com.frictionless.api.common.exception.ApplicationException: Import failed at com.frictionless.api.common.exception.ChainedExceptionFactory.createApplicationException(ChainedExceptionFactory.java:111) at com.frictionless.api.common.exception.ChainedExceptionFactory.createApplicationException(ChainedExceptionFactory.java:141) at com.frictionless.sap.integration.util.SapIntUtil.createException(SapIntUtil.java:283) at com.frictionless.sap.integration.Importer.setError(Importer.java:395) at com.frictionless.sap.integration.Importer.goObjects(Importer.java:200) at com.frictionless.sap.integration.Importer.go(Importer.java:123) at com.frictionless.common.install.dataimport.xmliapi.XmlIapiImporter.go(XmlIapiImporter.java:87) at com.frictionless.install.actions.ProcessXmlIapiImportFile.executeHook(ProcessXmlIapiImportFile.java:103) at com.frictionless.install.actions.InstallAction.execute(InstallAction.java:202) at com.frictionless.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:302) at com.frictionless.install.engine.XmlIapiImportEngine.execute(XmlIapiImportEngine.java:102) at com.frictionless.install.imports.ImportController$ImportRunner.execute(ImportController.java:300) at com.frictionless.install.imports.ImportController$ImportRunner.run(ImportController.java:211) at java.lang.Thread.run(Thread.java:595) com.frictionless.sap.integration.util.ImportFailedException: Import failed at com.frictionless.sap.integration.importer.ObjectsXmlHandler.processObject(ObjectsXmlHandler.java:183) at com.frictionless.sap.integration.importer.ObjectsXmlHandler.endElement(ObjectsXmlHandler.java:111) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:375) at javax.xml.parsers.SAXParser.parse(SAXParser.java:176) at com.frictionless.sap.integration.importer.AbsXmlHandler.parse(AbsXmlHandler.java:69) at com.frictionless.sap.integration.Importer.goObjects(Importer.java:185) at com.frictionless.sap.integration.Importer.go(Importer.java:123) at com.frictionless.common.install.dataimport.xmliapi.XmlIapiImporter.go(XmlIapiImporter.java:87) at com.frictionless.install.actions.ProcessXmlIapiImportFile.executeHook(ProcessXmlIapiImportFile.java:103) at com.frictionless.install.actions.InstallAction.execute(InstallAction.java:202) at com.frictionless.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:302) at com.frictionless.install.engine.XmlIapiImportEngine.execute(XmlIapiImportEngine.java:102) at com.frictionless.install.imports.ImportController$ImportRunner.execute(ImportController.java:300) at com.frictionless.install.imports.ImportController$ImportRunner.run(ImportController.java:211) at java.lang.Thread.run(Thread.java:595) com.frictionless.api.common.exception.ApplicationException at com.frictionless.api.common.exception.ChainedExceptionFactory.createApplicationException(ChainedExceptionFactory.java:220) at com.frictionless.sap.integration.importer.ObjectsXmlHandler.processObject(ObjectsXmlHandler.java:186) at com.frictionless.sap.integration.importer.ObjectsXmlHandler.endElement(ObjectsXmlHandler.java:111) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:375) at javax.xml.parsers.SAXParser.parse(SAXParser.java:176) at com.frictionless.sap.integration.importer.AbsXmlHandler.parse(AbsXmlHandler.java:69) at com.frictionless.sap.integration.Importer.goObjects(Importer.java:185) at com.frictionless.sap.integration.Importer.go(Importer.java:123) at com.frictionless.common.install.dataimport.xmliapi.XmlIapiImporter.go(XmlIapiImporter.java:87) at com.frictionless.install.actions.ProcessXmlIapiImportFile.executeHook(ProcessXmlIapiImportFile.java:103) at com.frictionless.install.actions.InstallAction.execute(InstallAction.java:202) at com.frictionless.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:302) at com.frictionless.install.engine.XmlIapiImportEngine.execute(XmlIapiImportEngine.java:102) at com.frictionless.install.imports.ImportController$ImportRunner.execute(ImportController.java:300) at com.frictionless.install.imports.ImportController$ImportRunner.run(ImportController.java:211) at java.lang.Thread.run(Thread.java:595) java.lang.NullPointerException at com.frictionless.api.ibean.common.AbsIBeanHome.upgradeToEdit(AbsIBeanHome.java:344) at com.frictionless.sap.integration.importer.AbsContractImporter.process(AbsContractImporter.java:59) at com.frictionless.sap.integration.importer.AbsContractImporter.process(AbsContractImporter.java:32) at com.frictionless.sap.integration.importer.ObjectsXmlHandler.processObject(ObjectsXmlHandler.java:165) at com.frictionless.sap.integration.importer.ObjectsXmlHandler.endElement(ObjectsXmlHandler.java:111) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:375) at javax.xml.parsers.SAXParser.parse(SAXParser.java:176) at com.frictionless.sap.integration.importer.AbsXmlHandler.parse(AbsXmlHandler.java:69) at com.frictionless.sap.integration.Importer.goObjects(Importer.java:185) at com.frictionless.sap.integration.Importer.go(Importer.java:123) at com.frictionless.common.install.dataimport.xmliapi.XmlIapiImporter.go(XmlIapiImporter.java:87) at com.frictionless.install.actions.ProcessXmlIapiImportFile.executeHook(ProcessXmlIapiImportFile.java:103) at com.frictionless.install.actions.InstallAction.execute(InstallAction.java:202) at com.frictionless.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:302) at com.frictionless.install.engine.XmlIapiImportEngine.execute(XmlIapiImportEngine.java:102) at com.frictionless.install.imports.ImportController$ImportRunner.execute(ImportController.java:300) at com.frictionless.install.imports.ImportController$ImportRunner.run(ImportController.java:211) at java.lang.Thread.run(Thread.java:595) I

[tridip_chakraborthy · Accepted solution]

HI Xavier

what are you trying to import?

Have you scheduled a Scheduled tasks for import of a specific XML for SAP ECC and ES integration or something else.

the errors are cleary slating that an unknown source system thats being looked at.

Please notice your error closely

Import failed at com.frictionless.sap.integration.importer.ObjectsXmlHandler.processObject(ObjectsXmlHandler.java:183) at com.frictionless.sap.integration.importer.ObjectsXmlHandler.endElement(ObjectsXmlHandler.java:111) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at

If you are trying to perform the ECC integration then have you deployed the SAP Integration.jar file and re-deployed the fcsourcing.ear file and rebuilt the WAR files.

Please tell us what you are actually trying to achieve here?

Regards

Tridip

[Former Member · Accepted solution]

Hi, we're trying to integrate SRM and CLM by using XI 7.1. We have already converted the the fields of SRM (RFx) to an XML structure for the CLM to recognize but it seems that there is something wrong with the strucutre that we created. The file cannot be imported in the CLM system. In our ERP - CLM integration, the XML for both materials and vendors had no problems. CLM recognized those XML structures. So, I tried to imitate those structures but it didn't work..

[tridip_chakraborthy · Accepted solution]

Hi Xavier

Did you copy an existing interface and create proxy for the IDOC to XML conversion.

It is mandated that you create the Proxy if the contract had to be created on the SRM side the BAPI_CTR_CREATE to actually create the contract on the SRM side.

In your case since its an outgoing IDOC from SRM (RFx award) to creating a Contract, you need to check if the cross mapping of fields in XI are carried out properly (along with the field length), all extensions that need to be supported must also be included in the XML.

Further check if any proxy needs to be created, since am not sude if for IDOC to XML conversion, Proxy is mandated.

Please check on those aspects, may be thats the reason your XML isnt getting picked up though the structures are oK

Check with the PI consultant.

..kindly update the final approach here.

Regards

Tridip

[Former Member · Accepted solution]

There is no problem with the SRM fields. Problem is in CLM. We're not sure what format / structure it's accepting..

[tridip_chakraborthy · Accepted solution]

Xavier,

Please check below if the following fields are being passed correctly to CLM.

The MSA to Outline Agreement interface has the list of fields

Take the fields of the MSA as reference.

I've put the list, however please validate that these are being populated in SAP CLM

These are the fields that SAP CLM MSA passes for creating ERP outline agreement.

Header fields:

DOCUMENT DATE

CURRENCY

EFFECTIVE DATE

EXPIRATIONDATE

PAYTERMS

VENDOR

LIMIT VALUE

COMPANYCODE

PURCH. ORG

PURCH. GROUP

DOC TYPE

Item fields:

LINE ITEM NUMBER

PART NUMBER

DOCUMENT DESCRIPTION

MATERIAL GROUP

PLANT

QUANTITY

UNIT

ITEM CAT

PRICEUNIT

ACCT ASGN CAT

Pricing fields:

MIN QUANTITY

MAX QUANTITY

UNIT PRICE

Regards

Tridip

[Former Member · Accepted solution]

We have included the fields that you mentioned but the error is still the same. Thanks.

Right now, we're trying to copy the XML format that we exported from CLM. It's quite long and it includes ids and unique document names and schema ids. I'm not sure we will pull this one out..

[tridip_chakraborthy · Accepted solution]

Do a trial push of an IDOC and check if the IDOC is failing in PI

This might throw some light on what the interface is expecting

regards

tridip

[Former Member]

Hi Tridip

We have one requirement for integration of CLM 2.0 to SRM 4.0/5.0 using PI 7.1. i.e. whatever contracts created in CLM system that should be replicated in SRM system.

Please explain me the process like what are all the stpes I need to follow w.r.t structural conversion and Interfaces.

Awaiting your quick response...

Thanks in advance

M G REDDY

[Former Member]

There are two options:

1) export an OA from CLM then copy the XML structure of the exported file.

2) Use excel xslt transformation.

[Former Member]

Hi Xavier,

I am facing problem in uploading Contracts (master agreement) XML to CLM server.

Can you please guide me what has to be taken care while building contract XML while loading into CLM server.

I am trying as you said to copy xml, but the export xml is also of not much use.

Can you please guide me?

Thanks & Regards,

Yaseen M