Support Note 185783
Email
Error: "A sequence of more than one item is not allowed as the first argument of fn:substring"
Issue

While replicating PurchaseOrderExportRequest or other documents from Ariba Procurement(P2P) to Cloud Integration Gateway(CIG) I have below error:

A sequence of more than one item is not allowed as the first argument of fn:substring() ("abc@dummyhost.com", " abc@dummyhost.com ")

Resolution

You need to add a loop to the item segment to make sure that the mapping is applied for all the subsequent items:

  1. Log in CIG.
  2. Click My Configuration > Mappings.
  3. Click in the pencil button for the document type that you are facing the issue.

Now you are in the mapping for this specific document type, do the following:

  1. Click with the right button in the line of the mapping that you are performing to the item segment.
  2. Click Target Variable > Position and click in the item segment from target structure(appears in the right side of the screen).
  3. Repeat the step 1 but this time click Add Source Condition.
  4. Click in the father segment of the field that you are mapping from the source structure(appears in the left side of the screen).
  5. A pop-up will appear, click Position Variable.
Cause

You have mapped a field in CIG mapping tool to a item segment using a substring function and have not added a loop, so CIG mapping is not considering subsequent items.

Additional Information

This Article applies for use cases where you have performed a mapping to an item segment with a substring function and after that start facing this error. If you want to get more information about the CIG mapping tool, please check this article: How to use CIG mapping tool.


Applies To

SAP Ariba Buying

Terms of Use  |  Copyright  |  Security Disclosure  |  Privacy