1. Using the SAP Ariba Adapter with Oracle Integration 3
  2. Troubleshoot the SAP Ariba Adapter
  3. Control Character Issues During Data Import/Export

Control Character Issues During Data Import/Export

The SAP Ariba Adapter throws runtime errors during data import or export if control characters are present in the input or sandbox data.

  • Import: If the data contains control characters, the SAP Ariba Adapter throws a runtime error.
  • Export: Errors arise when exporting the data from the sandbox if the data contains control characters.
Identify the errors through the logs or error messages. Logs or error messages provide specific details, which include the position of the control character in the data, as indicated by the # character. For example:
Error sending bytes: oracle.cloud.connector.api.CloudInvocationException: 
Please remove the following control characters from your data: Note: '#' denotes a 
control character. Column name:Description, Column value:aaa#bbb.

Address the errors related to control characters in data:

  1. Use the Skip Control Character field with the value in the SAP Ariba Adapter mapper.
  2. Set the value as follows:
    • True: The SAP Ariba Adapter removes control characters from the data and processes it.
    • False: The SAP Ariba Adapter throws a runtime error, including the position of the first control character encountered.
  3. Adjust this setting based on the requirements for processing the data.