How to replace special character on RA_INTERFACE_LINES_ALL.INTERFACE_LINE_ATTRIBUTE10 source DOO

Summary:

We are currently facing a significant challenge related to the RA_INTERFACE_LINES_ALL table, specifically regarding the INTERFACE_LINE_ATTRIBUTE10 sourced from DOO (Order Management).

As per standard configurations, this field contains the Trading Partner Item Number. However, we have encountered issues with certain customers using special characters, such as "&."

Content (please ensure you mask any confidential information):

In our specific case, the INTERFACE_LINE_ATTRIBUTE10 value is "X&XXXXXX" (INTERFACE_LINE_ID 1000000XXXXXXXX). Given our reliance on external integrations, it is imperative that we address and rectify this situation promptly.

While we recognize that INTERFACE_LINE_ATTRIBUTE10 may not be necessary for our purposes, it appears to be a key field for this table. Attempts have been made to modify the descriptive flexfield by assigning a constant value, but the issue persists. Furthermore, we explored the option of using a Procedure Call on BI to update this field, but unfortunately, this approach proved unsuccessful.