I’m trying to configure an Excel Migration Job to act on an API that accepts a single attribute, which is a string of keys. 

I wondered if anyone has had any experience in doing this or something similar.

This is the string I get from debug (without the carriage returns) that uses the POSITION_UTIL_API.Modify_Pos method…

              p0_ VARCHAR2(32000) :=

              'STRUCT_ID'||chr(31)||'16'||chr(30)||

              'POS_CODE'||chr(31)||'500042162'||chr(30)||

              'VALID_FROM'||chr(31)||'2023-05-22-00.00.00'||chr(30)||

              'VALID_TO'||chr(31)||'9999-12-31-00.00.00'||chr(30)||

              'OLD_POS_CODE'||chr(31)||'500042318'||chr(30)||

              'SUP_POS_CODE'||chr(31)||'500042319'||chr(30);

I’ve tried many variations in Excel like replacing the || with & and double-quoting like “’STRUCT_ID’”.