What is the XML format for Sub Agreements?

[Former Member]

Hi,

We have requirement to automate loading Master Agreements and Sub Agreements into CLM from a non-SAP system. 

Currently the data is loaded using CSV files, but Double Byte Char. is not supported in CSV file format.

I am trying to load using XML format and have be successful to load  Master Agreement.

I need help with Sub Agreement XML Structure or a better alternative to load Sub Agreement metadata containing Double Byte Char. 

Provided below is the Sub Agreement XML Structure. Please provide suggestions or guidance on this issue.

We are on 7.0 SP8 .

Thanks
Sai

[Former Member]

Hello Sai,

      The XML format will be the same for a sub agreement. Do you see a problem during import of this XML ?. With regards to multibyte can you check and make sure that you have installed the SAP sourcing to support Unicode, if this is done and you have installed the Language packs there should not be any problems..

Regards

Prasad

[Former Member]

Hi Prasad,

Thanks for your quick response.

I am able to load successfully Project and Master Agreement in XML format with metadata containing multibyte char.

Multibyte char is displayed on Project and Master Agreement Screen.

English , German, Chinese, Japanese, Korean, Spanish, French and Italian language packs are installed in Sourcing.

I am getting below error while importing XML for Sub Agreement.

Record 1. Warning: XML import could not process field: CONTRACT_UNIQUE_DOC_NAME

Facility=local4;sessionid=bR6bHsKNs_s_sA8ihHdOSyOASPCvRgEP3icA_SAP;tenantid=#ebay#;username=sguntaka;exception=java.lang.IllegalArgumentException: unsupported null bind parameter no. 0 found in statement SELECT OBJECTID, CONTEXTID, REVISION_COUNT, UNIQUE_DOC_NAME, DISPLAY_NAME, COLLN_METADATA, RESERVATION_LOCK, DOCUMENT_DESCRIPTION, CREATED_BY_USER_OBJECT_ID, CREATED_BY_USER_CLASS_ID, CREATED_BY_USER_OBJECT_NAME, MODIFIED_BY_USER_OBJECT_ID, MODIFIED_BY_USER_CLASS_ID, MODIFIED_BY_USER_OBJECT_NAME, EDIT_BY_USER_OBJECT_ID, EDIT_BY_USER_CLASS_ID, EDIT_BY_USER_OBJECT_NAME, CREATED_AT, MODIFIED_AT, EDIT_AT_DATETIME, INACTIVE, TRACK_CHANGES, COLLABORATION_POLICY, HAS_PUBLIC_DISC, IS_TEMPLATE, CANCELED_BY_USER_OBJECT_ID, CANCELED_BY_USER_CLASS_ID, CANCELED_BY_USER_OBJECT_NAME, DOC_OWNER_USER_OBJECT_ID, DOC_OWNER_USER_CLASS_ID, DOC_OWNER_USER_OBJECT_NAME, CLOSED_BY_USER_OBJECT_ID, CLOSED_BY_USER_CLASS_ID, CLOSED_BY_USER_OBJECT_NAME, CANCELED_AT, CLOSED_AT, TEMPLATE_OBJECT_ID, TEMPLATE_CLASS_ID, TEMPLATE_OBJECT_NAME, DOC_TYPE_OBJECT_ID, DOC_TYPE_CLASS_ID, DOC_TYPE_OBJECT_NAME, BASE_DATE_DATE, SCHEDULE_WORK_DAYS, BUSINESS_UNIT_OBJECT_ID, BUSINESS_UNIT_CLASS_ID, BUSINESS_UNIT_OBJECT_NAME, COMPANY_OBJECT_ID, COMPANY_CLASS_ID, COMPANY_OBJECT_NAME, ESTIMATED_CURRENCY, ESTIMATED_OBJECT_ID, ESTIMATED_PRICE, BUDGETED_CURRENCY, BUDGETED_OBJECT_ID, BUDGETED_PRICE, CURRENCY_OBJECT_ID, CURRENCY_CLASS_ID, CURRENCY_OBJECT_NAME, VENDOR_VISIBLE, DATE_TO_PUBLISH_DATE, LOCK_BASELINE, LI_PERIOD_TYPE_OBJECT_ID, LI_PERIOD_TYPE_CLASS_ID, LI_PERIOD_TYPE_OBJECT_NAME, CALC_METHOD, SPEC_ID_COUNT, ATTR_ID_COUNT, FORMULA_ID_COUNT, PURCHASING_ORG_OBJECT_ID, PURCHASING_ORG_CLASS_ID, PURCHASING_ORG_OBJECT_NAME, PURCHASING_GRP_OBJECT_ID, PURCHASING_GRP_CLASS_ID, PURCHASING_GRP_OBJECT_NAME, TRANSACTION_TYPE_OBJECT_ID, TRANSACTION_TYPE_CLASS_ID, TRANSACTION_TYPE_OBJECT_NAME, COMPANY_CODE_OBJECT_ID, COMPANY_CODE_CLASS_ID, COMPANY_CODE_OBJECT_NAME, INTEGRATED_TYPE, USE_ERP_VALIDATION, STORAGE_LOCATION, RECORD_SERIES, RETENTION_DATE_DATE, RETENTION_REMINDER_DATE_DATE, RETENTION_EVENT_OBJECT_ID, RETENTION_EVENT_CLASS_ID, RETENTION_EVENT_OBJECT_NAME, EFFECTIVE_DATE_DATE, EXPIRATION_DATE_DATE, TERMIN_NOTICE_LEAD_TIME, TERMIN_COMMU_DATE, PERPETUAL_TERM, AUTO_RENEWAL, EVENT_OBJECT_ID, EVENT_CLASS_ID, EVENT_OBJECT_NAME, RENEWAL_REMINDER_DATE, VENDOR_OBJECT_ID, VENDOR_CLASS_ID, VENDOR_OBJECT_NAME, CONTACT_OBJECT_ID, CONTACT_CLASS_ID, CONTACT_OBJECT_NAME, LOCATION_OBJECT_ID, LOCATION_CLASS_ID, LOCATION_OBJECT_NAME, PAYTERMS_OBJECT_ID, PAYTERMS_CLASS_ID, PAYTERMS_OBJECT_NAME, REPLENISHMENT_OBJECT_ID, REPLENISHMENT_CLASS_ID, REPLENISHMENT_OBJECT_NAME, VENDOR_ACCT_NUM, INT_CAT_OBJECT_ID, INT_CAT_CLASS_ID, INT_CAT_OBJECT_NAME, EXT_CAT_OBJECT_ID, EXT_CAT_CLASS_ID, EXT_CAT_OBJECT_NAME, EVALUATION_CRITERIA, NEXT_AUDIT_DATE, LAST_AUDIT_DATE, TOTAL_EXPECTED_CURRENCY, TOTAL_EXPECTED_OBJECT_ID, TOTAL_EXPECTED_PRICE, TOTAL_BUDGETED_CURRENCY, TOTAL_BUDGETED_OBJECT_ID, TOTAL_BUDGETED_PRICE, TOTAL_ACTUAL_CURRENCY, TOTAL_ACTUAL_OBJECT_ID, TOTAL_ACTUAL_PRICE, TOTAL_SAVINGS_CURRENCY, TOTAL_SAVINGS_OBJECT_ID, TOTAL_SAVINGS_PRICE, TOTAL_COST_SAVINGS_CURRENCY, TOTAL_COST_SAVINGS_OBJECT_ID, TOTAL_COST_SAVINGS_PRICE, TOTAL_COST_AVOIDANCE_CURRENCY, TOTAL_COST_AVOIDANCE_OBJECT_ID, TOTAL_COST_AVOIDANCE_PRICE, PERF_EVAL_CRITERIA, PERF_LAST_UPDATE_DATE, PERF_NEXT_UPDATE_DATE, BUYER_SEARCHABLE, VAL_PERIOD_TYPE_OBJECT_ID, VAL_PERIOD_TYPE_CLASS_ID, VAL_PERIOD_TYPE_OBJECT_NAME, INCLUDE_PART_NUMBER, TOTAL_ACTUAL_SPEND_CURRENCY, TOTAL_ACTUAL_SPEND_OBJECT_ID, TOTAL_ACTUAL_SPEND_PRICE, FORECAST_SPEND_CURRENCY, FORECAST_SPEND_OBJECT_ID, FORECAST_SPEND_PRICE, ACTUAL_LIMIT_PCT, FORECAST_LIMIT_PCT, LINEITEM_ID_CNT, LIMIT_VALUE_CURRENCY, LIMIT_VALUE_OBJECT_ID, LIMIT_VALUE_PRICE, MINIMUM_VALUE_CURRENCY, MINIMUM_VALUE_OBJECT_ID, MINIMUM_VALUE_PRICE, MINIMUM_DAYS_OFFSET, MARGIN_PRICING, DELETED_AT_DATETIME, DELETED_BY_OBJECT_ID, DELETED_BY_CLASS_ID, DELETED_BY_OBJECT_NAME, CTR_IS_DUET, HAS_DUET_ITEMS, WORD_ATTRIBUTES_TEXT_PREVIEW, WORD_ATTRIBUTES_TEXT_OBJECT_ID, WORD_ATTRIBUTES_TEXT_CLASS_ID, WORD_ATTRIBUTES_CHECKSUM, SENT_TO_ERP_DATETIME, STATUS_OBJECT_ID, STATUS_CLASS_ID, STATUS_OBJECT_NAME, LAST_SPEND_IMPORT_DATE, BUYER_SPECS_SUPPORT, VENDOR_SPECS_SUPPORT FROM clmuser.FCI_CONTRACT WHERE UNIQUE_DOC_NAME = ? AND CONTEXTID = ?;stacktrace=java.lang.IllegalArgumentException: unsupported null bind parameter no. 0 found in statement SELECT OBJECTID, CONTEXTID, REVISION_COUNT, UNIQUE_DOC_NAME, DISPLAY_NAME, COLLN_METADATA, RESERVATION_LOCK, DOCUMENT_DESCRIPTION, CREATED_BY_USER_OBJECT_ID, CREATED_BY_USER_CLASS_ID, CREATED_BY_USER_OBJECT_NAME, MODIFIED_BY_USER_OBJECT_ID, MODIFIED_BY_USER_CLASS_ID, MODIFIED_BY_USER_OBJECT_NAME, EDIT_BY_USER_OBJECT_ID, EDIT_BY_USER_CLASS_ID, EDIT_BY_USER_OBJECT_NAME, CREATED_AT, MODIFIED_AT, EDIT_AT_DATETIME, INACTIVE, TRACK_CHANGES, COLLABORATION_POLICY, HAS_PUBLIC_DISC, IS_TEMPLATE, CANCELED_BY_USER_OBJECT_ID, CANCELED_BY_USER_CLASS_ID, CANCELED_BY_USER_OBJECT_NAME, DOC_OWNER_USER_OBJECT_ID, DOC_OWNER_USER_CLASS_ID, DOC_OWNER_USER_OBJECT_NAME, CLOSED_BY_USER_OBJECT_ID, CLOSED_BY_USER_CLASS_ID, CLOSED_BY_USER_OBJECT_NAME, CANCELED_AT, CLOSED_AT, TEMPLATE_OBJECT_ID, TEMPLATE_CLASS_ID, TEMPLATE_OBJECT_NAME, DOC_TYPE_OBJECT_ID, DOC_TYPE_CLASS_ID, DOC_TYPE_OBJECT_NAME, BASE_DATE_DATE, SCHEDULE_WORK_DAYS, BUSINESS_UNIT_OBJECT_ID, BUSINESS_UNIT_CLASS_ID, BUSINESS_UNIT_OBJECT_NAME, COMPANY_OBJECT_ID, COMPANY_CLASS_ID, COMPANY_OBJECT_NAME, ESTIMATED_CURRENCY, ESTIMATED_OBJECT_ID, ESTIMATED_PRICE, BUDGETED_CURRENCY, BUDGETED_OBJECT_ID, BUDGETED_PRICE, CURRENCY_OBJECT_ID, CURRENCY_CLASS_ID, CURRENCY_OBJECT_NAME, VENDOR_VISIBLE, DATE_TO_PUBLISH_DATE, LOCK_BASELINE, LI_PERIOD_TYPE_OBJECT_ID, LI_PERIOD_TYPE_CLASS_ID, LI_PERIOD_TYPE_OBJECT_NAME, CALC_METHOD, SPEC_ID_COUNT, ATTR_ID_COUNT, FORMULA_ID_COUNT, PURCHASING_ORG_OBJECT_ID, PURCHASING_ORG_CLASS_ID, PURCHASING_ORG_OBJECT_NAME, PURCHASING_GRP_OBJECT_ID, PURCHASING_GRP_CLASS_ID, PURCHASING_GRP_OBJECT_NAME, TRANSACTION_TYPE_OBJECT_ID, TRANSACTION_TYPE_CLASS_ID, TRANSACTION_TYPE_OBJECT_NAME, COMPANY_CODE_OBJECT_ID, COMPANY_CODE_CLASS_ID, COMPANY_CODE_OBJECT_NAME, INTEGRATED_TYPE, USE_ERP_VALIDATION, STORAGE_LOCATION, RECORD_SERIES, RETENTION_DATE_DATE, RETENTION_REMINDER_DATE_DATE, RETENTION_EVENT_OBJECT_ID, RETENTION_EVENT_CLASS_ID, RETENTION_EVENT_OBJECT_NAME, EFFECTIVE_DATE_DATE, EXPIRATION_DATE_DATE, TERMIN_NOTICE_LEAD_TIME, TERMIN_COMMU_DATE, PERPETUAL_TERM, AUTO_RENEWAL, EVENT_OBJECT_ID, EVENT_CLASS_ID, EVENT_OBJECT_NAME, RENEWAL_REMINDER_DATE, VENDOR_OBJECT_ID, VENDOR_CLASS_ID, VENDOR_OBJECT_NAME, CONTACT_OBJECT_ID, CONTACT_CLASS_ID, CONTACT_OBJECT_NAME, LOCATION_OBJECT_ID, LOCATION_CLASS_ID, LOCATION_OBJECT_NAME, PAYTERMS_OBJECT_ID, PAYTERMS_CLASS_ID, PAYTERMS_OBJECT_NAME, REPLENISHMENT_OBJECT_ID, REPLENISHMENT_CLASS_ID, REPLENISHMENT_OBJECT_NAME, VENDOR_ACCT_NUM, INT_CAT_OBJECT_ID, INT_CAT_CLASS_ID, INT_CAT_OBJECT_NAME, EXT_CAT_OBJECT_ID, EXT_CAT_CLASS_ID, EXT_CAT_OBJECT_NAME, EVALUATION_CRITERIA, NEXT_AUDIT_DATE, LAST_AUDIT_DATE, TOTAL_EXPECTED_CURRENCY, TOTAL_EXPECTED_OBJECT_ID, TOTAL_EXPECTED_PRICE, TOTAL_BUDGETED_CURRENCY, TOTAL_BUDGETED_OBJECT_ID, TOTAL_BUDGETED_PRICE, TOTAL_ACTUAL_CURRENCY, TOTAL_ACTUAL_OBJECT_ID, TOTAL_ACTUAL_PRICE, TOTAL_SAVINGS_CURRENCY, TOTAL_SAVINGS_OBJECT_ID, TOTAL_SAVINGS_PRICE, TOTAL_COST_SAVINGS_CURRENCY, TOTAL_COST_SAVINGS_OBJECT_ID, TOTAL_COST_SAVINGS_PRICE, TOTAL_COST_AVOIDANCE_CURRENCY, TOTAL_COST_AVOIDANCE_OBJECT_ID, TOTAL_COST_AVOIDANCE_PRICE, PERF_EVAL_CRITERIA, PERF_LAST_UPDATE_DATE, PERF_NEXT_UPDATE_DATE, BUYER_SEARCHABLE, VAL_PERIOD_TYPE_OBJECT_ID, VAL_PERIOD_TYPE_CLASS_ID, VAL_PERIOD_TYPE_OBJECT_NAME, INCLUDE_PART_NUMBER, TOTAL_ACTUAL_SPEND_CURRENCY, TOTAL_ACTUAL_SPEND_OBJECT_ID, TOTAL_ACTUAL_SPEND_PRICE, FORECAST_SPEND_CURRENCY, FORECAST_SPEND_OBJECT_ID, FORECAST_SPEND_PRICE, ACTUAL_LIMIT_PCT, FORECAST_LIMIT_PCT, LINEITEM_ID_CNT, LIMIT_VALUE_CURRENCY, LIMIT_VALUE_OBJECT_ID, LIMIT_VALUE_PRICE, MINIMUM_VALUE_CURRENCY, MINIMUM_VALUE_OBJECT_ID, MINIMUM_VALUE_PRICE, MINIMUM_DAYS_OFFSET, MARGIN_PRICING, DELETED_AT_DATETIME, DELETED_BY_OBJECT_ID, DELETED_BY_CLASS_ID, DELETED_BY_OBJECT_NAME, CTR_IS_DUET, HAS_DUET_ITEMS, WORD_ATTRIBUTES_TEXT_PREVIEW, WORD_ATTRIBUTES_TEXT_OBJECT_ID, WORD_ATTRIBUTES_TEXT_CLASS_ID, WORD_ATTRIBUTES_CHECKSUM, SENT_TO_ERP_DATETIME, STATUS_OBJECT_ID, STATUS_CLASS_ID, STATUS_OBJECT_NAME, LAST_SPEND_IMPORT_DATE, BUYER_SPECS_SUPPORT, VENDOR_SPECS_SUPPORT FROM clmuser.FCI_CONTRACT WHERE UNIQUE_DOC_NAME = ? AND CONTEXTID = ?
at com.sap.odp.common.db.AbstractDb.findWhere(AbstractDb.java:5823)
at com.sap.odp.common.db.AbstractDb.findWhere(AbstractDb.java:5760)
at com.sap.eso.contracts.ContractHome.findUniqueByDocName(ContractHome.java:96)
at com.sap.eso.contracts.importer.processors.AgreementProcessor.createNewHook(AgreementProcessor.java:479)
at com.sap.odp.doc.importer.AbsDocImportProcessor.processRow(AbsDocImportProcessor.java:165)
at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processRowInternal(CsvFileProcessor.java:1370)
at com.sap.odp.common.install.dataimport.csv.CsvFileProcessor.processFile(CsvFileProcessor.java:281)
at com.sap.odp.common.install.dataimport.xml.XmlImporter.importXmlObject(XmlImporter.java:249)
at com.sap.odp.common.install.dataimport.xml.XmlImportHandler.endElement(XmlImportHandler.java:155)
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.sap.odp.common.install.dataimport.xml.ImportXmlReader.importObjects(ImportXmlReader.java:141)
at com.sap.odp.common.install.dataimport.xml.ImportXmlReader.parse(ImportXmlReader.java:84)
at com.sap.odp.common.install.dataimport.xml.ImportXmlReader.parse(ImportXmlReader.java:73)
at com.sap.odp.common.install.dataimport.xml.XmlImporter.go(XmlImporter.java:164)
at com.sap.odp.install.actions.ProcessXmlImportFile.executeHook(ProcessXmlImportFile.java:170)
at com.sap.odp.install.actions.InstallAction.execute(InstallAction.java:203)
at com.sap.odp.install.engine.ScriptedImportEngine.runSingleItem(ScriptedImportEngine.java:319)
at com.sap.odp.install.engine.XmlImportEngine.execute(XmlImportEngine.java:128)
at com.sap.odp.install.imports.ImportController$ImportRunner.execute(ImportController.java:302)
at com.sap.odp.install.imports.ImportController$ImportRunner.run(ImportController.java:212)
at java.lang.Thread.run(Thread.java:708)

Let me know if you need additional details.

Regards

Sai